Re: pg_dump/pg_dumpall - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: pg_dump/pg_dumpall
Date
Msg-id 290552.38390.qm@web31806.mail.mud.yahoo.com
Whole thread Raw
In response to pg_dump/pg_dumpall  ("Andrew C. Uselton" <acuselton@lbl.gov>)
List pgsql-novice
--- "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.



pgsql-novice by date:

Previous
From: "Andrew C. Uselton"
Date:
Subject: pg_dump/pg_dumpall
Next
From: Alan Hodgson
Date:
Subject: Re: pg_dump/pg_dumpall