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
