I was just trying to get a live backup of my database and had the following error:
uselton]# pg_dumpall > /tmp/osp5_pgsql.dump
pg_dumpall: could not connect to database "template1": FATAL: Password authentication failed for user "root"
If it really is asking for the 'root' password I am certainly giving it correctly. I am root as I issue the command as well. I've tried a few other guesses at what it might _really_ be wanting (including using an explicit '-h host -p port'), but with no better luck. Any hints would be most appreciated.
pgsql-novice by date
|Next:||From: Relyea, Mike||Date: 2007-08-10 19:12:24|
|Subject: Re: pg_dump/pg_dumpall|
|Previous:||From: Oliver Elphick||Date: 2007-08-10 16:12:01|
|Subject: Re: [NOVICE] Install two different versions of postgres whichshould run in parallel|