On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen <m...@kitchenpc.com> wrote: > Okay I found one that I can use.. > > One question.. Should the connection string in the script have the > password for "root" hard coded in it? Or will it use a password from > ~/.pgpass automatically? If so, what user account will it find the > .pgpass file under? Thanks!
Have the script start pgagent under the postgres account eg; su - postgres -c 'p/path/to/pgadmin....' Then it should be able to use postgres' pgpass file. Don't put the password in the connection string! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
