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

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
skype: fabricio.pedroso.jorge
fpjbito(at)gmail(dot)com