Grokbase › Groups › PostgreSQL › pgsql-novice › March 2011
FAQ
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.

Search Discussions

  • Brent Dombrowski at Mar 30, 2011 at 4:20 am ⇧

    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.
  • Aaronenabs at Mar 30, 2011 at 12:34 pm ⇧
    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.
  • Aaronenabs at Mar 30, 2011 at 1:39 pm ⇧
    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.
  • Aaronenabs at Mar 30, 2011 at 1:41 pm ⇧
    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.
  • Brent Dombrowski at Mar 30, 2011 at 2:57 pm ⇧

    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.
  • Aaronenabs at Mar 30, 2011 at 3:24 pm ⇧
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMar 30, '11 at 1:22a
activeMar 30, '11 at 3:24p
posts7
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Aaronenabs: 5 posts Brent Dombrowski: 2 posts

Content

People

Support

Translate

site design / logo © 2023 Grokbase