Jov wrote: > hi pgers > > I use pg9.0.3 and do some mistake which cause my superuser > non-super,is there any way I can get back the superuser privilege? the > superuser is the only super in my pg server ,without it ,I will not > able to create new user or new database.
You can modify pg_hba.conf to 'trust' if you lost the password. If you removed the row, I think you need to start the server in single-user mode. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
