No password supplied error when using pg_dump

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: No password supplied error when using pg_dump
Date: 2016-11-17 01:39:46
Message-ID: CAAY=A79RsmYZga+QVmOJ9WxhmysuDgkY+Hs0SkwjSUF2nbC3gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am trying to run pg_dump to backup my PostgreSQL DB and I am getting a
"fe_sendauth: no pssword supplied" error message. This is a Windows Server
2012 environment and I am issuing pg_dump from a command prompt.

The command is as follows:
pg_dump -E win1252 -f d:/respaldos/chartsclub/basedatos/CC.backup -F p -n
chartsclub -h localhost -U postgres -w chartsclub

The content of pgpass.conf is:
localhost:5433:chartsclub:postgres:mypassword
Where "mypassword" is the actual valid password which I have successfully
tested in pgAdmin3.
After adding this line to pgpass.conf file I restarted PostgreSQL service.

Variable %APPDATA% is:
c:\Users\Administrator\AppData\Roaming

Is there anything else I should take into account?
I will very much appreciate your feedback.

Respectfully,
Jorge Maldonado

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Cook 2016-11-17 02:45:42 Re: No password supplied error when using pg_dump
Previous Message Marc Richter 2016-10-26 08:22:25 Re: