pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAuthentication 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>
2006-05-23 18:33 ` Re: Authentication troubleshooting using psql Shoaib Mir <shoaibmir@gmail.com>
2006-05-23 19:00 ` Re: Authentication troubleshooting using psql Bruce Momjian <pgman@candle.pha.pa.us>
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 17:36 Authentication troubleshooting using psql Tahir Tamba <tamba.tahir@courrier.uqam.ca>
@ 2006-05-23 18:33 ` Shoaib Mir <shoaibmir@gmail.com>
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 17:36 Authentication troubleshooting using psql Tahir Tamba <tamba.tahir@courrier.uqam.ca>
@ 2006-05-23 19:00 ` Bruce Momjian <pgman@candle.pha.pa.us>
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