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

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.

Thanks for the attention.

2016-12-02 15:29 GMT-03:00 Fabricio Pedroso Jorge <fpjbito(at)gmail(dot)com>:

> 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(at)vm-ora12 share]# cat postgresql.confdata_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(at)vm-ora12 share]# cat pg_hba.conflocal all
> all trusthost all
> all 127.0.0.1/32 <http://127.0.0.1/32> trusthost
> all all ::1/128 trusthost all
> all 0.0.0.0/0 <http://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(at)commandprompt(dot)com>:
>
>> On 12/02/2016 09:58 AM, Fabricio Pedroso Jorge wrote:
>>
>>> Hi all,
>>>
>>
>> /[root(at)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 <http://certificacaodb.com.br>
>
> *Resumo Profissional:*
> http://br.linkedin.com/in/fabriciojorge
>
> *Contatos:*
> + 55 91 988991116 <+55%2091%2098899-1116>
> skype: fabricio.pedroso.jorge
> fpjbito(at)gmail(dot)com
>

--
*Fabrício Pedroso Jorge.*

Administrador de Banco de Dados

certificacaobd.com.br <http://certificacaodb.com.br>

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

*Contatos:*
+ 55 91 988991116
skype: fabricio.pedroso.jorge
fpjbito(at)gmail(dot)com