summaryrefslogtreecommitdiffstats
path: root/abs/extra/postgresql/postgresql.service
diff options
context:
space:
mode:
authorBritney Fransen <brfransen@gmail.com>2018-03-02 23:35:59 (GMT)
committerBritney Fransen <brfransen@gmail.com>2018-03-02 23:35:59 (GMT)
commitfd8405efa6e0c17c9e666f5ea8584039f31a5168 (patch)
tree641cafbb31cb0387ac10b0641427d850d15a4b93 /abs/extra/postgresql/postgresql.service
parent1577770bf29c22dd1a2e14c055b5af2f1408eb39 (diff)
downloadlinhes_pkgbuild-fd8405efa6e0c17c9e666f5ea8584039f31a5168.zip
linhes_pkgbuild-fd8405efa6e0c17c9e666f5ea8584039f31a5168.tar.gz
linhes_pkgbuild-fd8405efa6e0c17c9e666f5ea8584039f31a5168.tar.bz2
postgresql: update to 10.2
Diffstat (limited to 'abs/extra/postgresql/postgresql.service')
-rw-r--r--abs/extra/postgresql/postgresql.service34
1 files changed, 34 insertions, 0 deletions
diff --git a/abs/extra/postgresql/postgresql.service b/abs/extra/postgresql/postgresql.service
new file mode 100644
index 0000000..37fcae9
--- /dev/null
+++ b/abs/extra/postgresql/postgresql.service
@@ -0,0 +1,34 @@
+[Unit]
+Description=PostgreSQL database server
+After=network.target
+
+[Service]
+Type=forking
+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/pg_ctl -s -D ${PGROOT}/data start -w -t 120
+ExecReload=/usr/bin/pg_ctl -s -D ${PGROOT}/data reload
+ExecStop= /usr/bin/pg_ctl -s -D ${PGROOT}/data stop -m fast
+
+# 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
+
+[Install]
+WantedBy=multi-user.target