Thread: pgAdmin3 restore getting password authentication failed for user "postgres"
I'm using pgAdmin3 1.16.1 on an iMac. I'm connecting to postgresql on Ubuntu.
The username is postgres and I've supplied the password during the connect.
But, when I try to restore, I get the following error.
LOG:
/Applications/pgAdmin3.app/Contents/SharedSupport/pg_restore --host 208.88.8.197 --port 5432 --username "postgres" --dbname "ndeavor_production" --role "ndeavor" --no-password --format directory --data-only --verbose "/Users/burtondav/Desktop/nDeavor Backup Folders/Staging May 22 7am"
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "ndeavor_production" failed: FATAL: password authentication failed for user "postgres"
Process returned exit code 1.
Thanks for your help!
David Burton
Re: pgAdmin3 restore getting password authentication failed for user "postgres"
From
Dave Page
Date:
On Thu, May 23, 2013 at 2:15 PM, David Burton <burtondav@gmail.com> wrote: > I'm using pgAdmin3 1.16.1 on an iMac. I'm connecting to postgresql on > Ubuntu. > > The username is postgres and I've supplied the password during the connect. > > But, when I try to restore, I get the following error. > > LOG: > /Applications/pgAdmin3.app/Contents/SharedSupport/pg_restore --host > 208.88.8.197 --port 5432 --username "postgres" --dbname "ndeavor_production" > --role "ndeavor" --no-password --format directory --data-only --verbose > "/Users/burtondav/Desktop/nDeavor Backup Folders/Staging May 22 7am" > pg_restore: connecting to database for restore > pg_restore: [archiver (db)] connection to database "ndeavor_production" > failed: FATAL: password authentication failed for user "postgres" > > Process returned exit code 1. Hi Is the password saved in the ~/.pgpass file? That will happen if you check the "Save Password" option when connecting. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company