Thread: 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
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: > 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: > > 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