Re: pg_restore - authentication failed? - Mailing list pgsql-general

From Richard Huxton
Subject Re: pg_restore - authentication failed?
Date
Msg-id 43204D53.6040904@archonet.com
Whole thread Raw
In response to pg_restore - authentication failed?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Postgresql Hosting
Next
From: "Joshua D. Drake"
Date:
Subject: Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect