Skip site navigation (1) Skip section navigation (2)

Re: pg_dump/pg_dumpall

From: "Andrew C(dot) Uselton" <acuselton(at)lbl(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dump/pg_dumpall
Date: 2007-08-10 20:21:09
Message-ID: 46BCC8B5.9080101@lbl.gov (view raw or flat)
Thread:
Lists: pgsql-novice
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.
Cheers,
Andrew
 

Alan Hodgson wrote:
> On Friday 10 August 2007 11:49, "Andrew C. Uselton" <acuselton(at)lbl(dot)gov> 
> wrote:
>   
>> 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,
>>     
>
> 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 HurtDate: 2007-08-10 20:23:13
Subject: could not serialize access due to concurrent update
Previous:From: Marcin PorwitDate: 2007-08-10 19:58:16
Subject: Configuring Postgresql to use PAM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group