Hi, There are new updates for PostgreSQL. The diffs for 5.4 and 5.3 are minor updates: http://www.postgresql.org/docs/9.2/static/release-9-2-8.html
The diff for -current and 5.5 is more critical: "The data corruption issue in PostgreSQL 9.3 affects binary replication standbys, servers being recovered from point-in-time-recovery backup, and standalone servers which recover from a system crash. The bug causes unrecoverable index corruption during recovery due to incorrect replay of row locking operations. This can then cause query results to be inconsistent depending on whether or not an index is used, and eventually lead to primary key violations and similar issues. " More informations here: http://www.postgresql.org/about/news/1511/ I tested -current, 5.5 -stable and 5.4-stable on @amd64. Could someone do a test on a 5.3-stable ? Comments, OK ? Regards, -- Pierre-Emmanuel André <pea at raveland.org> GPG key: 0xBB8D3F0E
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.183 diff -u -p -u -p -r1.183 Makefile --- Makefile 11 Mar 2014 10:42:34 -0000 1.183 +++ Makefile 21 Mar 2014 12:36:35 -0000 @@ -9,7 +9,7 @@ COMMENT-plpython=Python procedural langu # DO NOT FORGET to also change the @ask-update entry in pkg/PLIST-server # in case a dump before / restore after pkg_add -u is required! -VERSION= 9.3.3 +VERSION= 9.3.4 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} PKGNAME-server= postgresql-server-${VERSION} Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.51 diff -u -p -u -p -r1.51 distinfo --- distinfo 11 Mar 2014 10:42:34 -0000 1.51 +++ distinfo 21 Mar 2014 12:36:35 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-9.3.3.tar.gz) = LbXruNTXwZ8G7Vhc2e/UH/Ygsi4whI+uOsLuqRhryHs= -SIZE (postgresql-9.3.3.tar.gz) = 21851007 +SHA256 (postgresql-9.3.4.tar.gz) = cVW5TCq+x9BWOEY4Of9AP97oJ01yor0oCnvs3uSUFUA= +SIZE (postgresql-9.3.4.tar.gz) = 21865589 Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.63 diff -u -p -u -p -r1.63 PLIST-docs --- pkg/PLIST-docs 11 Mar 2014 10:42:34 -0000 1.63 +++ pkg/PLIST-docs 21 Mar 2014 12:36:35 -0000 @@ -783,6 +783,7 @@ share/doc/postgresql/html/release-8-4-18 share/doc/postgresql/html/release-8-4-19.html share/doc/postgresql/html/release-8-4-2.html share/doc/postgresql/html/release-8-4-20.html +share/doc/postgresql/html/release-8-4-21.html share/doc/postgresql/html/release-8-4-3.html share/doc/postgresql/html/release-8-4-4.html share/doc/postgresql/html/release-8-4-5.html @@ -799,6 +800,7 @@ share/doc/postgresql/html/release-9-0-13 share/doc/postgresql/html/release-9-0-14.html share/doc/postgresql/html/release-9-0-15.html share/doc/postgresql/html/release-9-0-16.html +share/doc/postgresql/html/release-9-0-17.html share/doc/postgresql/html/release-9-0-2.html share/doc/postgresql/html/release-9-0-3.html share/doc/postgresql/html/release-9-0-4.html @@ -812,6 +814,7 @@ share/doc/postgresql/html/release-9-1-1. share/doc/postgresql/html/release-9-1-10.html share/doc/postgresql/html/release-9-1-11.html share/doc/postgresql/html/release-9-1-12.html +share/doc/postgresql/html/release-9-1-13.html share/doc/postgresql/html/release-9-1-2.html share/doc/postgresql/html/release-9-1-3.html share/doc/postgresql/html/release-9-1-4.html @@ -828,10 +831,12 @@ share/doc/postgresql/html/release-9-2-4. share/doc/postgresql/html/release-9-2-5.html share/doc/postgresql/html/release-9-2-6.html share/doc/postgresql/html/release-9-2-7.html +share/doc/postgresql/html/release-9-2-8.html share/doc/postgresql/html/release-9-2.html share/doc/postgresql/html/release-9-3-1.html share/doc/postgresql/html/release-9-3-2.html share/doc/postgresql/html/release-9-3-3.html +share/doc/postgresql/html/release-9-3-4.html share/doc/postgresql/html/release-9-3.html share/doc/postgresql/html/release.html share/doc/postgresql/html/resources.html
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.178.2.2 diff -u -p -u -p -r1.178.2.2 Makefile --- Makefile 20 Mar 2014 09:12:50 -0000 1.178.2.2 +++ Makefile 21 Mar 2014 12:52:34 -0000 @@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server COMMENT-docs= PostgreSQL RDBMS documentation COMMENT-contrib=PostgreSQL RDBMS contributions -VERSION= 9.2.7 +VERSION= 9.2.8 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} PKGNAME-server= postgresql-server-${VERSION} Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.48.2.2 diff -u -p -u -p -r1.48.2.2 distinfo --- distinfo 20 Mar 2014 09:12:50 -0000 1.48.2.2 +++ distinfo 21 Mar 2014 12:52:34 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-9.2.7.tar.gz) = BPFA2Xr1o5FZYjThp7QJfQc8BjZ0E92s3Z6Dr0nEDxw= -SIZE (postgresql-9.2.7.tar.gz) = 21251888 +SHA256 (postgresql-9.2.8.tar.gz) = OoG+jM/+mqA9YOGBfC5XyMQQYRIcnob3Ju15XOAx1es= +SIZE (postgresql-9.2.8.tar.gz) = 21260503 Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.60.2.2 diff -u -p -u -p -r1.60.2.2 PLIST-docs --- pkg/PLIST-docs 20 Mar 2014 09:12:51 -0000 1.60.2.2 +++ pkg/PLIST-docs 21 Mar 2014 12:52:34 -0000 @@ -772,6 +772,7 @@ share/doc/postgresql/html/release-8-4-18 share/doc/postgresql/html/release-8-4-19.html share/doc/postgresql/html/release-8-4-2.html share/doc/postgresql/html/release-8-4-20.html +share/doc/postgresql/html/release-8-4-21.html share/doc/postgresql/html/release-8-4-3.html share/doc/postgresql/html/release-8-4-4.html share/doc/postgresql/html/release-8-4-5.html @@ -788,6 +789,7 @@ share/doc/postgresql/html/release-9-0-13 share/doc/postgresql/html/release-9-0-14.html share/doc/postgresql/html/release-9-0-15.html share/doc/postgresql/html/release-9-0-16.html +share/doc/postgresql/html/release-9-0-17.html share/doc/postgresql/html/release-9-0-2.html share/doc/postgresql/html/release-9-0-3.html share/doc/postgresql/html/release-9-0-4.html @@ -801,6 +803,7 @@ share/doc/postgresql/html/release-9-1-1. share/doc/postgresql/html/release-9-1-10.html share/doc/postgresql/html/release-9-1-11.html share/doc/postgresql/html/release-9-1-12.html +share/doc/postgresql/html/release-9-1-13.html share/doc/postgresql/html/release-9-1-2.html share/doc/postgresql/html/release-9-1-3.html share/doc/postgresql/html/release-9-1-4.html @@ -817,6 +820,7 @@ share/doc/postgresql/html/release-9-2-4. share/doc/postgresql/html/release-9-2-5.html share/doc/postgresql/html/release-9-2-6.html share/doc/postgresql/html/release-9-2-7.html +share/doc/postgresql/html/release-9-2-8.html share/doc/postgresql/html/release-9-2.html share/doc/postgresql/html/release.html share/doc/postgresql/html/resources.html
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.171.2.3 diff -u -p -u -p -r1.171.2.3 Makefile --- Makefile 20 Mar 2014 09:03:37 -0000 1.171.2.3 +++ Makefile 21 Mar 2014 12:54:02 -0000 @@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server COMMENT-docs= PostgreSQL RDBMS documentation COMMENT-contrib=PostgreSQL RDBMS contributions -VERSION= 9.2.7 +VERSION= 9.2.8 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} PKGNAME-server= postgresql-server-${VERSION} Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.47.2.3 diff -u -p -u -p -r1.47.2.3 distinfo --- distinfo 20 Mar 2014 09:03:37 -0000 1.47.2.3 +++ distinfo 21 Mar 2014 12:54:02 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-9.2.7.tar.gz) = BPFA2Xr1o5FZYjThp7QJfQc8BjZ0E92s3Z6Dr0nEDxw= -SIZE (postgresql-9.2.7.tar.gz) = 21251888 +SHA256 (postgresql-9.2.8.tar.gz) = OoG+jM/+mqA9YOGBfC5XyMQQYRIcnob3Ju15XOAx1es= +SIZE (postgresql-9.2.8.tar.gz) = 21260503 Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.59.2.3 diff -u -p -u -p -r1.59.2.3 PLIST-docs --- pkg/PLIST-docs 20 Mar 2014 09:03:37 -0000 1.59.2.3 +++ pkg/PLIST-docs 21 Mar 2014 12:54:02 -0000 @@ -772,6 +772,7 @@ share/doc/postgresql/html/release-8-4-18 share/doc/postgresql/html/release-8-4-19.html share/doc/postgresql/html/release-8-4-2.html share/doc/postgresql/html/release-8-4-20.html +share/doc/postgresql/html/release-8-4-21.html share/doc/postgresql/html/release-8-4-3.html share/doc/postgresql/html/release-8-4-4.html share/doc/postgresql/html/release-8-4-5.html @@ -788,6 +789,7 @@ share/doc/postgresql/html/release-9-0-13 share/doc/postgresql/html/release-9-0-14.html share/doc/postgresql/html/release-9-0-15.html share/doc/postgresql/html/release-9-0-16.html +share/doc/postgresql/html/release-9-0-17.html share/doc/postgresql/html/release-9-0-2.html share/doc/postgresql/html/release-9-0-3.html share/doc/postgresql/html/release-9-0-4.html @@ -801,6 +803,7 @@ share/doc/postgresql/html/release-9-1-1. share/doc/postgresql/html/release-9-1-10.html share/doc/postgresql/html/release-9-1-11.html share/doc/postgresql/html/release-9-1-12.html +share/doc/postgresql/html/release-9-1-13.html share/doc/postgresql/html/release-9-1-2.html share/doc/postgresql/html/release-9-1-3.html share/doc/postgresql/html/release-9-1-4.html @@ -817,6 +820,7 @@ share/doc/postgresql/html/release-9-2-4. share/doc/postgresql/html/release-9-2-5.html share/doc/postgresql/html/release-9-2-6.html share/doc/postgresql/html/release-9-2-7.html +share/doc/postgresql/html/release-9-2-8.html share/doc/postgresql/html/release-9-2.html share/doc/postgresql/html/release.html share/doc/postgresql/html/resources.html