Useful info. I'll dig around and see how we set up the db superuser.
Certainly I've been trying "-U postgres" right along, but I may be
mistaken about what it thinks the password is.
Alan Hodgson wrote:
> On Friday 10 August 2007 11:49, "Andrew C. Uselton" <acuselton(at)lbl(dot)gov>
>> 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. Cheers,
> It is trying to connect as root, because you're logged in to your OS as
> root, but there probably isn't a root user in the database.
> You need to connect as a database superuser to do a backup. The normal
> default superuser is "postgres". Where it gets its password from or
> even if it requires one depends on your configuration.
In response to
pgsql-novice by date
|Next:||From: Brian Hurt||Date: 2007-08-10 20:23:13|
|Subject: could not serialize access due to concurrent update|
|Previous:||From: Marcin Porwit||Date: 2007-08-10 19:58:16|
|Subject: Configuring Postgresql to use PAM|