| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | acuselton(at)lbl(dot)gov, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: pg_dump/pg_dumpall |
| Date: | 2007-08-10 19:13:31 |
| Message-ID: | 290552.38390.qm@web31806.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
--- "Andrew C. Uselton" <acuselton(at)lbl(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2007-08-10 19:20:05 | Re: pg_dump/pg_dumpall |
| Previous Message | Relyea, Mike | 2007-08-10 19:12:24 | Re: pg_dump/pg_dumpall |