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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Maximilian Tyrtania | 2011-03-30 05:46:08 | Re: updating records in table A from selected records in table B |
Previous Message | aaronenabs | 2011-03-30 01:22:47 | pg_dumpall |