Discussion:
Windows: where to put pgpass.conf for user "system"
Andreas
2011-09-21 22:47:25 UTC
Permalink
Hi,
I need to let a process running under user "system" call psql to store
some event data into a database.

The process calls a cmd-batchfile with parameters that constructs an
insert-query and fires it off with psql.
So far that works just for real user accounts but not for system.

Where should I put pgpass.conf for user "system"?
AFAIK it hasn't got an %appdata% directory and the one for all users
didn't work.
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Alexander Rüegg
2011-09-22 08:37:43 UTC
Permalink
Where should I put pgpass.conf for user "system"?
AFAIK it hasn't got an %appdata% directory and the one for all users
didn't work.
Maybe you can set the environment variable PGPASSWORD temporarily when
executing the script?

Best
Alex
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...