[GENERAL] 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
Re: [GENERAL] How to remove superuser
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to remove superuser
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 br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to remove superuser
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general