Split the postgresql ports into a server and a client part. The

following knobs can be used by ports depending on PostgreSQL:

# USE_PGSQL     - Add PostgreSQL client dependency.
#                 If no version is given (by the maintainer via the port or
#                 by the user via defined variable), try to find the
#                 currently installed version.  Fall back to default if
#                 necessary (PostgreSQL-7.4 = 74).
# DEFAULT_PGSQL_VER
#               - PostgreSQL default version. Can be overridden within a port.
#                 Default: 74.
# WANT_PGSQL_VER
#               - Maintainer can set an arbitrary version of PostgreSQL by
#                 using it.
# BROKEN_WITH_PGSQL
#               - This variable can be defined if the ports doesn't support
#                 one or more versions of PostgreSQL.

Note that a periodic script is installed that will, by default, vacuum
all databases nightly. You may want to tweak the settings, see the
script at ${LOCALBASE}/etc/periodic/daily/502.pgsql

To run PostgreSQL at boot time, set postgresql_enable=yes in /etc/rc.conf.

Note
PR:		75344
Approved by:	portmgr@ (kris), ade & sean (mentors)

1 files changed, 12 insertions, 0 deletions

diff --git a/databases/postgresql74-server/files/regresspatch-src-test-regress-pgregress-sh b/databases/postgresql74-server/files/regresspatch-src-test-regress-pgregress-sh
new file mode 100644
index 000000000000..2d27da307ef4
--- /dev/null
+++ b/databases/postgresql74-server/files/regresspatch-src-test-regress-pgregress-sh
@@ -0,0 +1,12 @@
+--- src/test/regress/pg_regress.sh.orig	Sun Nov  2 22:56:15 2003
++++ src/test/regress/pg_regress.sh	Sat Jan  8 05:28:00 2005
+@@ -382,6 +382,9 @@
+         (exit 2); exit
+     fi
+ 
++    # make rest of this script happy
++    echo "syslog = 0"          >> $PGDATA/postgresql.conf
++    echo "silent_mode = false" >> $PGDATA/postgresql.conf
+ 
+     # ----------
+     # Start postmaster