Re: How to remove superuser

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Harry Gold <harrygold85(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to remove superuser
Date: 2010-03-13 03:44:37
Message-ID: 4B9B0A25.9030003@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-03-13 05:20:04 Re: Function with DEFAULT arguments
Previous Message Bruce Momjian 2010-03-13 02:56:35 Re: How to remove superuser