From: | jackrg <jack(at)groundbreakingsoftware(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Sudenly unable to backup from database |
Date: | 2014-06-03 18:31:10 |
Message-ID: | 1401820270127-5805903.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Using pgAdmin 1.14.1, earlier this morning I did a backup of a single table
from my database in plain format, which completed successfully. I now try to
repeat that operation and it fails. Here are the messages from the attempt:
/Applications/pgAdmin3.app/Contents/SharedSupport/pg_dump --host
ec2-54-197-246-17.compute-1.amazonaws.com --port 5562 --username
"u6u1m6ai8tdviu" --no-password --format tar --section data --no-privileges
--verbose --file "/Users/jackrg/Documents/heroku-partial-for-just-logs.dump"
--table "public.logs" "d4n5qjtiqnucn2"
pg_dump: [archiver (db)] connection to database "d4n5qjtiqnucn2" failed:
FATAL: password authentication failed for user "u6u1m6ai8tdviu"
FATAL: no pg_hba.conf entry for host "72.219.168.82", user
"u6u1m6ai8tdviu", database "d4n5qjtiqnucn2", SSL off
Process returned exit code 1.
The problem is (apparently) the "--no-password" command-line switch. Why is
that switch there (the database is password-protected and the password is on
file, since I can connect to the database). FWIW, this Postgres database is
hosted on Heroku.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Sudenly-unable-to-backup-from-database-tp5805903.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Ross | 2014-06-05 13:31:43 | New Release needed |
Previous Message | Matt Magoffin | 2014-06-02 19:06:50 | Copy/paste results in garbage if clipboard contains rich text on OS X |