postgresql 7 user passwords dont work ?????
users dont seem to need password in postgres 7 on red hat linux
6.2, compiled from source.
I do an:
alter user nsadmin with password 'whatever';
And then when I do an:
psql -u -d mydb
username: nsadmin password: NOTwhatever
IT STILL LETS ME IN ????
This should not be so should it ?
please advise, thanks
streethockey@ureach.com
________________________________________________
Get your own "800" number - Free
Free voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
su - postgres
chmod u+w ~/data/pg_hba.conf
vi ~/data/pg_hba.conf
chmod u-w ~/data/pg_hba.conf
Eric Webber wrote:
Show quoted text
users dont seem to need password in postgres 7 on red hat linux
6.2, compiled from source.I do an:
alter user nsadmin with password 'whatever';
And then when I do an:
psql -u -d mydb
username: nsadmin password: NOTwhatever
IT STILL LETS ME IN ????
This should not be so should it ?
please advise, thanks
streethockey@ureach.com
________________________________________________
Get your own "800" number - Free
Free voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
Isn't this the
local all trust
host all 127.0.0.1 255.255.255.255 trust
lines in the default pg_hba.conf file that comes with the distribution?
-emile
On Wed, 30 Aug 2000, Eric Webber wrote:
Show quoted text
users dont seem to need password in postgres 7 on red hat linux
6.2, compiled from source.I do an:
alter user nsadmin with password 'whatever';
And then when I do an:
psql -u -d mydb
username: nsadmin password: NOTwhatever
IT STILL LETS ME IN ????
This should not be so should it ?
please advise, thanks
streethockey@ureach.com
________________________________________________
Get your own "800" number - Free
Free voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag