Re: In a fix: lost superuser

Thanks for all the great responses :)
They worked as expected.
_Ken

At 07:39 AM 5/14/01 +0000, you wrote:
>Ken <mailinglists(at)creason(dot)com> wrote:
> > Is there any way to reset the superuser password if it has been lost?
>
>I haven't tried it, but I guess the following should work:
>- As root, edit the pg_hba.conf to allow access without the postgres
> superuser password
> "host all 127.0.0.1 255.255.255.255 trust"
>- connect to postgres
> "psql -U postgres template1"
>- put a new password on the postgres user
> "alter user postgresql with password 'fubar'"
>- restore the old pg_hba.conf
>
>HTH,
>Ray
>--
>NATUURLIJK krijg je er geen signaal doorheen - het is *dark* fibre.
> jtv
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org