This is a discussion on Re: Re : Re: Authentication troubleshooting using psql within the pgsql Admins forums, part of the PostgreSQL category; --> The way you are reloading is not the right way to reload the configurations.. As you are on Windows ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 <tamba.tahir@courrier.uqam.ca> wrote: > > Dear Mir, > > Thank you for answer, I have edited the pg_hba file by changing the method > .md5" to "trust". So I've tried the reload command in psql prompt : > "postgres=#\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 <shoaibmir@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 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 > > > > > > > > > > > > > > > > |
| Thread Tools | |
| Display Modes | |
|
|