Bug#618675: postgresql: Please include systemd service file

2011-10-08 Thread Martin Pitt
Hello Michael,

Martin Pitt [2011-03-27 17:22 +0200]:
 Reassigning to postgresql-common, as the script looks like being
 inteded to be version independent (just like the current init.d
 script).
 
  Also, it starts quite a bit faster due to not having to run a shell
  script and a perl script (pg_ctlcluster).
 
 This does need to use pg_ctlcluster, I'm afraid. With the proposed
 service file you'd break the postgresql-common structure completely,
 i. e. it disregards multiple clusters, cluster owners, data
 dir/start.conf and other configuration, and also circumvent the sanity
 checks.

Any update on this? If not, I'll just close the bug.

Thanks, and enjoy the weekend!

Martin
-- 
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com)  | Debian Developer  (www.debian.org)


signature.asc
Description: Digital signature


Bug#618675: postgresql: Please include systemd service file

2011-10-08 Thread Michael Stapelberg
Hi,

Excerpts from Martin Pitt's message of 2011-10-08 10:55:24 +0100:
 Any update on this? If not, I'll just close the bug.
Well, my postgresql.service works for me, but clearly there is more work to do
to have a generally working one. I don’t really have time to spend on this,
though, so feel free to close the bug.

Best regards,
Michael



--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



Bug#618675: postgresql: Please include systemd service file

2011-03-27 Thread Martin Pitt
reassign 618675 postgresql-common 114
tag 618675 moreinfo
tag 618675 -patch
thanks

Hello Michael,

Michael Stapelberg [2011-03-17 15:09 +0100]:
 Package: postgresql

Reassigning to postgresql-common, as the script looks like being
inteded to be version independent (just like the current init.d
script).

 Also, it starts quite a bit faster due to not having to run a shell
 script and a perl script (pg_ctlcluster).

This does need to use pg_ctlcluster, I'm afraid. With the proposed
service file you'd break the postgresql-common structure completely,
i. e. it disregards multiple clusters, cluster owners, data
dir/start.conf and other configuration, and also circumvent the sanity
checks.

Thanks,

Martin

-- 
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com)  | Debian Developer  (www.debian.org)


signature.asc
Description: Digital signature


Bug#618675: postgresql: Please include systemd service file

2011-03-17 Thread Michael Stapelberg
Package: postgresql
Version: 9.0.3-1
Severity: wishlist
Tags: patch


Hi,

I wrote a systemd service file for postgresql (accomplishes the same task as an
init script). Using the native service file instead of systemd’s init script
compatiblity layer allows you to disable the service at boot time and allow
manual starting, for example. Also, it starts quite a bit faster due to not
having to run a shell script and a perl script (pg_ctlcluster).

So, please integrate the attached two files (and contact upstream about also
including it):
 • postgresql@.service should be placed at
   /lib/systemd/system/postgresql@.service. It allows you to run multiple
   versions of the postgresql server, set it up like this:
   ln -sf /lib/systemd/system/postgresql@.service \
 /etc/systemd/system/postgresql.target.wants/postgresql@9.0.service
 • /etc/tmpfiles.d/postgresql.conf is responsible for creating
   /var/run/postgresql

Thanks!
Best regards,
Michael

BTW: General usage hints for testing this:
# systemctl daemon-reload
# systemctl status postgresql@9.0.service
# systemctl start postgresql@9.0.service

See also http://wiki.debian.org/systemd


postgresql@.service
Description: Binary data


postgresql.conf
Description: Binary data