Re: Create DB ends with error "FATAL: Ident authentication failed for user "postgres""

[Fabricio Pedroso Jorge <fpjbito@xxxxxxxxx>]

Hi,

   thanks for the attention and help.

   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:

[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

After these changes, i restarted the service and i tryied to to create the DB, still without success.

Thanks again for the patience.

2016-12-02 15:03 GMT-03:00 Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx>:

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

certificacaobd.com.br

Resumo Profissional:
http://br.linkedin.com/in/fabriciojorge

Contatos:
+ 55 91 988991116
skype: fabricio.pedroso.jorge
fpjbito@xxxxxxxxx