Page MenuHomeDevCentral

postgresql.conf
No OneTemporary

postgresql.conf

# -------------------------------------------------------------
# PostgreSQL
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# Project: Nasqueron
# License: Trivial work, not eligible to copyright
# Source file: roles/dbserver-pgsql/server/files/postgresql.conf
# Cluster: {{ server.cluster }}
# -------------------------------------------------------------
#
# <auto-generated>
# This file is managed by our rOPS SaltStack repository.
#
# Changes to this file may cause incorrect behavior
# and will be lost if the state is redeployed.
# </auto-generated>
# -------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
listen_addresses = '{{ server.listen_addresses }}'
max_connections = 100
# -------------------------------------------------------------
# RESOURCE USAGE (except WAL)
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
shared_buffers = 128MB
dynamic_shared_memory_type = posix
# -------------------------------------------------------------
# WRITE-AHEAD LOG (WAL)
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
min_wal_size = 80MB
max_wal_size = 1GB
# -------------------------------------------------------------
# REPORTING AND LOGGING
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
log_destination = 'syslog'
log_timezone = 'UTC'
# -------------------------------------------------------------
# PROCESS TITLE
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# On FreeBSD, this is a performance hog, so keep it off if you need speed
update_process_title = off
# -------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'C' # locale for system error message
lc_monetary = 'C' # locale for monetary formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'C' # locale for time formatting
default_text_search_config = 'pg_catalog.english'

File Metadata

Mime Type
text/plain
Expires
Thu, May 1, 02:46 (1 d, 7 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2571137
Default Alt Text
postgresql.conf (2 KB)

Event Timeline