Re: How to remove superuser - Mailing list pgsql-general

From John R Pierce
Subject Re: How to remove superuser
Date
Msg-id 4B9B0A25.9030003@hogranch.com
Whole thread Raw
In response to Re: How to remove superuser  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Bruce Momjian wrote:
> Also, you can do:
>     NET USER postgres /delete
>
> as an administrator.
>


or NET USER postgres *

and then enter a new password.   I dislike deleting the account in case
there are any files left behind by the old postgres such as the old
pgdata directory, a new one is a different account.

but on vista and win7, with the UAC privilege masking thing, you have to
be runnign CMD as Administrator before you can do this, as the regular
cmd prompt is unprivileged and won't invoke the UAC elevation stuff.
you can right-click Run As Admin the shortcut to CMD to get a privileged
command prompt.



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How to remove superuser
Next
From: Pavel Stehule
Date:
Subject: Re: Function with DEFAULT arguments