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

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема No password supplied error when running a batch script as a programmed task
Дата
Msg-id CAAY=A7-O5KXsLFGjdqpHkCZoNfL6Z-G-6yR1vhcu4okctMbdmw@mail.gmail.com
обсуждение исходный текст
Ответы Re: No password supplied error when running a batch script as a programmed task
Список 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


В списке pgsql-novice по дате отправления: