On Thu, May 23, 2013 at 2:15 PM, David Burton <burton...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
