Re: [GENERAL] How to pg_dumpall without root password

2007-07-12 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > If you're worried about having the system insecure even transiently > against local bad guys, it's possible to do this without opening any > hole, but it requires taking the DB down for a few minutes so you can > do the password change in standalone mode. An

Re: [GENERAL] How to pg_dumpall without root password

2007-07-12 Thread Tom Lane
Dat Chu <[EMAIL PROTECTED]> writes: > 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. Edit pg_

[GENERAL] How to pg_dumpall without root password

2007-07-12 Thread Dat Chu
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

Re: [GENERAL] How to pg_dumpall without root password

2007-07-11 Thread Hannes Dorbath
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 ha