summaryrefslogtreecommitdiff
path: root/databases/postgresql92-server/files/502.pgsql
diff options
context:
space:
mode:
authorPalle Girgensohn <girgen@FreeBSD.org>2008-11-07 09:49:49 +0000
committerPalle Girgensohn <girgen@FreeBSD.org>2008-11-07 09:49:49 +0000
commit978e3de48fd8491061803765cdc592ab234edd46 (patch)
tree2f23f5da1426d6e37dcb3efb378e85bd08787403 /databases/postgresql92-server/files/502.pgsql
parent- Fix build by not using ncurses-config since there is no need, and we do not (diff)
Update PostgreSQL to latest versions.
http://www.postgresql.org/docs/current/static/release-8-3-5.html http://www.postgresql.org/docs/current/static/release-8-2-11.html http://www.postgresql.org/docs/current/static/release-8-1-15.html http://www.postgresql.org/docs/current/static/release-8-0-19.html http://www.postgresql.org/docs/current/static/release-7-4-23.html Note that the GiST problem mentioned does not apply to users of the FreeBSD port, since the previous version of PostgreSQL never reached the ports tree, due to the freeze of the tree pending the FreeBSD 7.1 update. PR: 121848, 124713
Notes
Notes: svn path=/head/; revision=222485
Diffstat (limited to 'databases/postgresql92-server/files/502.pgsql')
-rw-r--r--databases/postgresql92-server/files/502.pgsql9
1 files changed, 3 insertions, 6 deletions
diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql
index acc1afe431cf..d2235e414cd2 100644
--- a/databases/postgresql92-server/files/502.pgsql
+++ b/databases/postgresql92-server/files/502.pgsql
@@ -18,9 +18,6 @@
# daily_pgsql_backup_enable="YES" # do backup
# daily_pgsql_vacuum_enable="YES" # do vacuum
-daily_pgsql_vacuum_enable="YES"
-daily_pgsql_backup_enable="NO"
-
daily_pgsql_vacuum_args="-z"
daily_pgsql_pgdump_args="-b -F c"
# backupdir is relative to ~pgsql home directory unless it begins with a slash:
@@ -48,11 +45,11 @@ case "$daily_pgsql_backup_enable" in
# but this might not be where you want the backups...
if [ ! -d ${backupdir} ] ; then
echo Creating ${backupdir}
- mkdir ${backupdir}; chmod 700 ${backupdir}; chown pgsql ${backupdir}
+ mkdir -m 700 ${backupdir}; chown pgsql ${backupdir}
fi
echo
- echo "PostgreSQL maintenance"
+ echo "PostgreSQL backups"
# Protect the data
umask 077
@@ -83,7 +80,7 @@ case "$daily_pgsql_vacuum_enable" in
[Yy][Ee][Ss])
echo
- echo "vacuuming..."
+ echo "PostgreSQL vacuum"
su -l pgsql -c "vacuumdb -a -q ${daily_pgsql_vacuum_args}"
if [ $? -gt 0 ]
then