Skip site navigation (1) Skip section navigation (2)

Re: pgpass.cong file becomes empty

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: pgpass.cong file becomes empty
Date: 2011-07-12 15:14:37
Message-ID: c1f5021e867b03cc8b3f35d84fbbda3f@biglumber.com (view raw or flat)
Thread:
Lists: 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(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-----



In response to

pgsql-novice by date

Next:From: LALIT KUMARDate: 2011-07-13 06:15:20
Subject: Compare rows
Previous:From: Pushpendra Singh ThakurDate: 2011-07-12 14:31:36
Subject: Re: Creating DB programmatically?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group