Thread: BUG #16708: Please add some more restrictions to the default systemd unit files

The following bug has been logged on the website:

Bug reference:      16708
Logged by:          Pat Riehecky
Email address:      jcpunk@gmail.com
PostgreSQL version: 13.0
Operating system:   Linux/systemd
Description:

Can the following be added to the systemd units:

```
[Unit]
After=local-fs.target nss-user-lookup.target
```

This cleans up some of my issues starting the service after a boot where my
data is on a slow to mount filesystem.

On Tue, Nov 10, 2020 at 06:47:49PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      16708
> Logged by:          Pat Riehecky
> Email address:      jcpunk@gmail.com
> PostgreSQL version: 13.0
> Operating system:   Linux/systemd
> Description:        
> 
> Can the following be added to the systemd units:
> 
> ```
> [Unit]
> After=local-fs.target nss-user-lookup.target
> ```
> 
> This cleans up some of my issues starting the service after a boot where my
> data is on a slow to mount filesystem.

The community does not produce any installers that use systemd.  You
will need to report this to the place you got the packages.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

Greetings,

* PG Bug reporting form (noreply@postgresql.org) wrote:
> The following bug has been logged on the website:
>
> Bug reference:      16708
> Logged by:          Pat Riehecky
> Email address:      jcpunk@gmail.com
> PostgreSQL version: 13.0
> Operating system:   Linux/systemd
> Description:
>
> Can the following be added to the systemd units:
>
> ```
> [Unit]
> After=local-fs.target nss-user-lookup.target
> ```
>
> This cleans up some of my issues starting the service after a boot where my
> data is on a slow to mount filesystem.

This is probably more appropriate to discuss with the packagers, and to
that point it'd be useful to know which OS (more specifically) you're
on, as we have different packagers for RPMs vs. DEBs and different lists
for discussing those topics.

Thanks,

Stephen

Greetings,

* Bruce Momjian (bruce@momjian.us) wrote:
> The community does not produce any installers that use systemd.  You
> will need to report this to the place you got the packages.

This is certainly not accurate, at least on Debian-based systems...

➜  ~ dpkg -L postgresql-common | grep systemd
/lib/systemd
/lib/systemd/system
/lib/systemd/system/postgresql.service
/lib/systemd/system/postgresql@.service
/lib/systemd/system-generators
/lib/systemd/system-generators/postgresql-generator
/usr/share/doc/postgresql-common/README.systemd
➜  ~ apt-cache policy postgresql-common
postgresql-common:
  Installed: 220.pgdg20.04+1
  Candidate: 220.pgdg20.04+1
  Version table:
 *** 220.pgdg20.04+1 500
        500 https://apt.postgresql.org/pub/repos/apt focal-pgdg/main amd64 Packages
        100 /var/lib/dpkg/status

Thanks,

Stephen

On Wed, Nov 11, 2020 at 04:15:37PM -0500, Stephen Frost wrote:
> Greetings,
> 
> * Bruce Momjian (bruce@momjian.us) wrote:
> > The community does not produce any installers that use systemd.  You
> > will need to report this to the place you got the packages.
> 
> This is certainly not accurate, at least on Debian-based systems...
> 
> ➜  ~ dpkg -L postgresql-common | grep systemd   
> /lib/systemd
> /lib/systemd/system
> /lib/systemd/system/postgresql.service
> /lib/systemd/system/postgresql@.service
> /lib/systemd/system-generators
> /lib/systemd/system-generators/postgresql-generator
> /usr/share/doc/postgresql-common/README.systemd
> ➜  ~ apt-cache policy postgresql-common
> postgresql-common:
>   Installed: 220.pgdg20.04+1
>   Candidate: 220.pgdg20.04+1
>   Version table:
>  *** 220.pgdg20.04+1 500
>         500 https://apt.postgresql.org/pub/repos/apt focal-pgdg/main amd64 Packages
>         100 /var/lib/dpkg/status

I see it labeled as pgdg, but exactly where do we discuss packaging of
Debian packages in our community?  I do see we distribute them.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

Greetings,

* Bruce Momjian (bruce@momjian.us) wrote:
> On Wed, Nov 11, 2020 at 04:15:37PM -0500, Stephen Frost wrote:
> > * Bruce Momjian (bruce@momjian.us) wrote:
> > > The community does not produce any installers that use systemd.  You
> > > will need to report this to the place you got the packages.
> >
> > This is certainly not accurate, at least on Debian-based systems...
> >
> > ➜  ~ dpkg -L postgresql-common | grep systemd
> > /lib/systemd
> > /lib/systemd/system
> > /lib/systemd/system/postgresql.service
> > /lib/systemd/system/postgresql@.service
> > /lib/systemd/system-generators
> > /lib/systemd/system-generators/postgresql-generator
> > /usr/share/doc/postgresql-common/README.systemd
> > ➜  ~ apt-cache policy postgresql-common
> > postgresql-common:
> >   Installed: 220.pgdg20.04+1
> >   Candidate: 220.pgdg20.04+1
> >   Version table:
> >  *** 220.pgdg20.04+1 500
> >         500 https://apt.postgresql.org/pub/repos/apt focal-pgdg/main amd64 Packages
> >         100 /var/lib/dpkg/status
>
> I see it labeled as pgdg, but exactly where do we discuss packaging of
> Debian packages in our community?  I do see we distribute them.

It's labeled as PGDG and from apt.postgresql.org.  For the Debian
packages, the appropriate place to discuss changes is
pgsql-pkg-debian@lists.postgresql.org.

We also have a pgsql-pkg-yum@lists.postgresql.org for discussing the RPM
based packages.

Thanks,

Stephen

On Wed, Nov 11, 2020 at 04:53:00PM -0500, Stephen Frost wrote:
> It's labeled as PGDG and from apt.postgresql.org.  For the Debian
> packages, the appropriate place to discuss changes is
> pgsql-pkg-debian@lists.postgresql.org.
> 
> We also have a pgsql-pkg-yum@lists.postgresql.org for discussing the RPM
> based packages.

Wow, I had no idea those lists even exists, but I see them now:

    https://www.postgresql.org/list/

Thanks.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee