100% Free & Open

Postgresql Configuration Files

Original, unaltered PostgreSQL config files from fresh installations

27 Postgresql Configuration Files

Original, unaltered configurations from fresh installations

/etc/logrotate.d/postgresql-common

PostgreSQL Debian 9 (Stretch) Ubuntu 18.04 LTS (Bionic Beaver)

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
       notifempty
       missingok
       su root root
}

11 lines • MD5: 101326ef... Click to view full file

/etc/systemd/postgresql@.service

PostgreSQL Debian 9 (Stretch) Ubuntu 18.04 LTS (Bionic Beaver)

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", e.g. "postgresql@9.3-main". The
# variable %i expands to "version-cluster", %I …

34 lines • MD5: c60e225d... Click to view full file

/etc/systemd/postgresql.service

PostgreSQL Debian 9 (Stretch) Ubuntu 18.04 LTS (Bionic Beaver)

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 we are using a service since
# targets cannot be reloaded.

[Unit]
Description=P…

16 lines • MD5: a2c1c784... Click to view full file

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

PostgreSQL Debian 9 (Stretch)

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

📍 Debian 9 (Stretch)

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace …

648 lines • MD5: 42afa934... Click to view full file

/etc/postgresql/9.6/main/environment

PostgreSQL Debian 9 (Stretch)

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_value
#  VARIABLE2 = 'any value!'
# I. e. you need to enclose any value which d…

8 lines • MD5: a567730a... Click to view full file

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

PostgreSQL Debian 9 (Stretch)

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

📍 Debian 9 (Stretch)

# PostgreSQL User Name Maps
# =========================
#
# Refer to the PostgreSQL documentation, chapter "Client
# Authentication" for a complete description.  A short synopsis
# follows.
#
# This …

43 lines • MD5: f11c8332... Click to view full file

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

PostgreSQL Debian 9 (Stretch)

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

📍 Debian 9 (Stretch)

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a co…

100 lines • MD5: cbf62fe3... Click to view full file

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

PostgreSQL Debian 9 (Stretch)

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).

pg_ctl_options = ''

6 lines • MD5: 242d50c2... Click to view full file

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

PostgreSQL Debian 9 (Stretch)

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

📍 Debian 9 (Stretch)

# Automatic startup configuration
#   auto: automatically start the cluster
#   manual: manual startup with pg_ctlcluster/postgresql@.service only
#   disabled: refuse to start cluster
# See pg_creat…

9 lines • MD5: 9bb73ac2... Click to view full file

/etc/postgresql/11/main/postgresql.conf

PostgreSQL Debian 10 (Buster)

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

📍 Debian 10 (Buster)

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace …

692 lines • MD5: ec4d26fc... Click to view full file

/etc/postgresql/11/main/environment

PostgreSQL Debian 10 (Buster)

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_value
#  VARIABLE2 = 'any value!'
# I. e. you need to enclose any value which d…

8 lines • MD5: a567730a... Click to view full file

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

PostgreSQL Debian 10 (Buster)

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

📍 Debian 10 (Buster)

# PostgreSQL User Name Maps
# =========================
#
# Refer to the PostgreSQL documentation, chapter "Client
# Authentication" for a complete description.  A short synopsis
# follows.
#
# This …

43 lines • MD5: f11c8332... Click to view full file

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

PostgreSQL Debian 10 (Buster)

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

📍 Debian 10 (Buster)

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a co…

100 lines • MD5: 81569154... Click to view full file

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

PostgreSQL Debian 10 (Buster)

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).

pg_ctl_options = ''

6 lines • MD5: 242d50c2... Click to view full file

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

PostgreSQL Debian 10 (Buster)

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

📍 Debian 10 (Buster)

# Automatic startup configuration
#   auto: automatically start the cluster
#   manual: manual startup with pg_ctlcluster/postgresql@.service only
#   disabled: refuse to start cluster
# See pg_creat…

9 lines • MD5: 9bb73ac2... Click to view full file

/etc/postgresql/17/main/postgresql.conf

PostgreSQL Debian 11 (Bullseye) Ubuntu 20.04 LTS (Focal Fossa)

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

📍 Debian 11 (Bullseye), Debian 12 (Bookworm)

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

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace …

845 lines • MD5: 041908e5... Click to view full file

/etc/postgresql/17/main/environment

PostgreSQL Debian 11 (Bullseye) Ubuntu 20.04 LTS (Focal Fossa)

PostgreSQL - /etc/postgresql/17/main/environment

📍 Debian 11 (Bullseye), Debian 12 (Bookworm)

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

# environment variables for postgres processes
# This file has the same syntax as postgresql.conf:
#  VARIABLE = simple_value
#  VARIABLE2 = 'any value!'
# I. e. you need to enclose any value which d…

8 lines • MD5: a567730a... Click to view full file

/etc/postgresql/17/main/pg_ident.conf

PostgreSQL Debian 11 (Bullseye) Ubuntu 20.04 LTS (Focal Fossa)

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

📍 Debian 11 (Bullseye), Debian 12 (Bookworm)

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

# PostgreSQL User Name Maps
# =========================
#
# ---------------
# Mapping Records
# ---------------
#
# Refer to the PostgreSQL documentation, chapter "Client
# Authentication" for a comp…

73 lines • MD5: a851d3ee... Click to view full file

/etc/postgresql/17/main/pg_hba.conf

PostgreSQL Debian 11 (Bullseye) Ubuntu 20.04 LTS (Focal Fossa)

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

📍 Debian 11 (Bullseye), Debian 12 (Bookworm)

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

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a co…

133 lines • MD5: 7f6ef676... Click to view full file

/etc/postgresql/17/main/pg_ctl.conf

PostgreSQL Debian 11 (Bullseye) Ubuntu 20.04 LTS (Focal Fossa)

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

📍 Debian 11 (Bullseye), Debian 12 (Bookworm)

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

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

pg_ctl_options = ''

6 lines • MD5: 242d50c2... Click to view full file

🛠️ Browse Configuration Files

Explore configs by application or operating system

📱 Applications

💻 Operating Systems

Ubuntu 18.04 LTS (Bionic Beaver)

Ubuntu 20.04 LTS (Focal Fossa)

Ubuntu 22.04 LTS (Jammy Jellyfish)

Ubuntu 24.04 LTS (Noble Numbat)

Red Hat Enterprise Linux 8 (Ootpa)

Red Hat Enterprise Linux 9 (Plow)

Alpine Linux v3.21

CentOS Stream 9

CentOS Stream 10