Обсуждение: 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