summaryrefslogtreecommitdiff
path: root/databases/postgresql91-server/files
diff options
context:
space:
mode:
authorTrevor Johnson <trevor@FreeBSD.org>2002-08-26 08:12:40 +0000
committerTrevor Johnson <trevor@FreeBSD.org>2002-08-26 08:12:40 +0000
commitc80f4eaad8cb1ddb2c90382e4c818d06c3591d53 (patch)
treef2cc466ecfe3a529b10ff5a932b22809e59e65f9 /databases/postgresql91-server/files
parentRevert part of last commit. It looks like some docs were wrong. (diff)
Update to 7.2.2, which fixes several security bugs. Do not install
documentation--it will be in a separate port. PR: 42009 Submitted by: Palle Girgensohn (maintainer)
Diffstat (limited to 'databases/postgresql91-server/files')
-rw-r--r--databases/postgresql91-server/files/502.pgsql41
-rw-r--r--databases/postgresql91-server/files/post-install-notes3
2 files changed, 20 insertions, 24 deletions
diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql
index 32d473826f40..3a44f1132ac8 100644
--- a/databases/postgresql91-server/files/502.pgsql
+++ b/databases/postgresql91-server/files/502.pgsql
@@ -1,6 +1,6 @@
#!/bin/sh
#
-# $Id: 502.pgsql.in,v 1.17 2001/10/29 10:12:32 henrik Exp $
+# $FreeBSD$
#
# Maintenance shell script to vacuum and backup database
# Put this in /usr/local/etc/periodic/daily, and it will be run
@@ -11,20 +11,13 @@
# In public domain, do what you like with it,
# and use it at your own risk... :)
#
-############################
-
-# arguments to pg_dump
-PGDUMP_ARGS="-b -F c"
-
-# the directory where the backups will reside
-# ${HOME} is pgsql's home directory
-PGBACKUPDIR=${HOME}/backups
-
-# some data is amazingly more compressed with bzip2, esp. blobs, it seems
-# if your're short on diskspace, give it a try and set USEBZIP=yes
-USEBZIP=no
-
-############################
+######################################################################
+#
+# If you like to tweak the settings of the variables PGBACKUPDIR and
+# PGDUMP_ARGS, you should preferably set them in ~pgsql/.profile.
+# If set there, that setting will override the defaults here.
+#
+######################################################################
DIR=`dirname $0`
progname=`basename $0`
@@ -36,11 +29,13 @@ if [ `id -un` != pgsql ]; then
exit $?
fi
-if [ X${USEBZIP} = Xyes ]; then
- BZIP=`which bzip2 || echo true`
-else
- BZIP=true
-fi
+# arguments to pg_dump
+PGDUMP_ARGS=${PGDUMP_ARGS:-"-b -F c"}
+
+# The directory where the backups will reside.
+# ${HOME} is pgsql's home directory
+#
+PGBACKUPDIR=${PGBACKUPDIR:-${HOME}/backups}
# PGBACKUPDIR must be writeable by user pgsql
# ~pgsql is just that under normal circumstances,
@@ -63,7 +58,6 @@ for db in ${dbnames}; do
file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
[ $? -gt 0 ] && rc=3
- ${BZIP} ${file}
done
if [ $rc -gt 0 ]; then
@@ -77,12 +71,11 @@ vacuumdb -a -z -q
if [ $? -gt 0 ]
then
echo
- echo "Errors were reported vacuum."
+ echo "Errors were reported during vacuum."
rc=3
fi
# cleaning up old data
-find ${PGBACKUPDIR} \( -name 'pgdump_*'.${GZIPEXT} -o -name 'pgdumpall_*'.${GZIPEXT} \) \
- -a -atime +7 -delete
+find ${PGBACKUPDIR} -name 'pgdump_*' -a -atime +7 -delete
exit $rc
diff --git a/databases/postgresql91-server/files/post-install-notes b/databases/postgresql91-server/files/post-install-notes
index 55816362579b..cdf343002074 100644
--- a/databases/postgresql91-server/files/post-install-notes
+++ b/databases/postgresql91-server/files/post-install-notes
@@ -1,5 +1,8 @@
The PostgreSQL port has a collection of "side orders":
+postgresql-doc
+ For all of the html documentation
+
p5-Pg
A perl5 API for client access to PostgreSQL databases.