single-user mode solve my problem.thank you ,Bruce!
在 2011-3-11 下午6:35，"Bruce Momjian" <bruce@xxxxxxxxxx>写道：
> 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@xxxxxxxxxx> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
> 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@xxxxxxxxxx> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
