I have a batch file that runs the "pg_dump" command for several databases that I have in a server. In order to make this process work in an unattended manner, I set the database passwords in the "pgpass.conf" file but such a file gets empty after a few days. I work in a Windows Server 2008 environment and the path for the passwords file is "c:\users\servername\appdata\roaming\postgresql". I got such a path with the echo %appdata" command from the command prompt. I have been trying to get an idea of why this is happenning but I do not have a clue until now. I will very much appreciate any comment.
Respectfully,
Jorge Maldonado