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
