Re: In a fix: lost superuser

Ken wrote:
>
> Is there any way to reset the superuser password
> if it has been lost? I thought it was set properly
> but it is now among the ethers, and none of the other
> accounts have superuser privileges. I've tried replacing
> pg_shadow with another in hopes of resetting the darn
> thing, but alas. Do I have to re-install postgres?
> Is there any way for the root user to reset the password?

You can modify pg_hba.conf in order to "trust" the PG_USER
setting of the client. Then you can modify the internal system
tables in order to reset the password.

With kind regards / Mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter
holger@klawitter.de                             http://www.klawitter.de