Thread: Sudenly unable to backup from database

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.

On Tue, 2014-06-03 at 11:31 -0700, jackrg wrote:
> 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.
> 

It's here because noone will be able to type the password. If the
connection needs a password, you need a .pgpass file.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On Wed, 2014-06-18 at 09:45 -0700, jackrg wrote:
> I understand what the —no-password switch does from a technical point of view, but I was not manipulating that file.
Earlierin the day the same sequence in pgAdmin successfully backed up the database. Between those two invocations, I
didnothing that should have affected the existence of a pgpass file. I did not create one when it worked; nor did I
deleteit before the invocation that did not work. My inference is that perhaps pgAdmin created it the first time but
notthe second time. If that is true, then my question would by why did it not create the file the second time.
 
> 

pgAdmin creates the file when it's been told to record the password. If
you change the password, pgAdmin won't know and won't be able to update
it in the file till the next (failing) connection. So either someone
changed the password, or the pgpass got corrupted some way. But I can't
reproduce this.

> On Jun 18, 2014, at 7:36 AM, Guillaume Lelarge-3 [via PostgreSQL] <ml-node+s1045698n5807762h57@n5.nabble.com> wrote:
> 
> > On Tue, 2014-06-03 at 11:31 -0700, jackrg wrote:
> > 
> > > 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. 
> > >
> > 
> > It's here because noone will be able to type the password. If the 
> > connection needs a password, you need a .pgpass file. 
> > 
> > 
> > -- 
> > Guillaume 
> > http://blog.guillaume.lelarge.info
> > http://www.dalibo.com
> > 
> > 
> > 
> > -- 
> > Sent via pgadmin-support mailing list ([hidden email]) 
> > To make changes to your subscription: 
> > http://www.postgresql.org/mailpref/pgadmin-support
> > 
> > 
> > If you reply to this email, your message will be added to the discussion below:
> > http://postgresql.1045698.n5.nabble.com/Sudenly-unable-to-backup-from-database-tp5805903p5807762.html
> > To unsubscribe from Sudenly unable to backup from database, click here.
> > NAML
> 
> 
> 
> 
> 
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Sudenly-unable-to-backup-from-database-tp5805903p5807777.html
> Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com