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

Have you supplied password to initdb command?
if not there are two ways

1) In pg_hba.conf file set athuntication method =trust instead of password. (if you want to keep trust method for all time)

2) Do the above step then login into postgres database and the issue command

alter role postgres password 'your password goes here'

then again open pg_hba.con and set authuntication method to password.


rember these changes requires server restart or relaod.
with regards
ashish...



----- Original Message -----
From: Dr. Lal Bopearachchi
To: pgsql-admin@postgresql.org
Sent: Friday, August 03, 2007 12:24 PM
Subject: [ADMIN] Postgresql Login problem


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

"Dr. Lal Bopearachchi" <lal@apiit.lk> writes:
> 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?

No. The default Red Hat configuration doesn't use passwords --- it is
set up for "ident" authorization, instead. Have you changed any
configuration files? What are the exact commands you are trying?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match