Hi,
The PostgreSQL group has released a critical update to all
supported versions of PostgreSQL databases.
This update fixes three serious data-loss bugs affecting
replication and database maintenance.
Annoucement: http://www.postgresql.org/about/news/1492/
More informations here: https://wiki.postgresql.org/wiki/Nov2013ReplicationIssue
I made a diff for:
+ -current (PostgreSQL 9.3.2, tested on @amd64)
+ 5.4 -stable (PostgreSQL 9.2.6, tested on @amd64)
+ 5.3 -stable (PostgreSQL 9.2.6, NOT tested but it should work. If anyone has a
5.3 system it would
be nice to give it a try)
Comments/OK ?
Regards,
--
Pierre-Emmanuel André <pea at raveland.org>
GPG key: 0x487CE475
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.181
diff -u -p -u -p -r1.181 Makefile
--- Makefile 1 Nov 2013 21:07:59 -0000 1.181
+++ Makefile 29 Dec 2013 20:50:40 -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.0
+VERSION= 9.3.2
DISTNAME= postgresql-${VERSION}
PKGNAME-main= postgresql-client-${VERSION}
PKGNAME-server= postgresql-server-${VERSION}
@@ -17,7 +17,6 @@ PKGNAME-docs= postgresql-docs-${VERSION}
PKGNAME-contrib=postgresql-contrib-${VERSION}
PKGNAME-plpython=postgresql-plpython-${VERSION}
-REVISION-server= 1
CATEGORIES= databases
SHARED_LIBS= ecpg 7.5 \
@@ -110,7 +109,8 @@ LIB_DEPENDS-contrib= databases/postgresq
WANTLIB-contrib= ${WANTLIB-main} pq>=4 ossp-uuid
LIB_DEPENDS-plpython= ${MODPY_LIB_DEPENDS}
-WANTLIB-plpython = c m pthread util ${MODPY_WANTLIB}
+WANTLIB-plpython = c m pthread util com_err crypto asn1 \
+ heimbase krb5 roken wind ${MODPY_WANTLIB}
RUN_DEPENDS-plpython= databases/postgresql,-server=${VERSION}
WANTLIB-docs=
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.49
diff -u -p -u -p -r1.49 distinfo
--- distinfo 15 Oct 2013 02:18:16 -0000 1.49
+++ distinfo 29 Dec 2013 20:50:40 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-9.3.0.tar.gz) = 13YgtEito4zhoLE2bqladjZutGjdzfMk7aSOEvj/ao8=
-SIZE (postgresql-9.3.0.tar.gz) = 22140691
+SHA256 (postgresql-9.3.2.tar.gz) = oEGSX0H/TYhlvg/gsmkBf3rD7Q/4Y5urLJYwrhhX1V4=
+SIZE (postgresql-9.3.2.tar.gz) = 22218672
Index: pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.10
diff -u -p -u -p -r1.10 PLIST-contrib
--- pkg/PLIST-contrib 15 Oct 2013 02:18:18 -0000 1.10
+++ pkg/PLIST-contrib 29 Dec 2013 20:50:40 -0000
@@ -101,7 +101,8 @@ share/postgresql/extension/fuzzystrmatch
share/postgresql/extension/fuzzystrmatch--unpackaged--1.0.sql
share/postgresql/extension/fuzzystrmatch.control
share/postgresql/extension/hstore--1.0--1.1.sql
-share/postgresql/extension/hstore--1.1.sql
+share/postgresql/extension/hstore--1.1--1.2.sql
+share/postgresql/extension/hstore--1.2.sql
share/postgresql/extension/hstore--unpackaged--1.0.sql
share/postgresql/extension/hstore.control
share/postgresql/extension/insert_username--1.0.sql
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.61
diff -u -p -u -p -r1.61 PLIST-docs
--- pkg/PLIST-docs 15 Oct 2013 02:18:18 -0000 1.61
+++ pkg/PLIST-docs 29 Dec 2013 20:50:40 -0000
@@ -779,6 +779,8 @@ share/doc/postgresql/html/release-8-4-14
share/doc/postgresql/html/release-8-4-15.html
share/doc/postgresql/html/release-8-4-16.html
share/doc/postgresql/html/release-8-4-17.html
+share/doc/postgresql/html/release-8-4-18.html
+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-3.html
share/doc/postgresql/html/release-8-4-4.html
@@ -793,6 +795,8 @@ share/doc/postgresql/html/release-9-0-10
share/doc/postgresql/html/release-9-0-11.html
share/doc/postgresql/html/release-9-0-12.html
share/doc/postgresql/html/release-9-0-13.html
+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-2.html
share/doc/postgresql/html/release-9-0-3.html
share/doc/postgresql/html/release-9-0-4.html
@@ -803,6 +807,8 @@ share/doc/postgresql/html/release-9-0-8.
share/doc/postgresql/html/release-9-0-9.html
share/doc/postgresql/html/release-9-0.html
share/doc/postgresql/html/release-9-1-1.html
+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-2.html
share/doc/postgresql/html/release-9-1-3.html
share/doc/postgresql/html/release-9-1-4.html
@@ -816,7 +822,11 @@ share/doc/postgresql/html/release-9-2-1.
share/doc/postgresql/html/release-9-2-2.html
share/doc/postgresql/html/release-9-2-3.html
share/doc/postgresql/html/release-9-2-4.html
+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.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.html
share/doc/postgresql/html/release.html
share/doc/postgresql/html/resources.html
Index: pkg/PLIST-plpython
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-plpython,v
retrieving revision 1.1
diff -u -p -u -p -r1.1 PLIST-plpython
--- pkg/PLIST-plpython 15 Oct 2013 02:18:19 -0000 1.1
+++ pkg/PLIST-plpython 29 Dec 2013 20:50:40 -0000
@@ -1,5 +1,6 @@
@comment $OpenBSD: PLIST-plpython,v 1.1 2013/10/15 02:18:19 jeremy Exp $
lib/postgresql/plpython2.so
+share/doc/pkg-readmes/${FULLPKGNAME\-plpython}
share/postgresql/extension/plpython2u--1.0.sql
share/postgresql/extension/plpython2u--unpackaged--1.0.sql
share/postgresql/extension/plpython2u.control
Index: pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
retrieving revision 1.24
diff -u -p -u -p -r1.24 PLIST-server
--- pkg/PLIST-server 22 Oct 2013 06:26:09 -0000 1.24
+++ pkg/PLIST-server 29 Dec 2013 20:50:40 -0000
@@ -15,27 +15,6 @@
@bin bin/pg_xlogdump
@bin bin/postgres
bin/postmaster
-@comment include/postgresql/server/port/irix.h
-@comment include/postgresql/server/port/win32/
-@comment include/postgresql/server/port/win32/arpa/
-@comment include/postgresql/server/port/win32/arpa/inet.h
-@comment include/postgresql/server/port/win32/dlfcn.h
-@comment include/postgresql/server/port/win32/grp.h
-@comment include/postgresql/server/port/win32/netdb.h
-@comment include/postgresql/server/port/win32/netinet/
-@comment include/postgresql/server/port/win32/netinet/in.h
-@comment include/postgresql/server/port/win32/pwd.h
-@comment include/postgresql/server/port/win32/sys/
-@comment include/postgresql/server/port/win32/sys/socket.h
-@comment include/postgresql/server/port/win32/sys/wait.h
-@comment include/postgresql/server/port/win32_msvc/
-@comment include/postgresql/server/port/win32_msvc/dirent.h
-@comment include/postgresql/server/port/win32_msvc/sys/
-@comment include/postgresql/server/port/win32_msvc/sys/file.h
-@comment include/postgresql/server/port/win32_msvc/sys/param.h
-@comment include/postgresql/server/port/win32_msvc/sys/time.h
-@comment include/postgresql/server/port/win32_msvc/unistd.h
-@comment include/postgresql/server/port/win32_msvc/utime.h
include/postgresql/server/
include/postgresql/server/access/
include/postgresql/server/access/attnum.h
@@ -344,13 +323,14 @@ include/postgresql/server/pgstat.h
include/postgresql/server/pgtar.h
include/postgresql/server/pgtime.h
include/postgresql/server/plpgsql.h
-include/postgresql/server/port.h
include/postgresql/server/port/
+include/postgresql/server/port.h
include/postgresql/server/port/aix.h
include/postgresql/server/port/cygwin.h
include/postgresql/server/port/darwin.h
include/postgresql/server/port/freebsd.h
include/postgresql/server/port/hpux.h
+@comment include/postgresql/server/port/irix.h
include/postgresql/server/port/linux.h
include/postgresql/server/port/netbsd.h
include/postgresql/server/port/openbsd.h
@@ -358,7 +338,27 @@ include/postgresql/server/port/osf.h
include/postgresql/server/port/sco.h
include/postgresql/server/port/solaris.h
include/postgresql/server/port/unixware.h
-include/postgresql/server/port/win32.h
+@comment include/postgresql/server/port/win32/
+@comment include/postgresql/server/port/win32.h
+@comment include/postgresql/server/port/win32/arpa/
+@comment include/postgresql/server/port/win32/arpa/inet.h
+@comment include/postgresql/server/port/win32/dlfcn.h
+@comment include/postgresql/server/port/win32/grp.h
+@comment include/postgresql/server/port/win32/netdb.h
+@comment include/postgresql/server/port/win32/netinet/
+@comment include/postgresql/server/port/win32/netinet/in.h
+@comment include/postgresql/server/port/win32/pwd.h
+@comment include/postgresql/server/port/win32/sys/
+@comment include/postgresql/server/port/win32/sys/socket.h
+@comment include/postgresql/server/port/win32/sys/wait.h
+@comment include/postgresql/server/port/win32_msvc/
+@comment include/postgresql/server/port/win32_msvc/dirent.h
+@comment include/postgresql/server/port/win32_msvc/sys/
+@comment include/postgresql/server/port/win32_msvc/sys/file.h
+@comment include/postgresql/server/port/win32_msvc/sys/param.h
+@comment include/postgresql/server/port/win32_msvc/sys/time.h
+@comment include/postgresql/server/port/win32_msvc/unistd.h
+@comment include/postgresql/server/port/win32_msvc/utime.h
include/postgresql/server/portability/
include/postgresql/server/portability/instr_time.h
include/postgresql/server/postgres.h
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.178
diff -u -p -u -p -r1.178 Makefile
--- Makefile 20 Jun 2013 08:26:13 -0000 1.178
+++ Makefile 29 Dec 2013 21:02:04 -0000
@@ -5,16 +5,13 @@ COMMENT-server= PostgreSQL RDBMS (server
COMMENT-docs= PostgreSQL RDBMS documentation
COMMENT-contrib=PostgreSQL RDBMS contributions
-VERSION= 9.2.4
+VERSION= 9.2.6
DISTNAME= postgresql-${VERSION}
PKGNAME-main= postgresql-client-${VERSION}
PKGNAME-server= postgresql-server-${VERSION}
PKGNAME-docs= postgresql-docs-${VERSION}
PKGNAME-contrib=postgresql-contrib-${VERSION}
-REVISION-main= 2
-REVISION-server=2
-REVISION-contrib=3
CATEGORIES= databases
SHARED_LIBS= ecpg 7.4 \
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.48
diff -u -p -u -p -r1.48 distinfo
--- distinfo 4 Apr 2013 14:45:46 -0000 1.48
+++ distinfo 29 Dec 2013 21:02:04 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-9.2.4.tar.gz) = 8IQO3Px3gMRAeXQJIc+bUbN64oNVgO30eOjwOEEWai8=
-SIZE (postgresql-9.2.4.tar.gz) = 21539369
+SHA256 (postgresql-9.2.6.tar.gz) = VQbKYMPl3zA/W/aPB2Yq6z9SPDT3I+H+fhWrmqZ7PjY=
+SIZE (postgresql-9.2.6.tar.gz) = 21641399
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.60
diff -u -p -u -p -r1.60 PLIST-docs
--- pkg/PLIST-docs 4 Apr 2013 14:45:46 -0000 1.60
+++ pkg/PLIST-docs 29 Dec 2013 21:02:04 -0000
@@ -768,6 +768,8 @@ share/doc/postgresql/html/release-8-4-14
share/doc/postgresql/html/release-8-4-15.html
share/doc/postgresql/html/release-8-4-16.html
share/doc/postgresql/html/release-8-4-17.html
+share/doc/postgresql/html/release-8-4-18.html
+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-3.html
share/doc/postgresql/html/release-8-4-4.html
@@ -782,6 +784,8 @@ share/doc/postgresql/html/release-9-0-10
share/doc/postgresql/html/release-9-0-11.html
share/doc/postgresql/html/release-9-0-12.html
share/doc/postgresql/html/release-9-0-13.html
+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-2.html
share/doc/postgresql/html/release-9-0-3.html
share/doc/postgresql/html/release-9-0-4.html
@@ -792,6 +796,8 @@ share/doc/postgresql/html/release-9-0-8.
share/doc/postgresql/html/release-9-0-9.html
share/doc/postgresql/html/release-9-0.html
share/doc/postgresql/html/release-9-1-1.html
+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-2.html
share/doc/postgresql/html/release-9-1-3.html
share/doc/postgresql/html/release-9-1-4.html
@@ -805,6 +811,8 @@ share/doc/postgresql/html/release-9-2-1.
share/doc/postgresql/html/release-9-2-2.html
share/doc/postgresql/html/release-9-2-3.html
share/doc/postgresql/html/release-9-2-4.html
+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.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.1
diff -u -p -u -p -r1.171.2.1 Makefile
--- Makefile 3 May 2013 07:30:18 -0000 1.171.2.1
+++ Makefile 29 Dec 2013 21:09:27 -0000
@@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server
COMMENT-docs= PostgreSQL RDBMS documentation
COMMENT-contrib=PostgreSQL RDBMS contributions
-VERSION= 9.2.4
+VERSION= 9.2.6
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.1
diff -u -p -u -p -r1.47.2.1 distinfo
--- distinfo 3 May 2013 07:30:18 -0000 1.47.2.1
+++ distinfo 29 Dec 2013 21:09:27 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-9.2.4.tar.gz) = 8IQO3Px3gMRAeXQJIc+bUbN64oNVgO30eOjwOEEWai8=
-SIZE (postgresql-9.2.4.tar.gz) = 21539369
+SHA256 (postgresql-9.2.6.tar.gz) = VQbKYMPl3zA/W/aPB2Yq6z9SPDT3I+H+fhWrmqZ7PjY=
+SIZE (postgresql-9.2.6.tar.gz) = 21641399
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.59.2.1
diff -u -p -u -p -r1.59.2.1 PLIST-docs
--- pkg/PLIST-docs 3 May 2013 07:30:18 -0000 1.59.2.1
+++ pkg/PLIST-docs 29 Dec 2013 21:09:27 -0000
@@ -768,6 +768,8 @@ share/doc/postgresql/html/release-8-4-14
share/doc/postgresql/html/release-8-4-15.html
share/doc/postgresql/html/release-8-4-16.html
share/doc/postgresql/html/release-8-4-17.html
+share/doc/postgresql/html/release-8-4-18.html
+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-3.html
share/doc/postgresql/html/release-8-4-4.html
@@ -782,6 +784,8 @@ share/doc/postgresql/html/release-9-0-10
share/doc/postgresql/html/release-9-0-11.html
share/doc/postgresql/html/release-9-0-12.html
share/doc/postgresql/html/release-9-0-13.html
+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-2.html
share/doc/postgresql/html/release-9-0-3.html
share/doc/postgresql/html/release-9-0-4.html
@@ -805,6 +809,8 @@ share/doc/postgresql/html/release-9-2-1.
share/doc/postgresql/html/release-9-2-2.html
share/doc/postgresql/html/release-9-2-3.html
share/doc/postgresql/html/release-9-2-4.html
+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.html
share/doc/postgresql/html/release.html
share/doc/postgresql/html/resources.html
