From: | Fabricio Pedroso Jorge <fpjbito(at)gmail(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Create DB ends with error "FATAL: Ident authentication failed for user "postgres"" |
Date: | 2016-12-02 18:29:51 |
Message-ID: | CAJDTwK1RQUr+RvRbkaPiabmL5u_w56Lte6kdFcuZMseOR9AkqA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2016-12-02 18:46:49 | Re: Moving pg_xlog |
Previous Message | Joshua D. Drake | 2016-12-02 18:03:13 | Re: Create DB ends with error "FATAL: Ident authentication failed for user "postgres"" |