Re: No password supplied error when using pg_dump

From: Stephen Cook <sclists(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: No password supplied error when using pg_dump
Date: 2016-11-17 02:45:42
Message-ID: 0840797e-b416-e94d-f5a1-d15a18d2c422@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2016-11-16 20:39, JORGE MALDONADO wrote:
> 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

That "-w" makes pg_dump not ask for a password, so you will get an error
if the user requires password authentication.

-- Stephen

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2016-11-17 02:51:27 Re: No password supplied error when using pg_dump
Previous Message JORGE MALDONADO 2016-11-17 01:39:46 No password supplied error when using pg_dump