On Mon, Oct 18, 2010 at 3:07 AM, Dave Page <dpage@xxxxxxxxxxx> wrote: > On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen <mike@xxxxxxxxxxxxx> 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! Ok, that worked.. I can at least start and stop it now, and it remains running when I'm logged off.. So does anything in /etc/init.d get automatically run when the server boots? Mike -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
