Works On

Viewing:

Debian 9 (Stretch)

Same on:

Other versions:

Details

Size: 8 lines
MD5: 9bb73ac29fd5f433229675e12d493acf
SHA256: e83be42666e695b4e43c65fee5967e8f30e814ca49e473fad9ccf86a42b4f30a

/etc/postgresql/9.6/main/start.conf

# Automatic startup configuration
#   auto: automatically start the cluster
#   manual: manual startup with pg_ctlcluster/postgresql@.service only
#   disabled: refuse to start cluster
# See pg_createcluster(1) for details. When running from systemd,
# invoke 'systemctl daemon-reload' after editing this file.

auto

Copy & Paste

curl:

curl https://exampleconfig.com/api/v1/config/original/9bb73ac29fd5f433229675e12d493acf?hint=start.conf

wget:

wget -O start.conf https://exampleconfig.com/api/v1/config/original/9bb73ac29fd5f433229675e12d493acf?hint=start.conf

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/9bb73ac29fd5f433229675e12d493acf?hint=start.conf' /><config><app>PostgreSQL</app><os>Debian 9 (Stretch)</os><location>/etc/postgresql/9.6/main/start.conf</location><lines>8</lines><md5>9bb73ac29fd5f433229675e12d493acf</md5><sha256>e83be42666e695b4e43c65fee5967e8f30e814ca49e473fad9ccf86a42b4f30a</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/postgresql/9.6/main/start.conf

FAQ

When should I use this start.conf?

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/postgresql/9.6/main/start.conf, replace it, then reload or restart PostgreSQL.

Is start.conf 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/postgresql/9.6/main/start.conf