https://bugs.koozali.org/show_bug.cgi?id=12355
John Crisp <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from John Crisp <[email protected]> ---
Hmmmm. Seems there are some related issues with postgresql if you have a search
online.
There is a possible issue with the configuration of postgresql/sytemd unit
files. Doesn't seem to be any real standards with for unit files with
postgresql.
https://www.postgresql.org/docs/13/server-start.html
"On Linux systems either add
/usr/local/pgsql/bin/pg_ctl start -l logfile -D /usr/local/pgsql/data
to /etc/rc.d/rc.local or /etc/rc.local or look at the file
contrib/start-scripts/linux in the PostgreSQL source distribution.
When using systemd, you can use the following service unit file (e.g., at
/etc/systemd/system/postgresql.service):
[Unit]
Description=PostgreSQL database server
Documentation=man:postgres(1)
After=network-online.target
Wants=network-online.target
[Service]
Type=notify
User=postgres
ExecStart=/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=infinity
[Install]
WantedBy=multi-user.target"
Using Type=notify requires that the server binary was built with configure
--with-systemd.
Consider carefully the timeout setting. systemd has a default timeout of 90
seconds as of this writing and will kill a process that does not report
readiness within that time. But a PostgreSQL server that might have to perform
crash recovery at startup could take much longer to become ready. The suggested
value of infinity disables the timeout logic."
I can see our systemd unit file uses:
TimeoutSec=infinity
cat /usr/lib/systemd/system/postgresql-13.service.d/51koozali.conf
I wonder if there are some options required in some of the init files?
Note there are other config files and it is a complicate dance:
/usr/lib/systemd/system/pgsql.init.service
/sbin/e-smith/systemd/postgresql-initialize
/etc/rc.d/init.d/ pgsql.init
--
You are receiving this mail because:
You are the QA Contact for the bug.
You are the assignee for the bug._______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/
