aboutsummaryrefslogtreecommitdiffstats
path: root/databases/postgresql90-server/files
diff options
context:
space:
mode:
authortrevor <trevor@FreeBSD.org>2002-08-26 16:12:40 +0800
committertrevor <trevor@FreeBSD.org>2002-08-26 16:12:40 +0800
commitd60e3a3beb783a982d1dba768ff264e59116495c (patch)
tree5134e80cc8e950436533adc050dd2be82a4fa8d4 /databases/postgresql90-server/files
parent3489c62e7d4488c2d0bf0f8c53d703e78f1cc2e4 (diff)
downloadfreebsd-ports-graphics-d60e3a3beb783a982d1dba768ff264e59116495c.tar.gz
freebsd-ports-graphics-d60e3a3beb783a982d1dba768ff264e59116495c.tar.zst
freebsd-ports-graphics-d60e3a3beb783a982d1dba768ff264e59116495c.zip
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/postgresql90-server/files')
-rw-r--r--databases/postgresql90-server/files/502.pgsql41
-rw-r--r--databases/postgresql90-server/files/post-install-notes3
2 files changed, 20 insertions, 24 deletions
diff --git a/databases/postgresql90-server/files/502.pgsql b/databases/postgresql90-server/files/502.pgsql
index 32d473826f4..3a44f1132ac 100644
--- a/databases/postgresql90-server/files/502.pgsql
+++ b/databases/postgresql90-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/postgresql90-server/files/post-install-notes b/databases/postgresql90-server/files/post-install-notes
index 55816362579..cdf34300207 100644
--- a/databases/postgresql90-server/files/post-install-notes
+++ b/databases/postgresql90-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.