summaryrefslogtreecommitdiff
path: root/databases/postgresql73-server/files/502.pgsql
diff options
context:
space:
mode:
authorRene Ladan <rene@FreeBSD.org>2011-04-04 17:12:43 +0000
committerRene Ladan <rene@FreeBSD.org>2011-04-04 17:12:43 +0000
commit5fafbc0f8b2cf3310a865e0a77c610e2aa6e6df5 (patch)
treed3b7f8651f628a519a2e7011af6bbf8c7a7d1433 /databases/postgresql73-server/files/502.pgsql
parentUpdate to 2.1.1. (diff)
Garbage collect expired ports
2011-04-01 accessibility/linux-f8-atk: End of Life since Jan 7, 2009 2011-04-01 archivers/linux-f8-ucl: End of Life since Jan 7, 2009 2011-04-01 archivers/linux-f8-upx: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-alsa-lib: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-arts: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-esound: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-freealut: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-libaudiofile: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-libogg: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-libvorbis: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-mikmod: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-nas-libs: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-openal: End of Life since Jan 7, 2009 2011-04-01 audio/linux-f8-sdl_mixer: End of Life since Jan 7, 2009 2011-04-01 databases/linux-f8-sqlite3: End of Life since Jan 7, 2009 2011-04-02 databases/postgresql81-server: EOL see http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy 2011-04-02 databases/postgresql73-server: EOL see http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy 2011-04-02 databases/postgresql74-server: EOL see http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy 2011-04-02 databases/postgresql80-server: EOL see http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy 2011-04-01 devel/linux-f8-libglade: End of Life since Jan 7, 2009 2011-04-01 devel/linux-f8-sdl12: End of Life since Jan 7, 2009 2011-04-01 devel/linux-f8-allegro: End of Life since Jan 7, 2009 2011-04-01 devel/linux-f8-libsigc++20: End of Life since Jan 7, 2009 2011-04-01 devel/linux-f8-libglade2: End of Life since Jan 7, 2009 2011-04-01 devel/linux-f8-nspr: End of Life since Jan 7, 2009 2011-04-01 dns/linux-f8-libidn: End of Life since Jan 7, 2009 2011-04-01 emulators/linux_base-f8: End of Life since Jan 7, 2009 2011-04-01 emulators/linux_base-f9: End of Life since Jul 10, 2009 2011-04-01 emulators/linux_base-fc6: End of Life since December 7, 2007 2011-04-01 emulators/linux_base-f7: End of Life since June 13, 2008 2011-04-01 ftp/linux-f8-curl: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-sdl_image: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-ungif: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-imlib: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-cairo: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-dri: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-gdk-pixbuf: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-jpeg: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-png: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-libGLU: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-libmng: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-png10: End of Life since Jan 7, 2009 2011-04-01 graphics/linux-f8-tiff: End of Life since Jan 7, 2009 2011-04-01 lang/linux-f8-libg2c: End of Life since Jan 7, 2009 2011-04-01 lang/linux-f8-tcl84: End of Life since Jan 7, 2009 2011-04-01 multimedia/linux-f8-libtheora: End of Life since Jan 7, 2009 2011-04-02 net-p2p/dcd: No fetch sources and looks like project abandoned 2011-03-31 net/straw: abandoned upstream and does not work with python 2.6+ 2011-04-01 security/linux-f8-libssh2: End of Life since Jan 7, 2009 2011-04-01 security/linux-f8-nss: End of Life since Jan 7, 2009 2011-04-01 security/linux-f8-openssl: End of Life since Jan 7, 2009 2011-04-01 textproc/linux-f8-libxml2: End of Life since Jan 7, 2009 2011-04-01 textproc/linux-f8-scim-gtk: End of Life since Jan 7, 2009 2011-04-01 textproc/linux-f8-scim-libs: End of Life since Jan 7, 2009 2011-04-01 textproc/linux-f8-expat: End of Life since Jan 7, 2009 2011-04-01 textproc/linux-f8-libxml: End of Life since Jan 7, 2009 2011-04-01 textproc/linux-f8-aspell: End of Life since Jan 7, 2009 2011-04-01 www/linux-f8-flashplugin10: End of Life since Jan 7, 2009 2011-03-30 www/mediawiki112: abandoned upstream 2011-03-30 www/mediawiki113: abandoned upstream 2011-03-30 www/mediawiki114: abandoned upstream 2011-03-30 www/mediawiki16: abandoned upstream 2011-04-01 x11-fonts/linux-f8-fontconfig: End of Life since Jan 7, 2009 2011-03-01 x11-themes/gnome-icons-cool-gorilla: "no mastersite" 2011-04-01 x11-themes/linux-f8-hicolor-icon-theme: End of Life since Jan 7, 2009 2011-04-01 x11-toolkits/linux-f8-gtk: End of Life since Jan 7, 2009 2011-04-01 x11-toolkits/linux-f8-gtk2: End of Life since Jan 7, 2009 2011-04-01 x11-toolkits/linux-f8-openmotif: End of Life since Jan 7, 2009 2011-04-01 x11-toolkits/linux-f8-pango: End of Life since Jan 7, 2009 2011-04-01 x11-toolkits/linux-f8-qt33: End of Life since Jan 7, 2009 2011-04-01 x11-toolkits/linux-f8-tk84: End of Life since Jan 7, 2009 2011-04-01 x11/linux-f8-xorg-libs: End of Life since Jan 7, 2009
Notes
Notes: svn path=/head/; revision=272207
Diffstat (limited to 'databases/postgresql73-server/files/502.pgsql')
-rw-r--r--databases/postgresql73-server/files/502.pgsql97
1 files changed, 0 insertions, 97 deletions
diff --git a/databases/postgresql73-server/files/502.pgsql b/databases/postgresql73-server/files/502.pgsql
deleted file mode 100644
index 09591559c317..000000000000
--- a/databases/postgresql73-server/files/502.pgsql
+++ /dev/null
@@ -1,97 +0,0 @@
-#!/bin/sh
-#
-# $FreeBSD$
-#
-# Maintenance shell script to vacuum and backup database
-# Put this in /usr/local/etc/periodic/daily, and it will be run
-# every night
-#
-# Written by Palle Girgensohn <girgen@pingpong.net>
-#
-# In public domain, do what you like with it,
-# and use it at your own risk... :)
-#
-
-# Define these variables in either /etc/periodic.conf or
-# /etc/periodic.conf.local to override the default values.
-#
-# 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:
-daily_pgsql_backupdir="~pgsql/backups"
-daily_pgsql_savedays="7"
-
-# If there is a global system configuration file, suck it in.
-#
-if [ -r /etc/defaults/periodic.conf ]
-then
- . /etc/defaults/periodic.conf
- source_periodic_confs
-fi
-
-# allow '~´ in dir name
-eval backupdir=${daily_pgsql_backupdir}
-
-rc=0
-
-case "$daily_pgsql_backup_enable" in
- [Yy][Ee][Ss])
-
- # daily_pgsql_backupdir must be writeable by user pgsql
- # ~pgsql is just that under normal circumstances,
- # 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}
- fi
-
- echo
- echo "PostgreSQL maintenance"
-
- # Protect the data
- umask 077
- dbnames=`su -l pgsql -c "psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"`
- rc=$?
- now=`date "+%Y-%m-%dT%H:%M:%S"`
- file=${daily_pgsql_backupdir}/pgglobals_${now}
- su -l pgsql -c "pg_dumpall -g | gzip -9 > ${file}.gz"
- for db in ${dbnames}; do
- echo -n " $db"
- file=${backupdir}/pgdump_${db}_${now}
- su -l pgsql -c "pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
- [ $? -gt 0 ] && rc=3
- done
-
- if [ $rc -gt 0 ]; then
- echo
- echo "Errors were reported during backup."
- fi
-
- # cleaning up old data
- find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \
- -a -mtime +${daily_pgsql_savedays} -delete
- ;;
-esac
-
-case "$daily_pgsql_vacuum_enable" in
- [Yy][Ee][Ss])
-
- echo
- echo "vacuuming..."
- su -l pgsql -c "vacuumdb -a -q ${daily_pgsql_vacuum_args}"
- if [ $? -gt 0 ]
- then
- echo
- echo "Errors were reported during vacuum."
- rc=3
- fi
- ;;
-esac
-
-exit $rc