In a fix: lost superuser - Mailing list pgsql-general

From Ken
Subject In a fix: lost superuser
Date
Msg-id 5.0.2.1.0.20010513233904.01bc8180@mail.fcs.net
Whole thread Raw
List pgsql-general
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?

_Ken



pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: Re: Invoices
Next
From: Andrew Snow
Date:
Subject: Inheritance & Referential Integrity