| From: | Holger Klawitter <holger(at)klawitter(dot)de> |
|---|---|
| To: | Ken <mailinglists(at)creason(dot)com>, "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: In a fix: lost superuser |
| Date: | 2001-05-14 07:14:38 |
| Message-ID: | 3AFF85DE.877FEA79@klawitter.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)klawitter(dot)de http://www.klawitter.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J.H.M. Dassen Ray | 2001-05-14 07:39:25 | Re: In a fix: lost superuser |
| Previous Message | Renaud Thonnart | 2001-05-14 06:59:59 | Re: table inheritance |