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.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@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 <j...@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

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

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

*Contatos:*
+ 55 91 988991116
skype: fabricio.pedroso.jorge
fpjb...@gmail.com

Reply via email to