diff options
| author | girgen <girgen@FreeBSD.org> | 2008-06-13 07:46:07 +0800 |
|---|---|---|
| committer | girgen <girgen@FreeBSD.org> | 2008-06-13 07:46:07 +0800 |
| commit | a89527892d54ce6acaec92166a6ce2776ca332f7 (patch) | |
| tree | dc8e55c66068b6ac24c91e7134b3a7c050b8e76b /databases | |
| parent | 67a4d0df118210b83ac2cdfa50787d949da067b9 (diff) | |
| download | freebsd-ports-gnome-a89527892d54ce6acaec92166a6ce2776ca332f7.tar.gz freebsd-ports-gnome-a89527892d54ce6acaec92166a6ce2776ca332f7.tar.zst freebsd-ports-gnome-a89527892d54ce6acaec92166a6ce2776ca332f7.zip | |
Updates of the PostgreSQL ports
Updates for all maintained versions of PostgreSQL are available today:
8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than
two dozen minor issues reported and patched over the last few months.
All PostgreSQL users should plan to update at their earliest
convenience. People in affected time zones, in particular, should
upgrade as soon as possible.
Release Notes:
http://www.postgresql.org/docs/8.3/static/release.html
Also, fix umask error in periodic script [1].
PR: ports/124457 [1]
Submitted by: Alexandre Perrin
Diffstat (limited to 'databases')
40 files changed, 121 insertions, 123 deletions
diff --git a/databases/postgresql74-client/Makefile b/databases/postgresql74-client/Makefile index 7199c9eddffd..68df6a033ca3 100644 --- a/databases/postgresql74-client/Makefile +++ b/databases/postgresql74-client/Makefile @@ -9,7 +9,6 @@ PORTNAME= postgresql PKGNAMESUFFIX= -client -PORTREVISION= 1 COMMENT= PostgreSQL database (client) diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile index 7320ef9d0917..687a458a760e 100644 --- a/databases/postgresql74-server/Makefile +++ b/databases/postgresql74-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -PORTVERSION?= 7.4.19 -PORTREVISION?= 1 +PORTVERSION?= 7.4.21 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${PORTVERSION} @@ -81,7 +80,7 @@ OPTIONS+= PAM "Build with PAM support (server only)" off OPTIONS+= MIT_KRB5 "Build with MIT's kerberos support" off OPTIONS+= HEIMDAL_KRB5 "Builds with Heimdal kerberos support" off OPTIONS+= OPTIMIZED_CFLAGS "Builds with compiler optimizations (-O3)" off -OPTIONS+= LIBC_R "Link w/ libc_r, used by plpython (server)" off +OPTIONS+= PTHREAD "Link w/ libc_r, used by plpython (server)" off # to run regression tests: OPTIONS+= TESTS "Allows the use of a \"check\" target (server)" off OPTIONS+= DEBUG "Builds with debugging symbols" off diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo index cb04e036ee6e..32c907f98cb7 100644 --- a/databases/postgresql74-server/distinfo +++ b/databases/postgresql74-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-7.4.19.tar.bz2) = 0be8c193fb73113930d043c60200598b -SHA256 (postgresql/postgresql-7.4.19.tar.bz2) = 447ac7070aa0a547f17a307e842734fc27e2716cb4a251fa9a810b178d44c389 -SIZE (postgresql/postgresql-7.4.19.tar.bz2) = 10307396 +MD5 (postgresql/postgresql-7.4.21.tar.bz2) = b372d271bb30f703c241c7cc3d58f198 +SHA256 (postgresql/postgresql-7.4.21.tar.bz2) = 2c62d112a7addd4333d14101e508d2222a639e1698b8e4958ce1b05138f76932 +SIZE (postgresql/postgresql-7.4.21.tar.bz2) = 10282778 MD5 (postgresql/hier-Pg7.4-0.5.3.tar.gz) = 16d037213b879963724da7809a0a1589 SHA256 (postgresql/hier-Pg7.4-0.5.3.tar.gz) = 1e56f76560c86227b08faabf78e3a53de4188c6a8f9d1f38b1481427e8fdf74c SIZE (postgresql/hier-Pg7.4-0.5.3.tar.gz) = 34662 diff --git a/databases/postgresql74-server/files/502.pgsql b/databases/postgresql74-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql74-server/files/502.pgsql +++ b/databases/postgresql74-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql80-client/Makefile b/databases/postgresql80-client/Makefile index d439925647f7..78c0721ddf9e 100644 --- a/databases/postgresql80-client/Makefile +++ b/databases/postgresql80-client/Makefile @@ -9,7 +9,6 @@ PORTNAME= postgresql PKGNAMESUFFIX= -client -PORTREVISION= 1 COMMENT= PostgreSQL database (client) diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile index 7b6a476e8b42..566879821e50 100644 --- a/databases/postgresql80-server/Makefile +++ b/databases/postgresql80-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -PORTVERSION?= 8.0.15 -PORTREVISION?= 1 +PORTVERSION?= 8.0.17 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${PORTVERSION} @@ -39,11 +38,15 @@ GNU_CONFIGURE= YES CONFIGURE_ARGS+=--with-libraries=${LOCALBASE}/lib \ --with-includes=${LOCALBASE}/include \ + --enable-thread-safety \ --with-docdir=${DOCSDIR} CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" \ PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \ PTHREAD_LIBS="${PTHREAD_LIBS}" +CFLAGS+= ${PTHREAD_CFLAGS} +LDFLAGS+= ${PTHREAD_LIBS} + PLIST= ${PKGDIR}/pkg-plist${PKGNAMESUFFIX} BUILD_DIRS?= src/port src/timezone src/backend src/backend/utils/mb/conversion_procs \ @@ -80,8 +83,6 @@ OPTIONS+= PAM "Build with PAM support (server only)" off OPTIONS+= MIT_KRB5 "Build with MIT's kerberos support" off OPTIONS+= HEIMDAL_KRB5 "Builds with Heimdal kerberos support" off OPTIONS+= OPTIMIZED_CFLAGS "Builds with compiler optimizations (-O3)" off -OPTIONS+= LIBC_R "Link w/ libc_r, used by plpython (server)" off -OPTIONS+= THREADSAFE "make libpq thread safe" off # to run regression tests: OPTIONS+= TESTS "Allows the use of a \"check\" target (server)" off OPTIONS+= DEBUG "Builds with debugging symbols" off @@ -107,7 +108,7 @@ USE_AUTOTOOLS= autoconf:261 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-8015-icu-xx-2008-01-08.diff.gz:icu +PATCHFILES+= pg-8015-icu-xx-2008-06-11.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -170,14 +171,6 @@ CONFIGURE_ARGS+=--with-krb5 EXTRA_PATCHES= ${FILESDIR}/regresspatch-src-test-regress-pgregress-sh . endif -. if defined(WITH_THREADSAFE) -CONFIGURE_ARGS+=--enable-thread-safety -. endif - -. if defined(SERVER_ONLY) && defined(WITH_LIBC_R) -CFLAGS+= ${PTHREAD_CFLAGS} -LDFLAGS+= ${PTHREAD_LIBS} -. endif .endif # !SLAVE_ONLY .if defined(CLIENT_ONLY) diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo index bb3e8cfa4618..6da35419f1d5 100644 --- a/databases/postgresql80-server/distinfo +++ b/databases/postgresql80-server/distinfo @@ -1,9 +1,9 @@ -MD5 (postgresql/postgresql-8.0.15.tar.bz2) = 3ee548b3643e0a0a4b76493e81b336f3 -SHA256 (postgresql/postgresql-8.0.15.tar.bz2) = 59408a00db1c73e638a11af10438a827507b7a72b53916d58f2d44c477718714 -SIZE (postgresql/postgresql-8.0.15.tar.bz2) = 11253897 +MD5 (postgresql/postgresql-8.0.17.tar.bz2) = 0154b01820cb73aeca73b9d060cb3328 +SHA256 (postgresql/postgresql-8.0.17.tar.bz2) = e425602f60c034ecfd6ffe9b403d863cd99ff6fbc0891a8d59da33258a21a93b +SIZE (postgresql/postgresql-8.0.17.tar.bz2) = 11234855 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-8015-icu-xx-2008-01-08.diff.gz) = 8f01943557fdaff5c4d472a458d4bef8 -SHA256 (postgresql/pg-8015-icu-xx-2008-01-08.diff.gz) = 3540ffdeae085d764668894839e8c15750275fc7bd2765975e31fda8bcfa0d2a -SIZE (postgresql/pg-8015-icu-xx-2008-01-08.diff.gz) = 4553 +MD5 (postgresql/pg-8015-icu-xx-2008-06-11.diff.gz) = a83fd50d3373e300b02e05f4e30fb547 +SHA256 (postgresql/pg-8015-icu-xx-2008-06-11.diff.gz) = 50b5a9884500ab05dea373e5e9971575a405056d814a32cb20e24dc0fee8f22a +SIZE (postgresql/pg-8015-icu-xx-2008-06-11.diff.gz) = 4596 diff --git a/databases/postgresql80-server/files/502.pgsql b/databases/postgresql80-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql80-server/files/502.pgsql +++ b/databases/postgresql80-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql80-server/pkg-plist-server b/databases/postgresql80-server/pkg-plist-server index 66fecfdacc95..eea08812b057 100644 --- a/databases/postgresql80-server/pkg-plist-server +++ b/databases/postgresql80-server/pkg-plist-server @@ -198,6 +198,7 @@ share/postgresql/timezone/America/Argentina/La_Rioja share/postgresql/timezone/America/Argentina/Mendoza share/postgresql/timezone/America/Argentina/Rio_Gallegos share/postgresql/timezone/America/Argentina/San_Juan +share/postgresql/timezone/America/Argentina/San_Luis share/postgresql/timezone/America/Argentina/Tucuman share/postgresql/timezone/America/Argentina/Ushuaia share/postgresql/timezone/America/Aruba @@ -374,6 +375,7 @@ share/postgresql/timezone/Asia/Dubai share/postgresql/timezone/Asia/Dushanbe share/postgresql/timezone/Asia/Gaza share/postgresql/timezone/Asia/Harbin +share/postgresql/timezone/Asia/Ho_Chi_Minh share/postgresql/timezone/Asia/Hong_Kong share/postgresql/timezone/Asia/Hovd share/postgresql/timezone/Asia/Irkutsk @@ -386,6 +388,7 @@ share/postgresql/timezone/Asia/Kamchatka share/postgresql/timezone/Asia/Karachi share/postgresql/timezone/Asia/Kashgar share/postgresql/timezone/Asia/Katmandu +share/postgresql/timezone/Asia/Kolkata share/postgresql/timezone/Asia/Krasnoyarsk share/postgresql/timezone/Asia/Kuala_Lumpur share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql81-client/Makefile b/databases/postgresql81-client/Makefile index 2199c27a198f..7c5fa9d9e3f9 100644 --- a/databases/postgresql81-client/Makefile +++ b/databases/postgresql81-client/Makefile @@ -9,7 +9,6 @@ PORTNAME= postgresql PKGNAMESUFFIX= -client -PORTREVISION= 1 COMMENT= PostgreSQL database (client) diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile index 56cf8433c02d..d494bc76d2c4 100644 --- a/databases/postgresql81-server/Makefile +++ b/databases/postgresql81-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -PORTVERSION?= 8.1.11 -PORTREVISION?= 1 +PORTVERSION?= 8.1.13 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${PORTVERSION} @@ -39,11 +38,15 @@ GNU_CONFIGURE= YES CONFIGURE_ARGS+=--with-libraries=${LOCALBASE}/lib \ --with-includes=${LOCALBASE}/include \ + --enable-thread-safety \ --with-docdir=${DOCSDIR} CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" \ PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \ PTHREAD_LIBS="${PTHREAD_LIBS}" +CFLAGS+= ${PTHREAD_CFLAGS} +LDFLAGS+= ${PTHREAD_LIBS} + PLIST= ${PKGDIR}/pkg-plist${PKGNAMESUFFIX} BUILD_DIRS?= src/port src/timezone src/backend src/backend/utils/mb/conversion_procs \ @@ -81,8 +84,6 @@ OPTIONS+= PAM "Build with PAM support (server only)" off OPTIONS+= MIT_KRB5 "Build with MIT's kerberos support" off OPTIONS+= HEIMDAL_KRB5 "Builds with Heimdal kerberos support" off OPTIONS+= OPTIMIZED_CFLAGS "Builds with compiler optimizations (-O3)" off -OPTIONS+= LIBC_R "Link w/ libc_r, used by plpython (server)" off -OPTIONS+= THREADSAFE "make libpq thread safe" off # to run regression tests: OPTIONS+= TESTS "Allows the use of a \"check\" target (server)" off OPTIONS+= DEBUG "Builds with debugging symbols" off @@ -168,17 +169,9 @@ CONFIGURE_ARGS+=--with-krb5 . endif . if (defined(SERVER_ONLY) && defined(WITH_TESTS)) || make(makesum) -EXTRA_PATCHES= ${FILESDIR}/regresspatch-src-test-regress-pgregress-sh -. endif - -. if defined(WITH_THREADSAFE) -CONFIGURE_ARGS+=--enable-thread-safety +EXTRA_PATCHES= ${FILESDIR}/regresspatch-src-test-regress-pgregress-sh . endif -. if defined(SERVER_ONLY) && defined(WITH_LIBC_R) -CFLAGS+= ${PTHREAD_CFLAGS} -LDFLAGS+= ${PTHREAD_LIBS} -. endif .endif # !SLAVE_ONLY .if ${ARCH} == sparc64 && ${OSVERSION} < 700000 diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo index 3ff1c032edd4..04182cef89f9 100644 --- a/databases/postgresql81-server/distinfo +++ b/databases/postgresql81-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.1.11.tar.bz2) = 48922512bcf683d5ea22a99df5eaaecd -SHA256 (postgresql/postgresql-8.1.11.tar.bz2) = 3e91cdfc1353fa9c6416d9fc8ae9d6ab3171565f00aeb6c882214c2f08a03e2e -SIZE (postgresql/postgresql-8.1.11.tar.bz2) = 11735420 +MD5 (postgresql/postgresql-8.1.13.tar.bz2) = fb88b45deeed02e8822fa0ed8e03aa13 +SHA256 (postgresql/postgresql-8.1.13.tar.bz2) = a537734da80f85c51ef72dd2d28bb2f64b73f63a727ef53a90211ccac2dcb1d1 +SIZE (postgresql/postgresql-8.1.13.tar.bz2) = 11744780 MD5 (postgresql/hier-Pg8.1.2-0.5.5.diff.gz) = 15916bf13b99702599ce70b6475f7d86 SHA256 (postgresql/hier-Pg8.1.2-0.5.5.diff.gz) = 14ecc3809ce69f47c3460efee3fc7fce78f68802936650fc4e1132adffd41d1e SIZE (postgresql/hier-Pg8.1.2-0.5.5.diff.gz) = 31203 diff --git a/databases/postgresql81-server/files/502.pgsql b/databases/postgresql81-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql81-server/files/502.pgsql +++ b/databases/postgresql81-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql81-server/pkg-plist-server b/databases/postgresql81-server/pkg-plist-server index 922331a91702..2ec7b15a59f1 100644 --- a/databases/postgresql81-server/pkg-plist-server +++ b/databases/postgresql81-server/pkg-plist-server @@ -199,6 +199,7 @@ share/postgresql/timezone/America/Argentina/La_Rioja share/postgresql/timezone/America/Argentina/Mendoza share/postgresql/timezone/America/Argentina/Rio_Gallegos share/postgresql/timezone/America/Argentina/San_Juan +share/postgresql/timezone/America/Argentina/San_Luis share/postgresql/timezone/America/Argentina/Tucuman share/postgresql/timezone/America/Argentina/Ushuaia share/postgresql/timezone/America/Aruba @@ -375,6 +376,7 @@ share/postgresql/timezone/Asia/Dubai share/postgresql/timezone/Asia/Dushanbe share/postgresql/timezone/Asia/Gaza share/postgresql/timezone/Asia/Harbin +share/postgresql/timezone/Asia/Ho_Chi_Minh share/postgresql/timezone/Asia/Hong_Kong share/postgresql/timezone/Asia/Hovd share/postgresql/timezone/Asia/Irkutsk @@ -387,6 +389,7 @@ share/postgresql/timezone/Asia/Kamchatka share/postgresql/timezone/Asia/Karachi share/postgresql/timezone/Asia/Kashgar share/postgresql/timezone/Asia/Katmandu +share/postgresql/timezone/Asia/Kolkata share/postgresql/timezone/Asia/Krasnoyarsk share/postgresql/timezone/Asia/Kuala_Lumpur share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql82-client/Makefile b/databases/postgresql82-client/Makefile index 17eb168fea08..c9ff84ec5a3d 100644 --- a/databases/postgresql82-client/Makefile +++ b/databases/postgresql82-client/Makefile @@ -9,7 +9,6 @@ PORTNAME= postgresql PKGNAMESUFFIX= -client -PORTREVISION= 1 COMMENT= PostgreSQL database (client) diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile index ce33a8c45229..9eeefdc64f6a 100644 --- a/databases/postgresql82-server/Makefile +++ b/databases/postgresql82-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -PORTVERSION?= 8.2.7 -PORTREVISION?= 1 +PORTVERSION?= 8.2.9 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${PORTVERSION} diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo index b6793c98896c..13cac2cd7f15 100644 --- a/databases/postgresql82-server/distinfo +++ b/databases/postgresql82-server/distinfo @@ -1,3 +1,3 @@ -MD5 (postgresql/postgresql-8.2.7.tar.bz2) = e8b21cbc20ec23a1d9490fdfbaa7c09e -SHA256 (postgresql/postgresql-8.2.7.tar.bz2) = 39528d1ba50f5abc51569e8b9bdeb47d0d4650d289a2c2e465621864b1ff3584 -SIZE (postgresql/postgresql-8.2.7.tar.bz2) = 12576126 +MD5 (postgresql/postgresql-8.2.9.tar.bz2) = 579506cf91881f6ede67e3be98a47c37 +SHA256 (postgresql/postgresql-8.2.9.tar.bz2) = 95ea81e0fa00184a63dae960007be95200343b24dec6cdea41bc809db29f22c2 +SIZE (postgresql/postgresql-8.2.9.tar.bz2) = 12558265 diff --git a/databases/postgresql82-server/files/502.pgsql b/databases/postgresql82-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql82-server/files/502.pgsql +++ b/databases/postgresql82-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql82-server/pkg-plist-server b/databases/postgresql82-server/pkg-plist-server index ddd85d4891e2..ad24d963eb03 100644 --- a/databases/postgresql82-server/pkg-plist-server +++ b/databases/postgresql82-server/pkg-plist-server @@ -196,6 +196,7 @@ share/postgresql/timezone/America/Argentina/La_Rioja share/postgresql/timezone/America/Argentina/Mendoza share/postgresql/timezone/America/Argentina/Rio_Gallegos share/postgresql/timezone/America/Argentina/San_Juan +share/postgresql/timezone/America/Argentina/San_Luis share/postgresql/timezone/America/Argentina/Tucuman share/postgresql/timezone/America/Argentina/Ushuaia share/postgresql/timezone/America/Aruba @@ -372,6 +373,7 @@ share/postgresql/timezone/Asia/Dubai share/postgresql/timezone/Asia/Dushanbe share/postgresql/timezone/Asia/Gaza share/postgresql/timezone/Asia/Harbin +share/postgresql/timezone/Asia/Ho_Chi_Minh share/postgresql/timezone/Asia/Hong_Kong share/postgresql/timezone/Asia/Hovd share/postgresql/timezone/Asia/Irkutsk @@ -384,6 +386,7 @@ share/postgresql/timezone/Asia/Kamchatka share/postgresql/timezone/Asia/Karachi share/postgresql/timezone/Asia/Kashgar share/postgresql/timezone/Asia/Katmandu +share/postgresql/timezone/Asia/Kolkata share/postgresql/timezone/Asia/Krasnoyarsk share/postgresql/timezone/Asia/Kuala_Lumpur share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql83-client/Makefile b/databases/postgresql83-client/Makefile index 020a7881d52b..81c722be9442 100644 --- a/databases/postgresql83-client/Makefile +++ b/databases/postgresql83-client/Makefile @@ -9,7 +9,6 @@ PORTNAME= postgresql PKGNAMESUFFIX= -client -PORTREVISION= 1 COMMENT= PostgreSQL database (client) diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile index db59ef137c10..c850200be6ca 100644 --- a/databases/postgresql83-server/Makefile +++ b/databases/postgresql83-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.3.1 -PORTREVISION?= 1 +DISTVERSION?= 8.3.3 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -108,7 +107,7 @@ USE_AUTOTOOLS= autoconf:261 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-831-icu-xx-2008-03-17.diff.gz:icu +PATCHFILES+= pg-833-icu-xx-2008-06-11.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo index 0fdaf766ad8f..55212382b188 100644 --- a/databases/postgresql83-server/distinfo +++ b/databases/postgresql83-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.3.1.tar.bz2) = a5e0ed6a85b450dc217ec71da93243a7 -SHA256 (postgresql/postgresql-8.3.1.tar.bz2) = 7ccf1e5c987920e4d6eb98b8589939e29d3a361d285055d5af35ddd8e1a2d992 -SIZE (postgresql/postgresql-8.3.1.tar.bz2) = 13995572 -MD5 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = bce2f2d862a19f92de9d297233f856b1 -SHA256 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 085ef29c1ccbb83a06e07c52c82f268e65bc96f194319ac128998da5c0a00b1e -SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5252 +MD5 (postgresql/postgresql-8.3.3.tar.bz2) = 0ae4bd9620e84d3e08dcf923808d14d0 +SHA256 (postgresql/postgresql-8.3.3.tar.bz2) = e9406b93794dc4fd15b21e10512d2b694236d79b018d29b9ca86311d5cca2437 +SIZE (postgresql/postgresql-8.3.3.tar.bz2) = 14004538 +MD5 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 58773458a9a8498106d167b731c9fe6c +SHA256 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 2495a0b788bcc026663b47895d13c5228e862c036e032145749f5f0d0e9d35ed +SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5302 diff --git a/databases/postgresql83-server/files/502.pgsql b/databases/postgresql83-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql83-server/files/502.pgsql +++ b/databases/postgresql83-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql83-server/pkg-plist-server b/databases/postgresql83-server/pkg-plist-server index 39d5b3457910..3b1a6f039a36 100644 --- a/databases/postgresql83-server/pkg-plist-server +++ b/databases/postgresql83-server/pkg-plist-server @@ -207,6 +207,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Argentina/Mendoza %%TZDATA%%share/postgresql/timezone/America/Argentina/Rio_Gallegos %%TZDATA%%share/postgresql/timezone/America/Argentina/San_Juan +%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Luis %%TZDATA%%share/postgresql/timezone/America/Argentina/Tucuman %%TZDATA%%share/postgresql/timezone/America/Argentina/Ushuaia %%TZDATA%%share/postgresql/timezone/America/Aruba @@ -383,6 +384,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Dushanbe %%TZDATA%%share/postgresql/timezone/Asia/Gaza %%TZDATA%%share/postgresql/timezone/Asia/Harbin +%%TZDATA%%share/postgresql/timezone/Asia/Ho_Chi_Minh %%TZDATA%%share/postgresql/timezone/Asia/Hong_Kong %%TZDATA%%share/postgresql/timezone/Asia/Hovd %%TZDATA%%share/postgresql/timezone/Asia/Irkutsk @@ -395,6 +397,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Karachi %%TZDATA%%share/postgresql/timezone/Asia/Kashgar %%TZDATA%%share/postgresql/timezone/Asia/Katmandu +%%TZDATA%%share/postgresql/timezone/Asia/Kolkata %%TZDATA%%share/postgresql/timezone/Asia/Krasnoyarsk %%TZDATA%%share/postgresql/timezone/Asia/Kuala_Lumpur %%TZDATA%%share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile index db59ef137c10..c850200be6ca 100644 --- a/databases/postgresql84-server/Makefile +++ b/databases/postgresql84-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.3.1 -PORTREVISION?= 1 +DISTVERSION?= 8.3.3 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -108,7 +107,7 @@ USE_AUTOTOOLS= autoconf:261 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-831-icu-xx-2008-03-17.diff.gz:icu +PATCHFILES+= pg-833-icu-xx-2008-06-11.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo index 0fdaf766ad8f..55212382b188 100644 --- a/databases/postgresql84-server/distinfo +++ b/databases/postgresql84-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.3.1.tar.bz2) = a5e0ed6a85b450dc217ec71da93243a7 -SHA256 (postgresql/postgresql-8.3.1.tar.bz2) = 7ccf1e5c987920e4d6eb98b8589939e29d3a361d285055d5af35ddd8e1a2d992 -SIZE (postgresql/postgresql-8.3.1.tar.bz2) = 13995572 -MD5 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = bce2f2d862a19f92de9d297233f856b1 -SHA256 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 085ef29c1ccbb83a06e07c52c82f268e65bc96f194319ac128998da5c0a00b1e -SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5252 +MD5 (postgresql/postgresql-8.3.3.tar.bz2) = 0ae4bd9620e84d3e08dcf923808d14d0 +SHA256 (postgresql/postgresql-8.3.3.tar.bz2) = e9406b93794dc4fd15b21e10512d2b694236d79b018d29b9ca86311d5cca2437 +SIZE (postgresql/postgresql-8.3.3.tar.bz2) = 14004538 +MD5 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 58773458a9a8498106d167b731c9fe6c +SHA256 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 2495a0b788bcc026663b47895d13c5228e862c036e032145749f5f0d0e9d35ed +SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5302 diff --git a/databases/postgresql84-server/files/502.pgsql b/databases/postgresql84-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql84-server/files/502.pgsql +++ b/databases/postgresql84-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql84-server/pkg-plist-server b/databases/postgresql84-server/pkg-plist-server index 39d5b3457910..3b1a6f039a36 100644 --- a/databases/postgresql84-server/pkg-plist-server +++ b/databases/postgresql84-server/pkg-plist-server @@ -207,6 +207,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Argentina/Mendoza %%TZDATA%%share/postgresql/timezone/America/Argentina/Rio_Gallegos %%TZDATA%%share/postgresql/timezone/America/Argentina/San_Juan +%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Luis %%TZDATA%%share/postgresql/timezone/America/Argentina/Tucuman %%TZDATA%%share/postgresql/timezone/America/Argentina/Ushuaia %%TZDATA%%share/postgresql/timezone/America/Aruba @@ -383,6 +384,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Dushanbe %%TZDATA%%share/postgresql/timezone/Asia/Gaza %%TZDATA%%share/postgresql/timezone/Asia/Harbin +%%TZDATA%%share/postgresql/timezone/Asia/Ho_Chi_Minh %%TZDATA%%share/postgresql/timezone/Asia/Hong_Kong %%TZDATA%%share/postgresql/timezone/Asia/Hovd %%TZDATA%%share/postgresql/timezone/Asia/Irkutsk @@ -395,6 +397,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Karachi %%TZDATA%%share/postgresql/timezone/Asia/Kashgar %%TZDATA%%share/postgresql/timezone/Asia/Katmandu +%%TZDATA%%share/postgresql/timezone/Asia/Kolkata %%TZDATA%%share/postgresql/timezone/Asia/Krasnoyarsk %%TZDATA%%share/postgresql/timezone/Asia/Kuala_Lumpur %%TZDATA%%share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile index db59ef137c10..c850200be6ca 100644 --- a/databases/postgresql90-server/Makefile +++ b/databases/postgresql90-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.3.1 -PORTREVISION?= 1 +DISTVERSION?= 8.3.3 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -108,7 +107,7 @@ USE_AUTOTOOLS= autoconf:261 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-831-icu-xx-2008-03-17.diff.gz:icu +PATCHFILES+= pg-833-icu-xx-2008-06-11.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo index 0fdaf766ad8f..55212382b188 100644 --- a/databases/postgresql90-server/distinfo +++ b/databases/postgresql90-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.3.1.tar.bz2) = a5e0ed6a85b450dc217ec71da93243a7 -SHA256 (postgresql/postgresql-8.3.1.tar.bz2) = 7ccf1e5c987920e4d6eb98b8589939e29d3a361d285055d5af35ddd8e1a2d992 -SIZE (postgresql/postgresql-8.3.1.tar.bz2) = 13995572 -MD5 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = bce2f2d862a19f92de9d297233f856b1 -SHA256 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 085ef29c1ccbb83a06e07c52c82f268e65bc96f194319ac128998da5c0a00b1e -SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5252 +MD5 (postgresql/postgresql-8.3.3.tar.bz2) = 0ae4bd9620e84d3e08dcf923808d14d0 +SHA256 (postgresql/postgresql-8.3.3.tar.bz2) = e9406b93794dc4fd15b21e10512d2b694236d79b018d29b9ca86311d5cca2437 +SIZE (postgresql/postgresql-8.3.3.tar.bz2) = 14004538 +MD5 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 58773458a9a8498106d167b731c9fe6c +SHA256 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 2495a0b788bcc026663b47895d13c5228e862c036e032145749f5f0d0e9d35ed +SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5302 diff --git a/databases/postgresql90-server/files/502.pgsql b/databases/postgresql90-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql90-server/files/502.pgsql +++ b/databases/postgresql90-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql90-server/pkg-plist-server b/databases/postgresql90-server/pkg-plist-server index 39d5b3457910..3b1a6f039a36 100644 --- a/databases/postgresql90-server/pkg-plist-server +++ b/databases/postgresql90-server/pkg-plist-server @@ -207,6 +207,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Argentina/Mendoza %%TZDATA%%share/postgresql/timezone/America/Argentina/Rio_Gallegos %%TZDATA%%share/postgresql/timezone/America/Argentina/San_Juan +%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Luis %%TZDATA%%share/postgresql/timezone/America/Argentina/Tucuman %%TZDATA%%share/postgresql/timezone/America/Argentina/Ushuaia %%TZDATA%%share/postgresql/timezone/America/Aruba @@ -383,6 +384,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Dushanbe %%TZDATA%%share/postgresql/timezone/Asia/Gaza %%TZDATA%%share/postgresql/timezone/Asia/Harbin +%%TZDATA%%share/postgresql/timezone/Asia/Ho_Chi_Minh %%TZDATA%%share/postgresql/timezone/Asia/Hong_Kong %%TZDATA%%share/postgresql/timezone/Asia/Hovd %%TZDATA%%share/postgresql/timezone/Asia/Irkutsk @@ -395,6 +397,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Karachi %%TZDATA%%share/postgresql/timezone/Asia/Kashgar %%TZDATA%%share/postgresql/timezone/Asia/Katmandu +%%TZDATA%%share/postgresql/timezone/Asia/Kolkata %%TZDATA%%share/postgresql/timezone/Asia/Krasnoyarsk %%TZDATA%%share/postgresql/timezone/Asia/Kuala_Lumpur %%TZDATA%%share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile index db59ef137c10..c850200be6ca 100644 --- a/databases/postgresql91-server/Makefile +++ b/databases/postgresql91-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.3.1 -PORTREVISION?= 1 +DISTVERSION?= 8.3.3 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -108,7 +107,7 @@ USE_AUTOTOOLS= autoconf:261 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-831-icu-xx-2008-03-17.diff.gz:icu +PATCHFILES+= pg-833-icu-xx-2008-06-11.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo index 0fdaf766ad8f..55212382b188 100644 --- a/databases/postgresql91-server/distinfo +++ b/databases/postgresql91-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.3.1.tar.bz2) = a5e0ed6a85b450dc217ec71da93243a7 -SHA256 (postgresql/postgresql-8.3.1.tar.bz2) = 7ccf1e5c987920e4d6eb98b8589939e29d3a361d285055d5af35ddd8e1a2d992 -SIZE (postgresql/postgresql-8.3.1.tar.bz2) = 13995572 -MD5 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = bce2f2d862a19f92de9d297233f856b1 -SHA256 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 085ef29c1ccbb83a06e07c52c82f268e65bc96f194319ac128998da5c0a00b1e -SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5252 +MD5 (postgresql/postgresql-8.3.3.tar.bz2) = 0ae4bd9620e84d3e08dcf923808d14d0 +SHA256 (postgresql/postgresql-8.3.3.tar.bz2) = e9406b93794dc4fd15b21e10512d2b694236d79b018d29b9ca86311d5cca2437 +SIZE (postgresql/postgresql-8.3.3.tar.bz2) = 14004538 +MD5 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 58773458a9a8498106d167b731c9fe6c +SHA256 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 2495a0b788bcc026663b47895d13c5228e862c036e032145749f5f0d0e9d35ed +SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5302 diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql91-server/files/502.pgsql +++ b/databases/postgresql91-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql91-server/pkg-plist-server b/databases/postgresql91-server/pkg-plist-server index 39d5b3457910..3b1a6f039a36 100644 --- a/databases/postgresql91-server/pkg-plist-server +++ b/databases/postgresql91-server/pkg-plist-server @@ -207,6 +207,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Argentina/Mendoza %%TZDATA%%share/postgresql/timezone/America/Argentina/Rio_Gallegos %%TZDATA%%share/postgresql/timezone/America/Argentina/San_Juan +%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Luis %%TZDATA%%share/postgresql/timezone/America/Argentina/Tucuman %%TZDATA%%share/postgresql/timezone/America/Argentina/Ushuaia %%TZDATA%%share/postgresql/timezone/America/Aruba @@ -383,6 +384,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Dushanbe %%TZDATA%%share/postgresql/timezone/Asia/Gaza %%TZDATA%%share/postgresql/timezone/Asia/Harbin +%%TZDATA%%share/postgresql/timezone/Asia/Ho_Chi_Minh %%TZDATA%%share/postgresql/timezone/Asia/Hong_Kong %%TZDATA%%share/postgresql/timezone/Asia/Hovd %%TZDATA%%share/postgresql/timezone/Asia/Irkutsk @@ -395,6 +397,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Karachi %%TZDATA%%share/postgresql/timezone/Asia/Kashgar %%TZDATA%%share/postgresql/timezone/Asia/Katmandu +%%TZDATA%%share/postgresql/timezone/Asia/Kolkata %%TZDATA%%share/postgresql/timezone/Asia/Krasnoyarsk %%TZDATA%%share/postgresql/timezone/Asia/Kuala_Lumpur %%TZDATA%%share/postgresql/timezone/Asia/Kuching diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile index db59ef137c10..c850200be6ca 100644 --- a/databases/postgresql92-server/Makefile +++ b/databases/postgresql92-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.3.1 -PORTREVISION?= 1 +DISTVERSION?= 8.3.3 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -108,7 +107,7 @@ USE_AUTOTOOLS= autoconf:261 CONFIGURE_ARGS+=--with-icu LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-831-icu-xx-2008-03-17.diff.gz:icu +PATCHFILES+= pg-833-icu-xx-2008-06-11.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo index 0fdaf766ad8f..55212382b188 100644 --- a/databases/postgresql92-server/distinfo +++ b/databases/postgresql92-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.3.1.tar.bz2) = a5e0ed6a85b450dc217ec71da93243a7 -SHA256 (postgresql/postgresql-8.3.1.tar.bz2) = 7ccf1e5c987920e4d6eb98b8589939e29d3a361d285055d5af35ddd8e1a2d992 -SIZE (postgresql/postgresql-8.3.1.tar.bz2) = 13995572 -MD5 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = bce2f2d862a19f92de9d297233f856b1 -SHA256 (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 085ef29c1ccbb83a06e07c52c82f268e65bc96f194319ac128998da5c0a00b1e -SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5252 +MD5 (postgresql/postgresql-8.3.3.tar.bz2) = 0ae4bd9620e84d3e08dcf923808d14d0 +SHA256 (postgresql/postgresql-8.3.3.tar.bz2) = e9406b93794dc4fd15b21e10512d2b694236d79b018d29b9ca86311d5cca2437 +SIZE (postgresql/postgresql-8.3.3.tar.bz2) = 14004538 +MD5 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 58773458a9a8498106d167b731c9fe6c +SHA256 (postgresql/pg-833-icu-xx-2008-06-11.diff.gz) = 2495a0b788bcc026663b47895d13c5228e862c036e032145749f5f0d0e9d35ed +SIZE (postgresql/pg-831-icu-xx-2008-03-17.diff.gz) = 5302 diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql92-server/files/502.pgsql +++ b/databases/postgresql92-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # 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\'"` + 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 "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; 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}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql92-server/pkg-plist-server b/databases/postgresql92-server/pkg-plist-server index 39d5b3457910..3b1a6f039a36 100644 --- a/databases/postgresql92-server/pkg-plist-server +++ b/databases/postgresql92-server/pkg-plist-server @@ -207,6 +207,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Argentina/Mendoza %%TZDATA%%share/postgresql/timezone/America/Argentina/Rio_Gallegos %%TZDATA%%share/postgresql/timezone/America/Argentina/San_Juan +%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Luis %%TZDATA%%share/postgresql/timezone/America/Argentina/Tucuman %%TZDATA%%share/postgresql/timezone/America/Argentina/Ushuaia %%TZDATA%%share/postgresql/timezone/America/Aruba @@ -383,6 +384,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Dushanbe %%TZDATA%%share/postgresql/timezone/Asia/Gaza %%TZDATA%%share/postgresql/timezone/Asia/Harbin +%%TZDATA%%share/postgresql/timezone/Asia/Ho_Chi_Minh %%TZDATA%%share/postgresql/timezone/Asia/Hong_Kong %%TZDATA%%share/postgresql/timezone/Asia/Hovd %%TZDATA%%share/postgresql/timezone/Asia/Irkutsk @@ -395,6 +397,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Asia/Karachi %%TZDATA%%share/postgresql/timezone/Asia/Kashgar %%TZDATA%%share/postgresql/timezone/Asia/Katmandu +%%TZDATA%%share/postgresql/timezone/Asia/Kolkata %%TZDATA%%share/postgresql/timezone/Asia/Krasnoyarsk %%TZDATA%%share/postgresql/timezone/Asia/Kuala_Lumpur %%TZDATA%%share/postgresql/timezone/Asia/Kuching |