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 <fpjb...@gmail.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@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 <+55%2091%2098899-1116> > skype: fabricio.pedroso.jorge > fpjb...@gmail.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 fpjb...@gmail.com
