Обсуждение: How to remove superuser

Hello im running Windows XP and removed an older version of Postgres using windows software remover, now when i try to install the newest one it keeps asking for a password from  Superuser? Thanks

Harry Gold wrote:
> Hello im running Windows XP and removed an older version of Postgres
> using windows software remover, now when i try to install the newest
> one it keeps asking for a password from  Superuser? Thanks

go into Windows' "Local Users and Groups" in Computer Management, and
set a random password for the existing 'postgres' user account (its a
special very UN-privileged account, has only the priv to run as a
service), then tell the installer what that password is.

John R Pierce wrote:
> Harry Gold wrote:
> > Hello im running Windows XP and removed an older version of Postgres
> > using windows software remover, now when i try to install the newest
> > one it keeps asking for a password from  Superuser? Thanks
>
> go into Windows' "Local Users and Groups" in Computer Management, and
> set a random password for the existing 'postgres' user account (its a
> special very UN-privileged account, has only the priv to run as a
> service), then tell the installer what that password is.

Also, you can do:

    NET USER postgres /delete

as an administrator.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do

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.