[Pkg-postgresql-public] pgpool packaging

Martin Pitt martin@piware.de
Sun, 18 Jul 2004 23:28:01 +0200

Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Peter!

On 2004-07-18 23:04 +0200, Peter Eisentraut wrote:
> 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.=20

I see no problem with that.

> Absent better ideas, I will use port 5433 by default, so the user has=20
> to reroute his applications explicitly, or do the switch with=20
> PostgreSQL manually if he wants truly transparent access.

Hmm, it seems that it would make more sense to let pgpool run at the
usual postgresql port (since it is the expected standard).  An idea
would be to parse the "usual" port from postgresql.conf, use it for
pgpool and restart the postmaster with no TCP port, but only with the
local Unix port. If pgpool does not support that, you could start
postmaster with '-p' on a free port and only listen on on

> 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,=20
> unless you propose to play various games with group permissions.

If /var/run/postgresql access is the only reason why pgpool shall ran
as postgres, I would vote against it and instead let it run as
pgpool:postgresql. This directory already has group 'postgresql', thus
we just need to enable group writeability in PostgreSQL. What do you

> Additionally, the postgresql package should behave reasonably if the=20
> directory /var/run/postgresql is already there when it is installed=20
> (because pgpool might have been installed first) and should not remove=20
> it if there are still files in there.

This is already the case.

Have a nice day and happy packaging!


Martin Pitt                 Debian GNU/Linux Developer
martin@piware.de                      mpitt@debian.org
http://www.piware.de             http://www.debian.org

Content-Type: application/pgp-signature
Content-Disposition: inline

Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Weitere Infos: siehe http://www.gnupg.org