pg_dump backup problems with password authentication
Ricardo Dias Marques <ricmarques@spamcop.net>
From: Ricardo Dias Marques <ricmarques@spamcop.net>
To: pgsql-admin@postgresql.org
Date: 2000-12-07T13:07:17Z
Lists: pgsql-bugs
Hi all, I am using PostgreSQL 7.0.2 in RedHat Linux 6.2 I have changed the default authentication, in the pg_hba.conf file, from trust to password. Unfortunately, this is giving me problems with pg_dump I am trying to do a copy of just one database (with all its tables, primary and foreign keys, check clauses, triggers, etc). So, I followed the instructions at: http://postgresql.rmplc.co.uk/users-lounge/docs/7.0/admin/manage-ag1655.htm and did a pg_dump dbname > dbname.pgdump (I replaced dbname by my database name, obviously) Because I have password authentication set, I get an error message: Connection to database 'dbname' failed. fe_sendauth: no password supplied So, I did a man pg_dump and found out that -u would prompt for username and password, and -v would give a verbose output. And so I did: pg_dump -u -v dbname > dbname.pgdump The problem is when I press the ENTER key on that command: it just sits there! Eventually, I have to hit CTRL+C to get out. Can any kind soul explain me what I am doing wrong? :( Thanks in advance, Ricardo Dias Marques ricmarques@spamcop.net