summaryrefslogtreecommitdiff
path: root/postgresql/etc/postgresql.conf
diff options
context:
space:
mode:
Diffstat (limited to 'postgresql/etc/postgresql.conf')
-rw-r--r--postgresql/etc/postgresql.conf24
1 files changed, 24 insertions, 0 deletions
diff --git a/postgresql/etc/postgresql.conf b/postgresql/etc/postgresql.conf
new file mode 100644
index 0000000..fcde2ed
--- /dev/null
+++ b/postgresql/etc/postgresql.conf
@@ -0,0 +1,24 @@
+max_connections = 20
+shared_buffers = 1600kB
+datestyle = 'iso, mdy'
+lc_messages = 'en_US.UTF-8'
+lc_monetary = 'en_US.UTF-8'
+lc_numeric = 'en_US.UTF-8'
+lc_time = 'en_US.UTF-8'
+default_text_search_config = 'pg_catalog.english'
+
+# Logging
+log_destination='csvlog,stderr'
+logging_collector=true
+log_directory='../log'
+log_filename='postmaster-%Y-%m-%d.log'
+log_min_messages=INFO
+log_min_error_statement=INFO
+log_min_duration_statement=10
+log_connections=true
+
+# WAL
+wal_level=archive
+
+archive_mode=true
+archive_command='../current/bin/archive-command "%p" "%f"'