On Fri, Aug 22, 2014 at 2:07 PM, Rich Freeman <ri...@gentoo.org> wrote: > On Fri, Aug 22, 2014 at 1:23 PM, Aaron W. Swenson <titanof...@gentoo.org> > wrote: >> On the whole, I'm displeased with the systemd alternative for >> controlling PostgreSQL. It's significantly hampered and doesn't allow >> as much flexibility as the initscript. The major issue being trying to >> nicely shut down the server instead of jumping straight to murder. >> > > It looks like the package installs a service file provided by > upstream, so you might want to direct your complaint there unless it > really is a systemd limitation. > > Checking the latest version in portage it calls: > ExecStop=/usr/@LIBDIR@/postgresql-@SLOT@/bin/pg_ctl stop -D > ${DATA_DIR} -s -m fast > > I'm no postresql expert, but according to the manpage that should > bring the server to a screeching, but still controlled, halt. Perhaps > you would prefer setting it to -m smart instead of -m fast. >
Personally, I prefer the thing to stop within a reasonable time period when I tell it to stop. Waiting around for the remaining connections to magically die (smart mode) is just tedious.