pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Authentication troubleshooting using psql
3+ messages / 3 participants
[nested] [flat]

* Authentication troubleshooting using psql
@ 2006-05-23 17:36  Tahir Tamba <tamba.tahir@courrier.uqam.ca>
  0 siblings, 2 replies; 3+ messages in thread

From: Tahir Tamba @ 2006-05-23 17:36 UTC (permalink / raw)
  To: pgsql-admin

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=# \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

Attachments:

tamba.tahir.vcf (text/x-vcard, 226B) download begin:vcard n:Tamba;Tahir fn: Tahir Tamba tel;home:(514) 526-7543 version:2.1 email;internet:tamba.tahir@courrier.uqam.ca title:Conseiller en aménagement du territoire et Systèmes d'information géographique end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: Authentication troubleshooting using psql
@ 2006-05-23 18:33  Shoaib Mir <shoaibmir@gmail.com>
  parent: Tahir Tamba <tamba.tahir@courrier.uqam.ca>
  1 sibling, 0 replies; 3+ messages in thread

From: Shoaib Mir @ 2006-05-23 18:33 UTC (permalink / raw)
  To: pgsql-admin

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. 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=# \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
>
>
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Authentication troubleshooting using psql
@ 2006-05-23 19:00  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Tahir Tamba <tamba.tahir@courrier.uqam.ca>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2006-05-23 19:00 UTC (permalink / raw)
  To: Tahir Tamba <tamba.tahir@courrier.uqam.ca>; +Cc: pgsql-admin

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=# \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

We did fix some prompting problems on Win32 in 8.1.4 (it was released
today).  Please try that and let us know.  Thanks.

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-05-23 19:00 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-23 17:36 Authentication troubleshooting using psql Tahir Tamba <tamba.tahir@courrier.uqam.ca>
2006-05-23 18:33 ` Shoaib Mir <shoaibmir@gmail.com>
2006-05-23 19:00 ` Bruce Momjian <pgman@candle.pha.pa.us>

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