On 11.07.2007 08:10, Dat Chu wrote:
I am the new sysadmin and was given the task to move a postgresql
installation from one box to another. So I want to do pg_dumpall .
However, there is no record of postgresql superuser/root password. I
do have root access to the system however.
Does anyone have a suggestion on what I should do?
Locate pg_hba.conf (should reside in $PGDATA), open it in an editor,
replace md5 with trust.
--
Regards,
Hannes Dorbath
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly