a problem in authority

Started by postgresqlabout 23 years ago2 messages
#1postgresql
postgresql@db.pku.edu.cn

Hi, all
I have installed the Postgresql 7.3 . But I think something is wrong with authority.
I have made the following operations:
1. I enter the psql and run 'alter user postgres with password 'postgres''
2. I change the pg_hba.conf and set the auth_type from 'trust' to 'password'
3. Then I can not connect to server.
I have test connect from local or connect from host, but it just return 'authority fail for user postgres'.
I can connect to postgresql 7.23 successfully after above steps;
Great thanks for any message.
Josh

#2Oliver Elphick
olly@lfix.co.uk
In reply to: postgresql (#1)
Re: a problem in authority

On Wed, 2002-12-18 at 09:20, postgresql wrote:

2. I change the pg_hba.conf and set the auth_type from 'trust' to
'password'

3. Then I can not connect to server.

Try using 'md5' instead of 'password' in pg_hba.conf.

--
Oliver Elphick <olly@lfix.co.uk>
LFIX Limited