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 B47249FA279 for ; Tue, 23 May 2006 17:30:52 -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 38639-10 for ; Tue, 23 May 2006 17:30:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.203]) by postgresql.org (Postfix) with ESMTP id 7E7479FA169 for ; Tue, 23 May 2006 17:30:36 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 18so1403652nzp for ; Tue, 23 May 2006 13:30:35 -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=SserngwLKEF2lALqURnyQVGaORjZNoAAA+k/2fawMaoQtafsta8GDS2kPt03rq7BCGqFBCDrA2MeBR4TZGQfvt40yk3yrWHtg2TySvXEgEmDQH7dSscqxXGcuRQnJ1Iaot+RZGh1HP6c5L/CYbf1xpPxtOFhgp08b2I4JIciiL0= Received: by 10.64.125.17 with SMTP id x17mr2871535qbc; Tue, 23 May 2006 13:30:35 -0700 (PDT) Received: by 10.65.232.16 with HTTP; Tue, 23 May 2006 13:30:34 -0700 (PDT) Message-ID: Date: Wed, 24 May 2006 01:30:34 +0500 From: "Shoaib Mir" To: pgsql-admin@postgresql.org Subject: Re: Re : Re: Authentication troubleshooting using psql In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_100347_2835017.1148416234989" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/331 X-Sequence-Number: 21863 ------=_Part_100347_2835017.1148416234989 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline The way you are reloading is not the right way to reload the configurations= . As you are on Windows and have used the installer so a right way to reload your configuration after you have made the change to pg_hba.conf file will be to: Go to Start --> Programs --> PostgreSQL --> Reload Configuration Now for connecting to a database from the SQL prompt use \c dbname I hope this helps but do try the latest installer as mentioned in the last email for 8.1.4 as this has a few things fixed which can help you. /Shoaib On 5/24/06, Tahir Tamba wrote: > > Dear Mir, > > Thank you for answer, I have edited the pg_hba file by changing the metho= d > .md5" to "trust". So I've tried the reload command in psql prompt : > "postgres=3D#\pg_ctl reload" to update the file, I get the following mess= age: > "Query buffer is empty" and commands arguments are ignored. > > Thank again for your help > > Tahir Tamba > > > > > *De*: Shoaib Mir > > *Date*: Mardi, Mai 23, 2006 1:33 pm > > *Objet*: Re: [ADMIN] Authentication troubleshooting using psql > > > 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 psql > > > 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 work > > > 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_100347_2835017.1148416234989 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline The way you are reloading is not the right way to reload the configurations= . As you are on Windows and have used the installer so a right way to reloa= d your configuration after you have made the change to pg_hba.conf file wil= l be to:

Go to Start --> Programs --> PostgreSQL --> Reload Configu= ration

Now for connecting to a database from the SQL prompt use
=
\c dbname

I hope this helps but do try the latest installer as m= entioned in the last email for=20 8.1.4 as this has a few things fixed which can help you.

/Shoaib
=
On 5/24/06, Tahir Tamba <tam= ba.tahir@courrier.uqam.ca > wrote:

Dear Mir,

Thank you for answer, I have edited the pg_hba file by changing the meth= od .md5" to "trust". So I've tried the reload command in psq= l prompt : "postgres=3D#\pg_ctl reload" to update the file, = I get the following message: "Query buffer is empty" and commands= arguments are ignored.

Thank again for your help

Tahir Tamba

 


De: Shoaib Mir <sho= aibmir@gmail.com>

Date: Mardi, Mai 23, 2006 1:33 pm

Objet: Re: [ADMIN] Authentication troubleshooting using psql

> Try using
>
> \c dbname
>
> and if = you want to get rid of the asking password thing you can
> change yo= ur
> authentication method from 'md5' to 'trust' in your pg_hba.conf= =20
> file and
> then reload the settings using "pg_ctl relo= ad"
>
> /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. Using
> Postgres> with PGAdmin III, everything wor= ks well. But when I'm=20
> trying to use the psql
> > terminal interface to connect= into my database  psql ask me to
> enter my
> > pass= word and when trying to enter my password, nothing happens
> from my= =20
> > keyboard.
> > Exemple : postgres=3D# \connectdb pos= tgres
> > Password for postgres user: unable to type my password cursor > doesn't work
> > And when I press Enter tab I get the follo= wing error:
> > "FATAL: password authentication failed for u= ser  Postgres=20
> >
> > who can help me to solve this=
> > Thank
> >
> >
> >
> >= ; Tahir Tamba

> >
> >
> >
> >
> >
> > -----------------------= ----(end of broadcast)--------------------
> -------
> > T= IP 2: Don't 'kill -9' the postmaster
> >
> >
> &= gt;=20
> >
>


------=_Part_100347_2835017.1148416234989--