[Pkg-postgresql-public] pgpool packaging
Sun, 18 Jul 2004 23:04:20 +0200
I'm packaging pgpool, a connection pool proxy for PostgreSQL. It's a
little server that takes client connections and passes them on to the
real PostgreSQL server, while doing the connection caching thing. I
would like to tell you about a few packaging issues that might interact
with the postgresql package.
To the client, the proxy should appear as transparent as possible. That
implies that the socket file has to be placed in /var/run/postgresql.
Absent better ideas, I will use port 5433 by default, so the user has
to reroute his applications explicitly, or do the switch with
PostgreSQL manually if he wants truly transparent access.
I would like to have the server running as a nonprivileged user. To get
write access to /var/run/postgresql, that user has to be postgres,
unless you propose to play various games with group permissions.
Additionally, the postgresql package should behave reasonably if the
directory /var/run/postgresql is already there when it is installed
(because pgpool might have been installed first) and should not remove
it if there are still files in there.
Does that sound reasonable?