Ok I have attached a modified init script, which now uses the postgres
database. The logging is also redirected to pgagent.log in the pgsql home
directory. Could this please be added to the source tree?
Note: because pgagent does not flush the buffer for every log message, the
log file does not see anything until the buffer is written. Maybe pgagent
could be changed to log to a file which is flushed periodically, instead of
stdout?
Cheers Jeremy
> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: Friday, 2 June 2006 2:24 a.m.
> To: Jeremy Palmer; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] init script for redhat
>
>
>
> > -----Original Message-----
> > From: pgadmin-support-owner@postgresql.org
> > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> > Jeremy Palmer
> > Sent: 01 June 2006 11:39
> > To: pgadmin-support@postgresql.org
> > Subject: [pgadmin-support] init script for redhat
> >
> > Hi,
> >
> > I've hacked together a quick init script for pgagent. It
> > might be useful for
> > others use.
> >
> > It is hard coded to connect to the "pgadmin" database as the
> > "postgres"
>
> That should probably be the postgres database as well.
>
> > user. If others find this useful and have any suggested
> > improvements, then
> > maybe we should fix it up and make it part of the Redhat/Fedora dist?
>
> Don't see why not. When you're happy with it, please forward it to the
> list for addition to the source tree.
>
> Regards, Dave