No password supplied error when running a batch script as a programmed task

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: No password supplied error when running a batch script as a programmed task
Date: 2016-02-29 18:45:38
Message-ID: CAAY=A7-O5KXsLFGjdqpHkCZoNfL6Z-G-6yR1vhcu4okctMbdmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I wonder if this question belongs here. Please let me know in order to look
for another place to ask.

I have PostgreSQL installed on Windows Server 2008 R2 and wrote a batch
script to get a backup of a database. Such a script must run automatically
so I created a task in the Task Scheduler which runs under the
Administrator account. This task fails running the batch script and
provides the following message:

fe_sendauth: no password supplied

However, if I run the script directly double clicking of it, the batch
executes successfully. The pgpass.conf file is also correct, otherwise, the
batch script would not run manually.

I will very much appreciate your feedback.

The batch has the following instructions:

echo off
d:
cd "D:\Program Files (x86)\PostgreSQL\9.3\bin"

SET mes=%date:~3,2%
SET dia=%date:~0,2%
SET anio=%date:~6,4%

IF %TIME:~0,2% LSS 10 (SET hra=0%TIME:~1,1%) ELSE (SET hra=%TIME:~0,2%)
IF %TIME:~3,2% LSS 10 (SET min=0%TIME:~4,1%) ELSE (SET min=%TIME:~3,2%)

echo on
time /t
rem echo off
pg_dump -E win1252 -f
d:/respaldos/edocuments/edoc_%anio%%mes%%dia%_%hra%%min%.backup -F p -n
edocuments -h localhost -U postgres -w edocuments
pg_dump -E win1252 -f
z:/respaldos/edocumentsdb/edoc_%anio%%mes%%dia%_%hra%%min%.backup -F p -n
edocuments -h localhost -U postgres -w edocuments
echo on
time /t
rem echo off
pause

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Pinto 2016-02-29 19:52:14 Re: No password supplied error when running a batch script as a programmed task
Previous Message Shmagi Kavtaradze 2016-02-28 11:39:08 Divide table raw into chunks