Thread: Create DB ends with error "FATAL: Ident authentication failed for user "postgres""
Create DB ends with error "FATAL: Ident authentication failed for user "postgres""
From
Fabricio Pedroso Jorge
Date:
Hi all,
PostgreSQL version...: 9.5.5[postgres@vm-ora12 ~]$ createdb -h localhost -p 5432 -U postgres dbdev
createdb: could not connect to database template1: FATAL: Ident authentication failed for user "postgres"
[root@vm-ora12 ~]# service postgresql-9.5 status
postgresql-9.5 (pid 18507) is running...
Why am i getting the above error while trying to create a new database?
Thanks for the attention and help.
--
Fabrício Pedroso Jorge.
Administrador de Banco de Dados
Administrador de Banco de Dados
Re: Create DB ends with error "FATAL: Ident authentication failed for user "postgres""
From
"Joshua D. Drake"
Date:
On 12/02/2016 09:58 AM, Fabricio Pedroso Jorge wrote: > Hi all, > /[root@vm-ora12 ~]# service postgresql-9.5 status > postgresql-9.5 (pid 18507) is running.../ > > Why am i getting the above error while trying to create a new database? See here: http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own.
Re: Create DB ends with error "FATAL: Ident authentication failed for user "postgres""
From
Fabricio Pedroso Jorge
Date:
Hi,
thanks for the attention and help.[root@vm-ora12 share]# cat postgresql.conf
data_directory = '/usr/pgsql-9.5/share'
hba_file = '/usr/pgsql-9.5/share/pg_hba.conf'
ident_file = '/usr/pgsql-9.5/share/pg_ident.conf'
[root@vm-ora12 share]# cat pg_hba.conf
local all all trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host all all 0.0.0.0/0 md5
2016-12-02 15:03 GMT-03:00 Joshua D. Drake <jd@commandprompt.com>:
On 12/02/2016 09:58 AM, Fabricio Pedroso Jorge wrote:Hi all,/[root@vm-ora12 ~]# service postgresql-9.5 status
postgresql-9.5 (pid 18507) is running.../
Why am i getting the above error while trying to create a new database?
See here:
http://stackoverflow.com/questions/2942485/psql-fatal-ident- authentication-failed-for- user-postgres
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
--
Fabrício Pedroso Jorge.
Administrador de Banco de Dados
Administrador de Banco de Dados
Re: Create DB ends with error "FATAL: Ident authentication failed for user "postgres""
From
Fabricio Pedroso Jorge
Date:
Hi,
i found out where the config files were. I connected to the postgres database, executed the "SHOW data_directory" command and edited the correct "pg_hba.conf". After that, the "createdb" command worked properly.2016-12-02 15:29 GMT-03:00 Fabricio Pedroso Jorge <fpjbito@gmail.com>:
Thanks again for the patience.After these changes, i restarted the service and i tryied to to create the DB, still without success.Actually, my installation didn't create the ".conf" files. What i have are the ".conf.sample", created at "/usr/pgsql-9.5/share" directory, so i created a copy of the "postgresql.conf" and "pg_hba.conf" and edited as follows:Hi,thanks for the attention and help.
[root@vm-ora12 share]# cat postgresql.conf
data_directory = '/usr/pgsql-9.5/share'
hba_file = '/usr/pgsql-9.5/share/pg_hba.conf'
ident_file = '/usr/pgsql-9.5/share/pg_ident.conf'
[root@vm-ora12 share]# cat pg_hba.conf
local all all trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host all all 0.0.0.0/0 md5--2016-12-02 15:03 GMT-03:00 Joshua D. Drake <jd@commandprompt.com>:On 12/02/2016 09:58 AM, Fabricio Pedroso Jorge wrote:Hi all,/[root@vm-ora12 ~]# service postgresql-9.5 status
postgresql-9.5 (pid 18507) is running.../
Why am i getting the above error while trying to create a new database?
See here:
http://stackoverflow.com/questions/2942485/psql-fatal-ident- authentication-failed-for-user -postgres
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.Fabrício Pedroso Jorge.
Administrador de Banco de Dados
--
Fabrício Pedroso Jorge.
Administrador de Banco de Dados
Administrador de Banco de Dados