summarylogtreecommitdiffstats
path: root/postgresql.service
blob: 587014b0ce65ff23fa3f46aebe55df50af9aa622 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
[Unit]
Description=PostgreSQL $pkgver database server
After=network.target

[Service]
Type=notify
TimeoutSec=120
User=postgres
Group=postgres

Environment=PGROOT=/var/lib/postgres
Environment=PATH=/opt/$pkgbase/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

SyslogIdentifier=postgres
PIDFile=/var/lib/postgres/data$_majorver/postmaster.pid
RuntimeDirectory=postgresql
RuntimeDirectoryMode=755

ExecStartPre=/opt/$pkgbase/bin/postgresql-check-db-dir ${PGROOT}/data$_majorver
ExecStart=/opt/$pkgbase/bin/postgres -D ${PGROOT}/data$_majorver
ExecStartPost=/usr/bin/echo "Before using, source /opt/$pkgbase/bin/pgenv.sh to set PostgreSQL environment"
ExecReload=/bin/kill -HUP ${MAINPID}
KillMode=mixed
KillSignal=SIGINT

# Due to PostgreSQL's use of shared memory, OOM killer is often overzealous in
# killing Postgres, so adjust it downward
OOMScoreAdjust=-200

# Additional security-related features
PrivateTmp=true
ProtectHome=true
ProtectSystem=full
NoNewPrivileges=true
ProtectControlGroups=true
ProtectKernelModules=true
ProtectKernelTunables=true
PrivateDevices=true
RestrictAddressFamilies=AF_UNIX AF_INET AF_INET6
RestrictNamespaces=true
RestrictRealtime=true
SystemCallArchitectures=native

[Install]
WantedBy=multi-user.target