Re: pgAdmin3 restore getting password authentication failed for user "postgres"

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