Re: pgpass.cong file becomes empty

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> 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.

If you mean why it is emptying out, it is certainly not being done by Postgres
or the pg_dump program. As the name of the path has "roaming" in it, perhaps
Windows is copying over the blank file from somewhere else, perhaps when the
user logs in / log out?

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201107121110
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk4cZMkACgkQvJuQZxSWSsgH3QCg0iPlAw/EPmxYmsKzQz7UJ0Sj
M6kAoMEN3Re/cDtcz1isGBXG38k/xa3Y
=jHrp
-----END PGP SIGNATURE-----