Win32 pg_autovacuum service

Started by Dave Pageover 22 years ago3 messagespatches
Jump to latest
#1Dave Page
dpage@vale-housing.co.uk

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
#2Andrew Dunstan
andrew@dunslane.net
In reply to: Dave Page (#1)
Re: Win32 pg_autovacuum service

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

#3Dave Page
dpage@vale-housing.co.uk
In reply to: Andrew Dunstan (#2)
Re: Win32 pg_autovacuum service

-----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 service

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?

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.