[GENERAL] Monitoring Tool for PostgreSQL

2017-10-18 Thread Fabricio Pedroso Jorge
Hi all, is there a "official" monitoring tool for PostgreSQL databases? For example, i come from Oracle Database, and there, we have Enterprise Manager to monitor and administrer the product... is there such a similar tool for PostgreSQL? Thanks for the attention. -- *Fabrício Pedroso

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

2016-12-02 Thread Fabricio Pedroso Jorge
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 GM

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

2016-12-02 Thread Fabricio Pedroso Jorge
yied 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 >&

[GENERAL] Create DB ends with error "FATAL: Ident authentication failed for user "postgres""

2016-12-02 Thread Fabricio Pedroso Jorge
Hi all, PostgreSQL version...: 9.5.5 OS...: Oracle Linux 6.5 64 bits I am quite new in the PostgreSQL world and i'm trying to create a new db with the following sintax, using the "postgres" OS user: [postgres@vm-ora12 ~]$ createdb -h localhost -p 5432 -U