summaryrefslogtreecommitdiff
path: root/databases/postgresql82-server/MESSAGE
diff options
context:
space:
mode:
authoradam <adam>2006-12-09 15:34:13 +0000
committeradam <adam>2006-12-09 15:34:13 +0000
commite1acd38de1385ee8cbc5430aec43458e651a8cc5 (patch)
tree23d35fae2cbc526b75353b476806d5fe4a3ec1fb /databases/postgresql82-server/MESSAGE
parentdab2a00f92d45a3472eaa2dd44a7f748ad5f1e8c (diff)
downloadpkgsrc-e1acd38de1385ee8cbc5430aec43458e651a8cc5.tar.gz
Changes 8.2.0:
* Query language enhancements including "INSERT/UPDATE/DELETE RETURNING", multirow VALUES lists, and optional target-table alias in "UPDATE"/"DELETE" * Index creation without blocking concurrent "INSERT"/"UPDATE"/"DELETE" operations * Many query optimization improvements, including support for reordering outer joins * Improved sorting performance with lower memory usage * More efficient locking with better concurrency * More efficient vacuuming * Easier administration of warm standby servers * New FILLFACTOR support for tables and indexes * Monitoring, logging, and performance tuning additions * More control over creating and dropping objects * Table inheritance relationships can be defined for and removed from pre-existing tables * "COPY TO" can copy the output of an arbitrary "SELECT" statement * Array improvements, including nulls in arrays * Aggregate-function improvements, including multiple-input aggregates and SQL:2003 statistical functions * Many "contrib/" improvements
Diffstat (limited to 'databases/postgresql82-server/MESSAGE')
-rw-r--r--databases/postgresql82-server/MESSAGE19
1 files changed, 19 insertions, 0 deletions
diff --git a/databases/postgresql82-server/MESSAGE b/databases/postgresql82-server/MESSAGE
new file mode 100644
index 00000000000..f2c5c15c558
--- /dev/null
+++ b/databases/postgresql82-server/MESSAGE
@@ -0,0 +1,19 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 15:34:40 adam Exp $
+
+To enable this package, put the following into your /etc/rc.conf:
+
+ pgsql=yes
+ pgsql_flags="-l" # enables SSL connections (TCP/IP and
+ # ~pgsql/data/server.crt required)
+
+and ensure that
+
+ ${RCD_SCRIPTS_DIR}/pgsql start
+
+is run at the appropriate time.
+
+Note: PostgreSQL 8.2 accepts TCP/IP connections on localhost address
+by default.
+
+===========================================================================