How to pg_dumpall without root password

From: Dat Chu <dattanchu(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to pg_dumpall without root password
Date: 2007-07-11 06:10:21
Message-ID: 1184134221.547250.284220@d55g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-07-11 07:07:34 Re: How to pg_dumpall without root password
Previous Message Tom Lane 2007-07-11 03:15:31 Re: exit code -1073741819