Postgresql Configuration Files

Original, unaltered PostgreSQL config files from fresh installations

27 Postgresql Configuration Files

PostgreSQL - /etc/logrotate.d/postgresql-common

📍 Debian 9 (Stretch), Debian 10 (Buster), Debian 11 (Bullseye), Debian 12 (Bookworm)

📍 Ubuntu 18.04 LTS (Bionic Beaver), Ubuntu 20.04 LTS (Focal Fossa), Ubuntu 22.04 LTS (Jammy Jellyfish), Ubuntu 24.04 LTS (Noble Numbat)

/var/log/postgresql/*.log { weekly rotate 10 copytruncate delaycompress compress …

11 lines • MD5: 101326ef...

PostgreSQL Debian

PostgreSQL - /etc/systemd/postgresql@.service

📍 Debian 9 (Stretch), Debian 10 (Buster), Debian 11 (Bullseye), Debian 12 (Bookworm)

📍 Ubuntu 18.04 LTS (Bionic Beaver), Ubuntu 20.04 LTS (Focal Fossa), Ubuntu 22.04 LTS (Jammy Jellyfish), Ubuntu 24.04 LTS (Noble Numbat)

# systemd service template for PostgreSQL clusters. The actual instances will # be called "postgresql@version-cluster",…

34 lines • MD5: c60e225d...

PostgreSQL Debian

PostgreSQL - /etc/systemd/postgresql.service

📍 Debian 9 (Stretch), Debian 10 (Buster), Debian 11 (Bullseye), Debian 12 (Bookworm)

📍 Ubuntu 18.04 LTS (Bionic Beaver), Ubuntu 20.04 LTS (Focal Fossa), Ubuntu 22.04 LTS (Jammy Jellyfish), Ubuntu 24.04 LTS (Noble Numbat)

# systemd service for managing all PostgreSQL clusters on the system. This # service is actually a systemd target, but …

16 lines • MD5: a2c1c784...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/9.6/main/postgresql.conf

📍 Debian 9 (Stretch)

# ----------------------------- # PostgreSQL configuration file # ----------------------------- # # This file consists …

648 lines • MD5: 42afa934...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/9.6/main/environment

📍 Debian 9 (Stretch)

# environment variables for postgres processes # This file has the same syntax as postgresql.conf: # VARIABLE = simple…

8 lines • MD5: a567730a...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/9.6/main/pg_ident.conf

📍 Debian 9 (Stretch)

# PostgreSQL User Name Maps # ========================= # # Refer to the PostgreSQL documentation, chapter "Client # Au…

43 lines • MD5: f11c8332...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/9.6/main/pg_hba.conf

📍 Debian 9 (Stretch)

# PostgreSQL Client Authentication Configuration File # =================================================== # # Refer t…

100 lines • MD5: cbf62fe3...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/9.6/main/pg_ctl.conf

📍 Debian 9 (Stretch)

# Automatic pg_ctl configuration # This configuration file contains cluster specific options to be passed to # pg_ctl(1…

6 lines • MD5: 242d50c2...

PostgreSQL Debian

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

📍 Debian 9 (Stretch)

# Automatic startup configuration # auto: automatically start the cluster # manual: manual startup with pg_ctlclust…

9 lines • MD5: 9bb73ac2...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/11/main/postgresql.conf

📍 Debian 10 (Buster)

# ----------------------------- # PostgreSQL configuration file # ----------------------------- # # This file consists …

692 lines • MD5: ec4d26fc...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/11/main/environment

📍 Debian 10 (Buster)

# environment variables for postgres processes # This file has the same syntax as postgresql.conf: # VARIABLE = simple…

8 lines • MD5: a567730a...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/11/main/pg_ident.conf

📍 Debian 10 (Buster)

# PostgreSQL User Name Maps # ========================= # # Refer to the PostgreSQL documentation, chapter "Client # Au…

43 lines • MD5: f11c8332...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/11/main/pg_hba.conf

📍 Debian 10 (Buster)

# PostgreSQL Client Authentication Configuration File # =================================================== # # Refer t…

100 lines • MD5: 81569154...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/11/main/pg_ctl.conf

📍 Debian 10 (Buster)

# Automatic pg_ctl configuration # This configuration file contains cluster specific options to be passed to # pg_ctl(1…

6 lines • MD5: 242d50c2...

PostgreSQL Debian

PostgreSQL - /etc/postgresql/11/main/start.conf

📍 Debian 10 (Buster)

# Automatic startup configuration # auto: automatically start the cluster # manual: manual startup with pg_ctlclust…

9 lines • MD5: 9bb73ac2...

PostgreSQL Debian