X-Git-Url: https://git.pld-linux.org/?a=blobdiff_plain;f=postgresql.sysconfig;h=f3f4735ab87c5c9bf3127ad8c1bdf74368d4282f;hb=3081b7c45b251e1f97c363bde9e32ad9aa5c21ab;hp=8f331ebe93c8ad0e4677276c470f18331eafdf49;hpb=bf718f8c782031f5417293655c0b03e2a9904fe9;p=packages%2Fpostgresql.git diff --git a/postgresql.sysconfig b/postgresql.sysconfig index 8f331eb..f3f4735 100644 --- a/postgresql.sysconfig +++ b/postgresql.sysconfig @@ -1,27 +1,23 @@ # $Revision$ -# Root of the tree of database directories -POSTGRES_DATA_DIR=/var/lib/pgsql - # -# postgres(1) backend options run by postmaster +# Edit postgresql.conf file in database cluster directory to configure +# PostgreSQL. If you want to start more than one PostgreSQL instance, +# you should change TCP/IP port, at least. +# +# Under systemd each cluster is started under a different postgresql@.service +# instance, the default being postgresql@var-lib-pgsql.service # -# run postgres(1) backend in quiet mode -POSTGRES_QUIET=no +# To enable a new one use; /bin/systemctl enable postgresql@${instance}.service -# Enable listening on TCP port. Without this postmaster responds -# only on unix socket -ALLOW_TCP_CONNECTIONS=no +# locale used at service postgresql init +# PG_INIT_LOCALE=C -# 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 +# standard setting +PG_DB_CLUSTERS="/var/lib/pgsql" -# 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 +# predictable usage +# PG_DB_CLUSTERS="/var/lib/pgsql/01 /var/lib/pgsql/02" -# Where postmaster output is redirected -POSTGRES_LOG=/var/log/pgsql +# new database disk arrived +# PG_DB_CLUSTERS="/var/lib/pgsql/01 /var/lib/pgsql/02 /mnt/db/01"