Обсуждение: pgpass.cong file becomes empty
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
-----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@turnstep.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-----