[Pkg-postgresql-public] systemd support

Daniel Kahn Gillmor dkg at fifthhorseman.net
Tue Mar 4 21:12:10 UTC 2014


On 03/04/2014 06:49 PM, Stephen Frost wrote:
> * Christoph Berg (myon at debian.org) wrote:
>> I've written systemd unit files for managing PostgreSQL clusters. 
> 
> Neat stuff!

seconded!

>> To work, you also need the pg_ctlcluster version from HEAD.
>> pg_ctlcluster now invokes postgres directly so it runs in foreground
>> instead of daemonizing with pg_ctl - this seems more like the systemd
>> way to do it.
> 
> This is going to have to be optional, isn't it?  I know that I'm
> frequently running pg_ctlcluster myself, and aren't we going to need to
> support kfreebsd with the traditional init system?

can't we let the sysvinit initscript (or the moral equivalent for other
non-supervising init systems) use start-stop-daemon --background instead
of trucking that code around in pg_ctlcluster?  kFreeBSD'ers aren't
necessarily going to use sysvinit anyway (e.g. i've run kFreeBSD with
runit as pid 1, whose scripts would definitely prefer Christoph's
proposed non-daemonizing pg_cltcluster semantics).

if you're running it by hand yourself and you really don't want it to
stay foregrounded, you have a whole slew of other options.  (though i
like keeping my personal daemons foregrounded, personally)

have you looked at all into the idea of a socket-activated postgresql
for those initsystems that can handle socket activation?

	--dkg

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 1010 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20140304/9e8fbe66/attachment.sig>


More information about the Pkg-postgresql-public mailing list