Re: [GENERAL] Newbe questions: Setting Passwords
Hi, You could use the following...;-) psql -U postgres template1 UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres'; You could also use GRANT or create other users as well... kindly check the administrative section of your documentation...;-) Cheers, John Clark ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Newbe questions: Setting Passwords
Hi, Thanks for your advice. I set my password as you advised below, however I'm still having some problems connecting. When I try to connect I get the following error message: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password=' is not in 'pg_shadow' When connecting I'm using username postgres and the password that I used when I updated the pg_shadow file as suggested. Any ideas??? Hi, You could use the following...;-) psql -U postgres template1 UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres'; ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Newbe questions: Setting Passwords
Anatole Varin wrote: Hi, Thanks for your advice. I set my password as you advised below, however I'm still having some problems connecting. When I try to connect I get the following error message: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password=' is not in 'pg_shadow' When connecting I'm using username "postgres" and the password that I used when I updated the pg_shadow file as suggested. Any ideas??? Hi, You could use the following...;-) psql -U postgres template1 UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres'; I don't believe I've had the pleasure of this problem before...;-) Would you mind showing us your exact command, that you tried to execute to get into your postgresql database? (Maybe a little cut and paste...;-)) Is your PostgreSQL database part of your server? Or at another server... And kindly check this file (I assuming youe got PostgreSQL 7.x) /var/lib/pgsql/data/postmaster.opts.default If you have a "-i" in this file. HTH, Cheers, John Clark ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Newbe questions: Setting Passwords
Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password=' is not in 'pg_shadow' Some kind of syntactic confusion at the client end, evidently: the software is taking password= as your username, which I'm pretty sure is not what you intended. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])