Re: pg_restore - authentication failed?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore - authentication failed?
Date: 2005-09-08 14:40:19
Message-ID: 43204D53.6040904@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2005-09-08 14:43:28 Re: Postgresql Hosting
Previous Message Bricklen Anderson 2005-09-08 14:38:12 8.1beta timezone question