MIME-Version: 1.0
From: Andrew Jackson <andrewjackson947@gmail.com>
Date: Thu, 27 Nov 2025 12:55:11 -0600
Message-ID: 
 <CAKK5BkFfMpAQnv8CLs=i=rZwurtCV_gmfRb0uZi-V+d6wcryqg@mail.gmail.com>
Subject: Add Restart=on-failure To Example Systemd File
To: pgsql-docs@postgresql.org
Content-Type: multipart/mixed; boundary="0000000000009fd55a0644980fec"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKK5BkFfMpAQnv8CLs%3Di%3DrZwurtCV_gmfRb0uZi-V%2Bd6wcryqg%40mail.gmail.com>
Precedence: bulk

--0000000000009fd55a0644980fec
Content-Type: text/plain; charset="UTF-8"

Hi,

Currently the systemd file in the documentation does not specify a
restart policy. By default systemd will not attempt to restart a
service that has failed (killed by OOM-killer for example) [0]. The
systemd docs recommends "Setting this to on-failure is the recommended
choice for long-running services, in order to increase reliability by
attempting automatic recovery from errors." I think that Postgres is
probably a good example of a "long-running service". Pgbouncer for
example also uses "Restart=on-failure" [1].

Wondering also if there are any factors that I am not considering
here. Perhaps if this is the case that this is not good blanket
guidance, it would be worth it to provide some guidance around Restart
systemd parameter in the postgres docs.

[0] https://www.freedesktop.org/software/systemd/man/latest/systemd.service.html
[1] https://github.com/pgbouncer/pgbouncer/blob/master/etc/pgbouncer.service

Thanks,
Andrew Jackson

--0000000000009fd55a0644980fec
Content-Type: text/x-patch; charset="US-ASCII";
	name="0001-doc-Add-restart-on-failure-to-example-systemd-file.patch"
Content-Disposition: attachment;
	filename="0001-doc-Add-restart-on-failure-to-example-systemd-file.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mihsfat10>
X-Attachment-Id: f_mihsfat10

RnJvbSA5YTA4ODVlY2ZjY2JlNjlkNjcwNGQwYzBkNjkzNDdjY2MyM2NkZGRiIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBBbmRyZXcgSmFja3NvbiA8YW5kcmV3amFja3Nvbjk0N0BnbWFp
bC5jb20+CkRhdGU6IFRodSwgMjcgTm92IDIwMjUgMTA6NDU6NTIgLTA2MDAKU3ViamVjdDogW1BB
VENIXSBkb2M6IEFkZCByZXN0YXJ0IG9uIGZhaWx1cmUgdG8gZXhhbXBsZSBzeXN0ZW1kIGZpbGUK
ClRoZSBkb2N1bWVudGF0aW9uIHByZXZpb3VzbHkgaGFkIGEgc3lzdGVtZCB1bml0IGZpbGUKdGhh
dCB3b3VsZCBub3QgYXR0ZW1wdCB0byByZWNvdmVyIGZyb20gcHJvY2VzcyBmYWlsdXJlcwpzdWNo
IGFzIE9PTSdzLCBzZWdmYXVsdHMsIGV0Yy4gVGhpcyBjb21taXQgYWRkcwpgUmVzdGFydD1vbi1m
YWlsdXJlYCB3aGljaCB0ZWxscyBzeXN0ZW1kIHRvIGF0dGVtcHQgdG8KcmVzdGFydCB0aGUgcHJv
Y2VzcyBhZnRlciBmYWlsdXJlLiBUaGlzIGlzIHRoZSByZWNvbW1lbmRlZApjb25maWd1cmF0aW9u
IHBlciB0aGUgc3lzdGVtZCBkb2N1bWVudGF0aW9uOiAiU2V0dGluZyB0aGlzCnRvIG9uLWZhaWx1
cmUgaXMgdGhlIHJlY29tbWVuZGVkIGNob2ljZSBmb3IgbG9uZy1ydW5uaW5nCnNlcnZpY2VzIi4g
TW9zdCBwb3N0Z3JlcyB1c2VycyB3aWxsIHNpbXBseSBjb3B5L3Bhc3RlCndoYXQgdGhlIHBvc3Rn
cmVzIGRvY3MgcmVjb21tZW5kIGFuZCB3aWxsIHByb2JhYmx5IGRvCnRoZWlyIG93biByZXNlYXJj
aCBhbmQgY2hhbmdlIHRoZSBzZXJ2aWNlIGZpbGUgdG8gcmVzdGFydApvbiBmYWlsdXJlLCBzbyBt
aWdodCBhcyB3ZWxsIHNldCB0aGlzIGFzIHRoZSBkZWZhdWx0IGluCnRoZSBwb3N0Z3JlcyBkb2Nz
LgotLS0KIGRvYy9zcmMvc2dtbC9ydW50aW1lLnNnbWwgfCAxICsKIDEgZmlsZSBjaGFuZ2VkLCAx
IGluc2VydGlvbigrKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9ydW50aW1lLnNnbWwgYi9k
b2Mvc3JjL3NnbWwvcnVudGltZS5zZ21sCmluZGV4IDBjNjBiYWZhYzYzLi5kYmIzYjJlZjUzZiAx
MDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3J1bnRpbWUuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwv
cnVudGltZS5zZ21sCkBAIC00OTEsNiArNDkxLDcgQEAgRXhlY1JlbG9hZD0vYmluL2tpbGwgLUhV
UCAkTUFJTlBJRAogS2lsbE1vZGU9bWl4ZWQKIEtpbGxTaWduYWw9U0lHSU5UCiBUaW1lb3V0U2Vj
PWluZmluaXR5CitSZXN0YXJ0PW9uLWZhaWx1cmUKCiBbSW5zdGFsbF0KIFdhbnRlZEJ5PW11bHRp
LXVzZXIudGFyZ2V0Ci0tCjIuNDkuMAoK
--0000000000009fd55a0644980fec--