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