Re: pg_dump/pg_dumpall

--- "Andrew C. Uselton" <acuselton@lbl.gov> wrote:

> Greetings,
>   I was just trying to get a live backup of my database and had the following error:
>
> uselton]# pg_dumpall   > /tmp/osp5_pgsql.dump
> Password:
> pg_dumpall: could not connect to database "template1": FATAL:  Password authentication failed
> for user "root"
>

Actually, if you don't specify a DB username, pg_dumpall uses the calling OS username as a
default.  It this user doesn't exist, or you enter the wrong password for the DB you will get this
error.
Regards,
Richard Broersma Jr.