I haven't used PostgreSQL in Windows but I know in Unix based systems the pgpass file is located in your home folder. Where is it on Windows? If its in your user account's folder then try checking to see what user the Task Scheduler's tasks run as, it could be looking for a global pgpass file that doesn't exist.
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%)