Обсуждение: Authentication troubleshooting using psql
Hi Guys, I install Postgres 8.1.3 on WinXP Pro OS using msi.exe. Using Postgres with PGAdmin III, everything works well. But whenI'm trying to use the psql terminal interface to connect into my database psql ask me to enter my password and whentrying 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
Вложения
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
\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
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 whenI'm trying to use the psql terminal interface to connect into my database psql ask me to enter my password and whentrying 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. +