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)

3 files changed, 24 insertions, 1 deletions

diff --git a/databases/postgresql74-server/files/502.pgsql b/databases/postgresql74-server/files/502.pgsql
index a1cf9ba4f2ee..09591559c317 100644
--- a/databases/postgresql74-server/files/502.pgsql
+++ b/databases/postgresql74-server/files/502.pgsql
@@ -18,7 +18,7 @@
 # daily_pgsql_backup_enable="YES" # do backup
 # daily_pgsql_vacuum_enable="YES" # do vacuum
 
-daily_pgsql_vaccum_enable="NO"
+daily_pgsql_vacuum_enable="YES"
 daily_pgsql_backup_enable="NO"
 
 daily_pgsql_vacuum_args="-z"
diff --git a/databases/postgresql74-server/files/patch-plpython-Makefile b/databases/postgresql74-server/files/patch-plpython-Makefile
new file mode 100644
index 000000000000..a1303151170a
--- /dev/null
+++ b/databases/postgresql74-server/files/patch-plpython-Makefile
@@ -0,0 +1,11 @@
+--- src/pl/plpython/Makefile~	Thu Mar  4 08:06:19 2004
++++ src/pl/plpython/Makefile	Thu Mar  4 08:06:44 2004
+@@ -8,7 +8,7 @@
+ # On some platforms we can only build PL/Python if libpython is a
+ # shared library.  Since there is no official way to determine this,
+ # we see if there is a file that is named like a shared library.
+-ifneq (,$(wildcard $(python_configdir)/libpython*$(DLSUFFIX)*))
++ifneq (,$(wildcard $(python_configdir)/../../libpython*$(DLSUFFIX)*))
+ shared_libpython = yes
+ endif
+ 
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