Postgresql Default-Configs

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

/var/log/postgresql/*.log {
       weekly
       rotate 10
       copytruncate
       delaycompress
       compress
       notifempty
       missingok
       su root root
}

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

# 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 …

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

# 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…

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

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

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

# 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…

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

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

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

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

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

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

pg_ctl_options = ''

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

# 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…

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

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

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

# 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…

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

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

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

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

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

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

pg_ctl_options = ''

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

# 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…

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

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

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

# 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…

# PostgreSQL User Name Maps # ========================= # # --------------- # Mapping Records # -------------…

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

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

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

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

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

pg_ctl_options = ''