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
> 
> [EMAIL PROTECTED]
> 
> ________________________________________________
> Get your own "800" number - Free
> Free voicemail, fax, email, and a lot more
> http://www.ureach.com/reg/tag

Reply via email to