Re: [gentoo-dev] systemd + postgresql is non-obvious to me

[Aaron W. Swenson]

On 2014-09-01 11:09, Canek Peláez Valdés wrote:
> On Mon, Sep 1, 2014 at 10:46 AM, Aaron W. Swenson <titanofold@g.o> wrote:
> > On 2014-08-22 14:07, Rich Freeman wrote:
> >> On Fri, Aug 22, 2014 at 1:23 PM, Aaron W. Swenson <titanofold@g.o> 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.
> >
> > Delayed response, I've been looking into this as I've been working on
> > unifying the ebuilds, but I can't find where upstream is providing the
> > systemd unit. The only one I have is the one we've made.
>
> It is included in:
>
> http://dev.gentoo.org/~titanofold/postgresql-initscript-2.6.tbz2
>
> It doesn't says who the author is; but he or she was the one deciding
> to wait five minutes (TimeoutSec=300) for the server to stop (and also
> to disable the OOM killer: OOMScoreAdjust=-1000).

Well, I'm the one who committed it to the pgsql-patches repo and
Patrick committed it to gentoo-x86, but neither of us wrote it. There was
some collaboration on the bug [1].

You can also read through the comments to see my other complaints. I
don't know if they're addressed or not.

[1] https://bugs.gentoo.org/show_bug.cgi?id=468868

-- 
Mr. Aaron W. Swenson
Gentoo Linux Developer
PostgreSQL Herd Bull
Email : titanofold@g.o
GnuPG FP : 2C00 7719 4F85 FB07 A49C 0E31 5713 AA03 D1BB FDA0
GnuPG ID : D1BBFDA0