public
Created

postgresql.service

  • Download Gist
postgresql.service
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
[Unit]
Description=PostgreSQL database server
 
[Service]
Type=forking
Environment=PGROOT=/var/lib/postgres
SyslogIdentifier=postgres
PIDFile=/var/lib/postgres/data/postmaster.pid
 
# initdb script takes care for symlinking $PGROOT to /var/lib/postgres
ExecStartPre=/usr/lib/systemd/scripts/postgresql-initdb
ExecStart= /bin/su - postgres -m -c "/usr/bin/pg_ctl -s -D ${PGROOT}/data start"
ExecReload=/bin/su - postgres -m -c "/usr/bin/pg_ctl -s -D ${PGROOT}/data reload"
ExecStop= /bin/su - postgres -m -c "/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
OOMScoreAdjust=-200
 
[Install]
WantedBy=multi-user.target

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.