44 lines
994 B
Desktop File
44 lines
994 B
Desktop File
[Unit]
|
|
Description=PostgreSQL database server
|
|
After=network.target
|
|
|
|
[Service]
|
|
Type=notify
|
|
TimeoutSec=120
|
|
User=postgres
|
|
Group=postgres
|
|
|
|
Environment=PGROOT=/var/lib/postgres
|
|
|
|
SyslogIdentifier=postgres
|
|
PIDFile=/var/lib/postgres/data/postmaster.pid
|
|
RuntimeDirectory=postgresql
|
|
RuntimeDirectoryMode=755
|
|
|
|
ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGROOT}/data
|
|
ExecStart=/usr/bin/postgres -D ${PGROOT}/data
|
|
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
|