On 06/28/2011 05:34 AM, Lodron, Gerald wrote:
> I have the problem that when i run my batch i always have to let the user type in the password, thats nasty... I also tried PGPASSWORD but it does not work, it always prints that it is the wrong password...
I'm not sure if setting PGPASSWORD in a Windows batch file is going to
work correctly...have you tried creating a .pgpass file instead?
Another option to consider is swapping out the default pg_hba.conf file
with one that trusts local users fully. You could put that in place,
signal the server to reload its configuration, execute your setup
script, then put back a properly secured file and reload again. There
will be a brief window where any local user could gain access to the
database server as a superuser that way. But if you were that worried
about locking down security, you probably wouldn't be deploying an
auto-installer on Windows in the first place.
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
In response to
pgsql-general by date
|Next:||From: Rob Sargent||Date: 2011-06-28 23:17:26|
|Subject: Re: Windows x64 : How do I get OSSP-UUID.sql contrib for
|Previous:||From: John R Pierce||Date: 2011-06-28 23:07:32|
|Subject: Re: DROP TABLE Appears to Fail|