User Admin in pgsql

From: daxiawj <daxiawj(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: User Admin in pgsql
Date: 2004-12-15 08:14:48
Message-ID: 1103098489.3833.12.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,
After I Updatded my pgsql from 7.3 to 7.4.6 in debian with "aptitude", I
found that my admin user account's password has gone--everytime when I
login into psql, I don't need type my password any more, and every
other user account too.
I know that a SQL command Alter could de used to alternate my password,
I tried it like this:" alter user xxxx with encrypted password
'xxxxxxx';", But it doesn't work at all.
What can I do?

BTW: My OS is GNU/Debian Sid 3.1, PostGreSQL 7.4.6 Now.
Thank you!
--
Wang Jun@ Atmos. Dep. of Nju Nanjing Jiangsu China.
GNU is Not Unix, BSD is Powerful,
Ada is Beautiful, Nju is Graceful.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2004-12-15 08:41:25 Re: User Admin in pgsql
Previous Message Iain 2004-12-15 05:41:02 Re: Tyan Thunder MB for postgres server