Thread: pg_dumpall
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 -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dumpall-tp4270567p4270567.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
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.
hi thanks for that i tried it but still same error: C:\Program Files\PostgreSQL\9.0\bin>pg_dump --username=postgre --password=1234 Test > aaron.db Password: pg_dump: [archiver (db)] connection to database "Test" failed: FATAL: password authentication failed for user "postgre" Once i press enter it asks for the password again which i enter as the password above but get the same error message. -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dumpall-tp4270567p4271374.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
i cannot remember entering a username.. when installed just entered a password. I have tried also using the name of my pc but still that didnt work. -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dumpall-tp4270567p4271485.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
How do know my connection to the database is working as the first bit of the error message says: Password: pg_dump: [archiver (db)] connection to database "Test" failed: FATAL: password authentication failed for user "enabs" -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dumpall-tp4270567p4271492.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
On Mar 30, 2011, at 5:34 AM, aaronenabs wrote: > hi thanks for that i tried it but still same error: > > C:\Program Files\PostgreSQL\9.0\bin>pg_dump --username=postgre > --password=1234 Test > aaron.db > Password: > pg_dump: [archiver (db)] connection to database "Test" failed: FATAL: > password > authentication failed for user "postgre" > > Once i press enter it asks for the password again which i enter as the > password above but get the same error message. The root username should be "postgres". Are you able to connect using psql or PgAdmin? Brent D.
I have just uninstalled postgresql version 9 and would install version 7 to carry out my research. I have not used or installed psql or pgadmin on my machine, as i was advised my project just required a database and nothing much. What am trying to do is by using pg_dumpall i could display or dump dead rows or all rows into a file and locate dead rows from that. Cheers -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dumpall-tp4270567p4271694.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.