Works On

Viewing:

Debian 9 (Stretch)

Same on:

Debian 10 (Buster) Ubuntu 18.04 LTS (Bionic Beaver)

Other versions:

Debian 11 (Bullseye) Debian 12 (Bookworm) Debian 13 (Trixie) Ubuntu 20.04 LTS (Focal Fossa) Ubuntu 22.04 LTS (Jammy Jellyfish) Ubuntu 24.04 LTS (Noble Numbat)

Details

Size: 15 lines
MD5: a2c1c7846d1d3c4b9f2ec0c8a5502b08
SHA256: 78feb4ef840fe09159429c7855985738319263a3a486a102ad187e2554a5c809

/etc/systemd/postgresql.service

# systemd service for managing all PostgreSQL clusters on the system. This
# service is actually a systemd target, but we are using a service since
# targets cannot be reloaded.

[Unit]
Description=PostgreSQL RDBMS

[Service]
Type=oneshot
ExecStart=/bin/true
ExecReload=/bin/true
RemainAfterExit=on

[Install]
WantedBy=multi-user.target

Copy & Paste

curl:

curl https://exampleconfig.com/api/v1/config/original/a2c1c7846d1d3c4b9f2ec0c8a5502b08?hint=postgresql.service

wget:

wget -O postgresql.service https://exampleconfig.com/api/v1/config/original/a2c1c7846d1d3c4b9f2ec0c8a5502b08?hint=postgresql.service

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/a2c1c7846d1d3c4b9f2ec0c8a5502b08?hint=postgresql.service' /><config><app>PostgreSQL</app><os>Debian 9 (Stretch)</os><location>/etc/systemd/postgresql.service</location><lines>15</lines><md5>a2c1c7846d1d3c4b9f2ec0c8a5502b08</md5><sha256>78feb4ef840fe09159429c7855985738319263a3a486a102ad187e2554a5c809</sha256></config></prompt>

Paste into Claude, ChatGPT, or any AI assistant.

Install PostgreSQL

Alpine Linux

sudo apk add postgresql

Debian

sudo apt update && sudo apt install postgresql

Red Hat Enterprise Linux

sudo yum install postgresql17-server

Ubuntu

sudo apt update && sudo apt install postgresql

File Location

File Path

/etc/systemd/postgresql.service

FAQ

When should I use this postgresql.service?

Use it to restore a missing default, confirm what shipped, or diff against your current PostgreSQL config.

How do I restore PostgreSQL defaults?

Download the file, back up the current one in /etc/systemd/postgresql.service, replace it, then reload or restart PostgreSQL.

Is postgresql.service safe for production?

It is the vendor default for Debian 9 (Stretch). Treat it as a baseline and review security and performance settings before production use.

How does this differ from other OS versions?

Defaults vary by distro and version. This copy matches Debian 9 (Stretch).

Can I use this for PostgreSQL troubleshooting?

Yes. Diff it against yours to find drift, then restore only the sections you need.

PostgreSQL /etc/systemd/postgresql.service