From: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(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:12:24 |
Message-ID: | 1806D1F73FCB7F439F2C842EE0627B18065BED6B@usa0300ms01.na.xerox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Try adding "-U postgres" to connect as the correct user.
http://www.postgresql.org/docs/8.2/interactive/app-pg-dumpall.html
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Andrew C.
Uselton
Sent: Friday, August 10, 2007 2:49 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] pg_dump/pg_dumpall
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"
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.
Cheers,
Andrew
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-08-10 19:13:31 | Re: pg_dump/pg_dumpall |
Previous Message | Andrew C. Uselton | 2007-08-10 18:49:01 | pg_dump/pg_dumpall |