single-user mode solve my problem.thank you ,Bruce!
在 2011-3-11 下午6:35,"Bruce Momjian" <
bruce@momjian.us>写道:
> Jov wrote:
>> hi pgers
>>
>> I use pg9.0.3 and do some mistake which cause my superuser
>> non-super,is there any way I can get back the superuser privilege? the
>> superuser is the only super in my pg server ,without it ,I will not
>> able to create new user or new database.
>
> You can modify pg_hba.conf to 'trust' if you lost the password. If you
> removed the row, I think you need to start the server in single-user
> mode.
>
> --
> Bruce Momjian <
bruce@momjian.us>
http://momjian.us > EnterpriseDB
http://enterprisedb.com>
> + It's impossible for everything to be true. +