Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7FB979FC0CB for ; Wed, 8 Aug 2007 11:06:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 85178-07 for ; Wed, 8 Aug 2007 11:06:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pro33.abac.com (pro33.abac.com [66.226.64.34]) by postgresql.org (Postfix) with ESMTP id 0CA1A9FBDF3 for ; Wed, 8 Aug 2007 11:06:21 -0300 (ADT) Received: from ashishk (61.17.93.7.static.nagpur.vsnl.net.in [61.17.93.7] (may be forged)) (authenticated bits=0) by pro33.abac.com (8.14.1/8.14.1) with ESMTP id l78E660F008219 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Wed, 8 Aug 2007 07:06:11 -0700 (PDT) (envelope-from ashish.karalkar@info-spectrum.com) Message-ID: <001901c7d9c5$46800c10$170211ac@LIONKING.COM> From: "Ashish Karalkar" To: "Dr. Lal Bopearachchi" Cc: References: Subject: Re: Postgresql Login problem Date: Wed, 8 Aug 2007 19:36:05 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0014_01C7D9F3.5C6B88A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/67 X-Sequence-Number: 26398 This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C7D9F3.5C6B88A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Have you supplied password to initdb command? if not there are two ways 1) In pg_hba.conf file set athuntication method =3Dtrust 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=20 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 -----=20 From: Dr. Lal Bopearachchi=20 To: pgsql-admin@postgresql.org=20 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". =20 Is there a default password? =20 How can I start working with postgres? =20 Regards. =20 Lal Bopearatchy ------=_NextPart_000_0014_01C7D9F3.5C6B88A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Have you supplied password to initdb=20 command?
if not there are two ways
 
1) In pg_hba.conf file set = athuntication method=20 =3Dtrust instead of  password. (if you want to keep trust method = for all=20 time)
 
2) Do the above step then login into = postgres=20 database and the issue command
 
alter role postgres password 'your = password=20 goes here'
 
then again open pg_hba.con and set = authuntication=20 method to password.
 
 
rember these changes requires server = restart or=20 relaod.
with regards
ashish...
 
 
 
----- Original Message -----
From:=20 Dr. Lal = Bopearachchi=20
Sent: Friday, August 03, 2007 = 12:24=20 PM
Subject: [ADMIN] Postgresql = Login=20 problem

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

I cannot log into the = postgres=20 server as postgres, it gives the error message =93password = authentication failed=20 for user =93postgres=94.

 

Is there a default=20 password?

 

How can I start working = with=20 postgres?

 

Regards.

 

Lal=20 = Bopearatchy

= ------=_NextPart_000_0014_01C7D9F3.5C6B88A0--