Thread: 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.