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

Re: pg_dumpall

From: Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: aaronenabs <aaronenabs(at)btconnect(dot)com>
Subject: Re: pg_dumpall
Date: 2011-03-30 04:18:19
Message-ID: 9EFE0DBF-38AD-4B0F-B8BD-8CA40621D56D@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mar 29, 2011, at 6:22 PM, aaronenabs wrote:

> Hi there,
> 
> I have been having problems using the pg_dumpall function. I am trying to
> dump all the information on my database onto a file or view it. Actually
> what am trying to achieve is by using the pg_dumpall i can view dead rows
> once the db has been dumped into a file. I had a look online and tried to
> run the pg_dumpall command from dos using this code:
> 
> pg_dump Test > aaron.db
> 
> but came up with this error:
> 
> C:\Program Files\PostgreSQL\9.0\bin>pg_dump Test > aaron.db
> Password:
> pg_dump: [archiver (db)] connection to database "Test" failed: FATAL: 
> password
> authentication failed for user "Enabs"
> 
> test being the name of the database and aaron.db being the output file
> wanted it to view
> again am sure you might think the password authentication failed due to
> password, but changed the password, tried again and still no success..
> 
> If anyone can link me to a video or example on how the pgdump works or how
> to use it, i would be very grateful. Thanks 

Try specifying the username and password with the command. I think it might not like the user name, it is case sensitive.

pg_dump --username=USER --password=PASS Test > aaron.db

Brent D.


In response to

  • pg_dumpall at 2011-03-30 01:22:47 from aaronenabs

Responses

pgsql-novice by date

Next:From: Maximilian TyrtaniaDate: 2011-03-30 05:46:08
Subject: Re: updating records in table A from selected records in table B
Previous:From: aaronenabsDate: 2011-03-30 01:22:47
Subject: pg_dumpall

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