Reposting message to initscripts-devel:
Hi,
A slight modification to the postgresql startup script:
postgresql.log.1 is the output from systemctl status postgresql before
applying the drop-in.
postgresql.log.2 is the output from systemctl status postgresql after
applying the drop-in.
postgresql.service.conf is the actual drop-in from
/etc/systemd/system/postgresql.service.d applied to the Fedora 30
postgresql-11.5-1.fc30 package.
The drop-in setting should replace the unit file setting in
/usr/lib/systemd/system/postgresql.service.
Have a pleasant day,
Mischa Baars.
● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor
preset: disabled)
Active: active (running) since Tue 2019-09-24 09:45:45 CEST; 1min 25s ago
Process: 742 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql
(code=exited, status=0/SUCCESS)
Main PID: 760 (postmaster)
Tasks: 8 (limit: 4444)
Memory: 27.6M
CGroup: /system.slice/postgresql.service
├─760 /usr/bin/postmaster -D /var/lib/pgsql/data
├─775 postgres: logger
├─778 postgres: checkpointer
├─779 postgres: background writer
├─780 postgres: walwriter
├─781 postgres: autovacuum launcher
├─782 postgres: stats collector
└─783 postgres: logical replication launcher
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.207
CEST [760] LOG: listening on IPv6 address "::1", port 5432
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.207
CEST [760] LOG: listening on IPv4 address "127.0.0.1", port 5432
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.215
CEST [760] LOG: could not bind IPv4 address "192.168.1.13": Cannot assign
requested address
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.215
CEST [760] HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.215
CEST [760] WARNING: could not create listen socket for "192.168.1.13"
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.215
CEST [760] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.220
CEST [760] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.279
CEST [760] LOG: redirecting log output to logging collector process
Sep 24 09:45:45 dt0d.cyberfiber.eu postmaster[760]: 2019-09-24 09:45:45.279
CEST [760] HINT: Future log output will appear in directory "log".
Sep 24 09:45:45 dt0d.cyberfiber.eu systemd[1]: Started PostgreSQL database
server.
● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor
preset: disabled)
Drop-In: /etc/systemd/system/postgresql.service.d
└─postgresql.service.conf
Active: active (running) since Tue 2019-09-24 09:49:55 CEST; 58s ago
Process: 957 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql
(code=exited, status=0/SUCCESS)
Main PID: 964 (postmaster)
Tasks: 8 (limit: 4444)
Memory: 26.3M
CGroup: /system.slice/postgresql.service
├─964 /usr/bin/postmaster -D /var/lib/pgsql/data
├─982 postgres: logger
├─984 postgres: checkpointer
├─985 postgres: background writer
├─986 postgres: walwriter
├─987 postgres: autovacuum launcher
├─988 postgres: stats collector
└─989 postgres: logical replication launcher
Sep 24 09:49:55 dt0d.cyberfiber.eu systemd[1]: Starting PostgreSQL database
server...
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.225
CEST [964] LOG: listening on IPv6 address "::1", port 5432
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.225
CEST [964] LOG: listening on IPv4 address "127.0.0.1", port 5432
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.232
CEST [964] LOG: listening on IPv4 address "192.168.1.13", port 5432
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.233
CEST [964] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.236
CEST [964] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.303
CEST [964] LOG: redirecting log output to logging collector process
Sep 24 09:49:55 dt0d.cyberfiber.eu postmaster[964]: 2019-09-24 09:49:55.303
CEST [964] HINT: Future log output will appear in directory "log".
Sep 24 09:49:55 dt0d.cyberfiber.eu systemd[1]: Started PostgreSQL database
server.
# It's not recommended to modify this file in-place, because it will be
# overwritten during package upgrades. It is recommended to use systemd
# "dropin" feature; i.e. create file with suffix .conf under
# /etc/systemd/system/UNITNAME.service.d directory overriding the
# unit's defaults. Look at systemd.unit(5) manual page for more info.
[Unit]
After=network-online.target
_______________________________________________
devel mailing list -- devel@lists.fedoraproject.org
To unsubscribe send an email to devel-le...@lists.fedoraproject.org
Fedora Code of Conduct:
https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives:
https://lists.fedoraproject.org/archives/list/devel@lists.fedoraproject.org
