Win32 pg_autovacuum service
The attached patch allows pg_autovacuum to run as an application or a
service on Win32. There are minor changes that also affect *nix -
mainly:
- The error logging function now takes an error level as an argument for
more consistent formatting and use in the windows event log.
- The default debug level is now 0 as 1 was creating a huge amount of
log output even on a small database.
- The main program loop has been moved into a separate function so it
can be called by the windows Service Control Manager.
Regards, Dave.
Attachments:
pg_autovacuum3.diffapplication/octet-stream; name=pg_autovacuum3.diffDownload+796-784
Dave Page said:
The attached patch allows pg_autovacuum to run as an application or a
service on Win32. There are minor changes that also affect *nix -
mainly:- The error logging function now takes an error level as an argument
for more consistent formatting and use in the windows event log.
- The default debug level is now 0 as 1 was creating a huge amount of
log output even on a small database.
- The main program loop has been moved into a separate function so it
can be called by the windows Service Control Manager.
I thought pg_autovacuum was moving to be integrated with and controlled by
the backend, in which case this seems redundant, or have I become confused
again?
cheers
andrew
-----Original Message-----
From: Andrew Dunstan [mailto:andrew@dunslane.net]
Sent: 11 May 2004 12:13
To: pgsql-patches@postgresql.org
Subject: Re: [PATCHES] Win32 pg_autovacuum serviceI thought pg_autovacuum was moving to be integrated with and
controlled by the backend, in which case this seems
redundant, or have I become confused again?
No, you haven't, but the last I remember was that it was no definite
thing for 7.5, hence a win32 service might be useful for at least one
release.
Besides, I mainly did it as a learning exercise as I have to write a
service at work - if it ends up in the bin I won't get upset :-)
Regards, Dave.
Import Notes
Resolved by subject fallback