Search Postgresql Archives

Re: pg_restore - authentication failed?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Zlatko Matić wrote:
If I use PgAdmin it works, but if I copy the command to .bat file authentication fails although I enter correct password.
The .bat script is the following:

and the error is:
pg_restore: [archiver (db)] connection to database "MYDATABASE" failed: FATAL: password authentication failed for user "postgres"

I also tried to pass password by pgpass.conf file, but without result. If I use PgAdmin, it works....

What could be the reason ? Is this a bug ?

Unlikely. Is pgadmin connecting to localhost on port 5432? I'm thinking there might be something in your pg_hba.conf

--
  Richard Huxton
  Archonet Ltd


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux