Re: pgpass.cong file becomes empty - Mailing list pgsql-novice

From Greg Sabino Mullane
Subject Re: pgpass.cong file becomes empty
Date
Msg-id c1f5021e867b03cc8b3f35d84fbbda3f@biglumber.com
Whole thread Raw
In response to pgpass.cong file becomes empty  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
-----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-----



pgsql-novice by date:

Previous
From: Pushpendra Singh Thakur
Date:
Subject: Re: Creating DB programmatically?
Next
From: LALIT KUMAR
Date:
Subject: Compare rows