My superuser (postgres) had a password.
I attempted to change it by doing (and not thinking very much):
template1=# alter user postgres with password '';
ALTER USER
template1=# \q
After what I am unable to connect anymore as superuser, which is a
big problem (plain [ENTER] on the password prompt is rejected)
Is there any way to change the superuser password without completely
deleting my postgreSQL installation which is in use in production ?
(I have complete unix root access)
Thanks to all in advance.
I did not found anything relevant online.
Patrick.
