Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

pg_autovacuum Win32 service patch #2


  • From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
  • To: <pgsql-hackers-win32(at)postgresql(dot)org>
  • Cc: <pgsql-hackers(at)postgresql(dot)org>
  • Subject: pg_autovacuum Win32 service patch #2
  • Date: Sun, 9 May 2004 09:48:55 +0100
  • Message-id: <03AF4E498C591348A42FC93DEA9661B889FCC8(at)mail(dot)vale-housing(dot)co(dot)uk>

[Third attempt to send this - dunno where they're all going!]

I forgot to CC the start of this to -hackers last time - please see
http://archives.postgresql.org/pgsql-hackers-win32/2004-05/msg00034.php
for background.

Following Magnus' suggestions yesterday I made the following changes:

- The event source is now "PostgreSQL Auto Vacuum"
- Error levels have been added to the error handler to standardise log
entry format and allow use of Win32 event types.
- When installing as a windows service the following options can be used
to specify the uid/pwd to run the service as:

  -N <username>
  -W <password>

- Other options specified when installing as a service are stored in the
registry for use each startup, INCLUDING DATABASE PASSWORD.

In addition, I've also cleaned up the service startup code so that it
terminates properly if there is an error at startup, and modified
InstallService and RemoveService to register/deregister the service as
an event source.

Any comments/criticisms/gasps of horror at all the win32 code? :-)

Regards, Dave

Attachment: pg_autovacuum2.diff.gz
Description: pg_autovacuum2.diff.gz



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group