X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D25CB9FA279 for ; Tue, 23 May 2006 15:33:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 26027-04 for ; Tue, 23 May 2006 15:33:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id 0E43F9FA169 for ; Tue, 23 May 2006 15:33:24 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 18so1377846nzp for ; Tue, 23 May 2006 11:33:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=D/YK/PyzW7j7TXSuRsMialGfOu5D1QaOSXBudpnIp39vLEG4v3vThKANT9D5+uKiH+naWoNHqUyw83+5ovLv6t3p0LCvKiUY0NxuoP7Cp9zWPAg8V0e6/WJtjzcEEqU/5VcIZ8ceWYb5/JSQExV5U6ODHrQKv/CtFNVfBK+H6dI= Received: by 10.65.105.17 with SMTP id h17mr2180525qbm; Tue, 23 May 2006 11:33:20 -0700 (PDT) Received: by 10.65.232.16 with HTTP; Tue, 23 May 2006 11:33:20 -0700 (PDT) Message-ID: Date: Tue, 23 May 2006 23:33:20 +0500 From: "Shoaib Mir" To: pgsql-admin@postgresql.org Subject: Re: Authentication troubleshooting using psql In-Reply-To: <870838b9c9b.447301cd@courrier.uqam.ca> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_98226_5336523.1148409200523" References: <870838b9c9b.447301cd@courrier.uqam.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/328 X-Sequence-Number: 21860 ------=_Part_98226_5336523.1148409200523 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Try using \c dbname and if you want to get rid of the asking password thing you can change your authentication method from 'md5' to 'trust' in your pg_hba.conf file and then reload the settings using "pg_ctl reload" /Shoaib On 5/23/06, Tahir Tamba wrote: > > Hi Guys, > > I install Postgres 8.1.3 on WinXP Pro OS using msi.exe. Using Postgres > with PGAdmin III, everything works well. But when I'm trying to use the p= sql > terminal interface to connect into my database psql ask me to enter my > password and when trying to enter my password, nothing happens from my > keyboard. > Exemple : postgres=3D# \connectdb postgres > Password for postgres user: unable to type my password cursor doesn't wor= k > And when I press Enter tab I get the following error: > "FATAL: password authentication failed for user Postgres > > who can help me to solve this > Thank > > > > Tahir Tamba > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > > > ------=_Part_98226_5336523.1148409200523 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Try using

\c dbname

and if you want to get rid of the asking password thing you can change your authentication method from 'md5' to 'trust' in your pg_hba.conf file and then reload the settings using "pg_ctl reload"

/Shoaib

On 5/23/06, Tahir Tamba <tamba.tahir@courrier.uqam.ca> wrote: Hi Guys,

I install Postgres 8.1.3 on WinXP Pro OS using msi.exe. Usi= ng Postgres with PGAdmin III, everything works well. But when I'm trying to= use the psql terminal interface to connect into my database  psq= l ask me to enter my password and when trying to enter my password, nothing= happens from my keyboard.
Exemple : postgres=3D# \connectdb postgres
Password for postgres use= r: unable to type my password cursor doesn't work
And when I press Enter= tab I get the following error:
"FATAL: password authentication fai= led for user  Postgres

who can help me to solve this
Thank



Tahir Tamba




---------------------------(end of broadcast)--------= -------------------
TIP 2: Don't 'kill -9' the postmaster




------=_Part_98226_5336523.1148409200523--