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.2016-12-02 15:29 GMT-03:00 Fabricio Pedroso Jorge <fpjbito@xxxxxxxxx>:
Thanks again for the patience.After these changes, i restarted the service and i tryied to to create the DB, still without success.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:Hi,thanks for the attention and help.
[root@vm-ora12 share]# cat postgresql.conf
data_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.conf
local all all trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host all all 0.0.0.0/0 md5--2016-12-02 15:03 GMT-03:00 Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx>: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
--
Fabrício Pedroso Jorge.
Administrador de Banco de Dados
Administrador de Banco de Dados
