diff options
Diffstat (limited to 'databases/postgresql80-server')
| -rw-r--r-- | databases/postgresql80-server/Makefile | 6 | ||||
| -rw-r--r-- | databases/postgresql80-server/distinfo | 12 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/502.pgsql | 39 | ||||
| -rw-r--r-- | databases/postgresql80-server/pkg-plist-server | 8 |
4 files changed, 43 insertions, 22 deletions
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile index 1701bf5ceb23..43eca524aad5 100644 --- a/databases/postgresql80-server/Makefile +++ b/databases/postgresql80-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -PORTVERSION?= 8.0.21 -PORTREVISION?= 1 +PORTVERSION?= 8.0.25 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${PORTVERSION} @@ -41,6 +40,7 @@ CONFIGURE_ARGS+=--with-libraries=${LOCALBASE}/lib \ --with-includes=${LOCALBASE}/include \ --enable-thread-safety \ --with-docdir=${DOCSDIR} +LDFLAGS+= -L${PREFIX}/lib CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" \ PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \ PTHREAD_LIBS="${PTHREAD_LIBS}" @@ -106,7 +106,7 @@ USE_AUTOTOOLS= autoconf:262 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-8019-icu-xx-2008-11-03.diff.gz:icu +PATCHFILES+= pg-8025-icu-xx-2010-05-14.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo index 086027731600..c5354fefdb6b 100644 --- a/databases/postgresql80-server/distinfo +++ b/databases/postgresql80-server/distinfo @@ -1,9 +1,9 @@ -MD5 (postgresql/postgresql-8.0.21.tar.bz2) = 7c9b5aa67f79e19da7a663a66db22765 -SHA256 (postgresql/postgresql-8.0.21.tar.bz2) = 52ac543f5d8412755ce2c6efa1728015cdd37aa7cdcbc368e570270effbdf17f -SIZE (postgresql/postgresql-8.0.21.tar.bz2) = 11239602 +MD5 (postgresql/postgresql-8.0.25.tar.bz2) = 91b6f5c27d881e2fef8e9dd7aae1bbe7 +SHA256 (postgresql/postgresql-8.0.25.tar.bz2) = e22b3328c76919045702887c70458a9fe7acb3ab10d735f7f272e93184a82308 +SIZE (postgresql/postgresql-8.0.25.tar.bz2) = 11333463 MD5 (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = 9fa75cd7b3f1cb913d2e6d310582a4bc SHA256 (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = f3a1849f2d527759ef721502cb445a435e072cc9be820c2e489c9e4a71c7adbe SIZE (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = 30555 -MD5 (postgresql/pg-8019-icu-xx-2008-11-03.diff.gz) = 76fa7d029bcdbb4705e48d394f87bd06 -SHA256 (postgresql/pg-8019-icu-xx-2008-11-03.diff.gz) = 089bd1f35c1ca6ac60565726d8d40914fe16a5ddb77c2a0ca9b80f64e064f936 -SIZE (postgresql/pg-8019-icu-xx-2008-11-03.diff.gz) = 4597 +MD5 (postgresql/pg-8025-icu-xx-2010-05-14.diff.gz) = 3327511072c2dfc12e1b0e95551b6784 +SHA256 (postgresql/pg-8025-icu-xx-2010-05-14.diff.gz) = 0c53c120eaa4063b39bcf4423e144c63b48a9f2dbe2c9c4efed238e6a5efaf55 +SIZE (postgresql/pg-8025-icu-xx-2010-05-14.diff.gz) = 4621 diff --git a/databases/postgresql80-server/files/502.pgsql b/databases/postgresql80-server/files/502.pgsql index acc1afe431cf..281189a59c46 100644 --- a/databases/postgresql80-server/files/502.pgsql +++ b/databases/postgresql80-server/files/502.pgsql @@ -15,12 +15,10 @@ # 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_backup_enable="YES" # do backup of all databases +# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # 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: @@ -40,32 +38,32 @@ eval backupdir=${daily_pgsql_backupdir} rc=0 -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - +pgsql_backup() { # 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} + mkdir -m 700 ${backupdir}; chown pgsql ${backupdir} fi echo - echo "PostgreSQL maintenance" + echo "PostgreSQL backups" # Protect the data umask 077 - dbnames=`su -l pgsql -c "umask 077; 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 "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz" - for db in ${dbnames}; do + + db=$1 + while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 + db=$1 done if [ $rc -gt 0 ]; then @@ -76,6 +74,23 @@ case "$daily_pgsql_backup_enable" in # cleaning up old data find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \ -a -mtime +${daily_pgsql_savedays} -delete + echo +} + +case "$daily_pgsql_backup_enable" in + [Yy][Ee][Ss]) + dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + pgsql_backup $dbnames + ;; + + [Nn][Oo]) + ;; + + "") + ;; + + *) + pgsql_backup $daily_pgsql_backup_enable ;; esac @@ -83,7 +98,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 diff --git a/databases/postgresql80-server/pkg-plist-server b/databases/postgresql80-server/pkg-plist-server index a1671d2e0ad4..e9ad7a60f371 100644 --- a/databases/postgresql80-server/pkg-plist-server +++ b/databases/postgresql80-server/pkg-plist-server @@ -207,6 +207,7 @@ share/postgresql/timezone/America/Asuncion share/postgresql/timezone/America/Atikokan share/postgresql/timezone/America/Atka share/postgresql/timezone/America/Bahia +share/postgresql/timezone/America/Bahia_Banderas share/postgresql/timezone/America/Barbados share/postgresql/timezone/America/Belem share/postgresql/timezone/America/Belize @@ -279,6 +280,7 @@ share/postgresql/timezone/America/Managua share/postgresql/timezone/America/Manaus share/postgresql/timezone/America/Marigot share/postgresql/timezone/America/Martinique +share/postgresql/timezone/America/Matamoros share/postgresql/timezone/America/Mazatlan share/postgresql/timezone/America/Mendoza share/postgresql/timezone/America/Menominee @@ -297,6 +299,7 @@ share/postgresql/timezone/America/Nome share/postgresql/timezone/America/Noronha share/postgresql/timezone/America/North_Dakota/Center share/postgresql/timezone/America/North_Dakota/New_Salem +share/postgresql/timezone/America/Ojinaga share/postgresql/timezone/America/Panama share/postgresql/timezone/America/Pangnirtung share/postgresql/timezone/America/Paramaribo @@ -309,10 +312,11 @@ share/postgresql/timezone/America/Puerto_Rico share/postgresql/timezone/America/Rainy_River share/postgresql/timezone/America/Rankin_Inlet share/postgresql/timezone/America/Recife -share/postgresql/timezone/America/Resolute share/postgresql/timezone/America/Regina +share/postgresql/timezone/America/Resolute share/postgresql/timezone/America/Rio_Branco share/postgresql/timezone/America/Rosario +share/postgresql/timezone/America/Santa_Isabel share/postgresql/timezone/America/Santarem share/postgresql/timezone/America/Santiago share/postgresql/timezone/America/Santo_Domingo @@ -341,6 +345,7 @@ share/postgresql/timezone/America/Yellowknife share/postgresql/timezone/Antarctica/Casey share/postgresql/timezone/Antarctica/Davis share/postgresql/timezone/Antarctica/DumontDUrville +share/postgresql/timezone/Antarctica/Macquarie share/postgresql/timezone/Antarctica/Mawson share/postgresql/timezone/Antarctica/McMurdo share/postgresql/timezone/Antarctica/Palmer @@ -403,6 +408,7 @@ share/postgresql/timezone/Asia/Makassar share/postgresql/timezone/Asia/Manila share/postgresql/timezone/Asia/Muscat share/postgresql/timezone/Asia/Nicosia +share/postgresql/timezone/Asia/Novokuznetsk share/postgresql/timezone/Asia/Novosibirsk share/postgresql/timezone/Asia/Omsk share/postgresql/timezone/Asia/Oral |