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





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
Wed, 18 Dec 2002 17:20:40 +0800
postgresql <postgresql@db.pku.edu.cn>
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


18 Dec 2002 10:17:39 +0000
Oliver Elphick <olly@lfix.co.uk>
Re: a problem in authority