Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


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

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux