On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen <[email protected]> wrote: > On Mon, Oct 18, 2010 at 3:07 AM, Dave Page <[email protected]> wrote: >> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen <[email protected]> >> 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?
No, you have to enable it. On redhat based distros, you'd do something like "chkconfig <servicename> on". On Debian based distros, I believe you use the update-rc.d command. -- 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
