From: Ashish Karalkar <ashish.karalkar@info-spectrum.com>
To: Dr. Lal Bopearachchi <lal@apiit.lk>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql Login problem
Date: Wed, 8 Aug 2007 19:36:05 +0530
Message-ID: <001901c7d9c5$46800c10$170211ac@LIONKING.COM> (raw)
References: <C10E397BB737C94C9CC831A663303A6219F5CA@mail2.apiit.ems>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ashish.karalkar@info-spectrum.com, lal@apiit.lk
Subject: Re: Postgresql Login problem
In-Reply-To: <001901c7d9c5$46800c10$170211ac@LIONKING.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox