Re: Postgresql Login problem

Check your pg_hba.conf file if the method is password, then create a pasword for postgres userpsql yourdbalter user postgres set password = 'pasword'if you don't want to do that, change pg_hba.conf file and modify the method to trustthen /etc/init.t/./postgresql reloadHope this will helpSubject: [ADMIN] Postgresql Login problemDate: Fri, 3 Aug 2007 12:54:10 +0600From: lal(at)apiit(dot)lkTo: pgsql-admin(at)postgresql(dot)org

I am trying to use PostgreSQL ver. 8.1.4 that comes with Red
Hat Enterprise Linux 5.

I cannot log into the postgres server as postgres, it gives
the error message “password authentication failed for user “postgres”.

Is there a default password?

How can I start working with postgres?

Regards.

Lal Bopearatchy