Re: PostgreSQL: Critical update !

2014-01-02 Thread LEVAI Daniel 
On k, dec 29, 2013 at 22:37:16 +0100, Pierre-Emmanuel André wrote:
[...]
 I made a diff for: 
[...]
 + 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)

Hey guys, I hope I'm not too late for the party.
The build and install went fine (although I was not able to `make package` from
ports/mystuff, it needed the ports/database/postgresql to be patched
also).

The server and the client library works as expected on 5.3.


Thank you,
Daniel

-- 
LÉVAI Dániel
PGP key ID = 0x83B63A8F
Key fingerprint = DBEC C66B A47A DFA2 792D  650C C69B BE4C 83B6 3A8F

Re: PostgreSQL: Critical update !

2013-12-31 Thread Pierre-Emmanuel André 
On Mon, Dec 30, 2013 at 04:21:26PM -0800, patrick keshishian wrote:
 err...
 
  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 -  1.1
  +++ pkg/PLIST-plpython  29 Dec 2013 20:50:40 -
  @@ -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}
 
 should be ${FULLPKGNAME}. packaging fails on my -current
 (snapshot from 2013-DEC-28) otherwise.

Argh, good catch. Thanks
Updated diff


-- 
Pierre-Emmanuel André pea at raveland.org
GPG key: 0xBB8D3F0E
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 -	1.181
+++ Makefile	31 Dec 2013 05:33:03 -
@@ -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 -	1.49
+++ distinfo	31 Dec 2013 05:33:03 -
@@ -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 -	1.10
+++ pkg/PLIST-contrib	31 Dec 2013 05:33:03 -
@@ -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 -	1.61
+++ pkg/PLIST-docs	31 Dec 2013 05:33:03 -
@@ -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

Re: PostgreSQL: Critical update !

2013-12-30 Thread patrick keshishian 
err...

 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-plpython15 Oct 2013 02:18:19 -  1.1
 +++ pkg/PLIST-plpython29 Dec 2013 20:50:40 -
 @@ -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}

should be ${FULLPKGNAME}. packaging fails on my -current
(snapshot from 2013-DEC-28) otherwise.

  share/postgresql/extension/plpython2u--1.0.sql
  share/postgresql/extension/plpython2u--unpackaged--1.0.sql
  share/postgresql/extension/plpython2u.control
 Index: pkg/PLIST-server


On 12/29/13, Pierre-Emmanuel André p...@raveland.org wrote:
 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

PostgreSQL: Critical update !

2013-12-29 Thread Pierre-Emmanuel André 
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 -	1.181
+++ Makefile	29 Dec 2013 20:50:40 -
@@ -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 -	1.49
+++ distinfo	29 Dec 2013 20:50:40 -
@@ -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 -	1.10
+++ pkg/PLIST-contrib	29 Dec 2013 20:50:40 -
@@ -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 -	1.61
+++ pkg/PLIST-docs	29 Dec 2013 20:50:40 -
@@ -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.