- more things, reminder about password etc

[packages/postgresql.git] / postgresql.sysconfig

diff --git a/postgresql.sysconfig b/postgresql.sysconfig
index d884eb0b39705d9a91d18ecf472a142349c459b8..b006111331efa7bc6ab87ebdfe1903b4ecd7bfcc 100644 (file)
--- a/postgresql.sysconfig
+++ b/postgresql.sysconfig
@@ -1,8 +1,57 @@
 # $Revision$
 
+# Root of the tree of database directories
+POSTGRES_DATA_DIR=/var/lib/pgsql
+
+#
+# postgres(1) backend options run by postmaster
+#
+# run postgres(1) backend in quiet mode
+POSTGRES_QUIET=no
+
 # Enable listening on TCP port. Without this postmaster responds
 # only on unix socket
 ALLOW_TCP_CONNECTIONS=no
 
-# Optional parameters
-OPTIONS=
+# For production machines you should increase those numbers to avoid "Too 
+# many connections" messages. Buffers should be (at least) MaxConn*2.
+# But: watch carefully that you won't exceed system resources!!
+# Leave it blank to have default (safe) 32 clients/64 buffers.
+
+MAXCONN=
+BUFFERS=
+
+# Allow using SSL on TCP connections. Requires ALLOW_TCP_CONNECTIONS to be
+# set to yes. Also, you must supply key and certificate files
+# ($POSTGRES_DATA_DIR/server.{key,crt})
+ALLOW_USE_SSL=no
+
+# Disable automatic fsync() call after each transaction. This option
+# improves performance, but an operating system crash while a transaction is
+# in progress will probably cause data loss.
+POSTGRES_DISABLE_FSYNC=no
+
+# Where postmaster output is redirected
+POSTGRES_LOG=/var/log/pgsql
+
+# Default database chcaracter encoding
+# Avaible character sets:
+#
+# Encoding     | Description
+# --------------------------------------------------------------
+# SQL_ASCII    | ASCII
+# EUC_JP       | Japanese EUC
+# EUC_CN       | Chinese EUC
+# EUC_KR       | Korean EUC
+# EUC_TW       | Taiwan EUC
+# UNICODE      | Unicode(UTF-8)
+# MULE_INTERNAL | Mule internal
+# LATIN1       | ISO 8859-1 English and some European languages
+# LATIN2       | ISO 8859-2 English and some European languages
+# LATIN3       | ISO 8859-3 English and some European languages
+# LATIN4       | ISO 8859-4 English and some European languages
+# LATIN5       | ISO 8859-5 English and some European languages
+# KOI8         | KOI8-R
+# WIN          | Windows CP1251
+# ALT          | Windows CP866                 
+ENCODING=UNICODE
\ No newline at end of file