[PostgreSQL] Updates for -current and -stable (5.5, 5.4 and 5.3)

2014-03-21 Thread Pierre-Emmanuel André
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é 
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 -	1.183
+++ Makefile	21 Mar 2014 12:36:35 -
@@ -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 -	1.51
+++ distinfo	21 Mar 2014 12:36:35 -
@@ -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 -	1.63
+++ pkg/PLIST-docs	21 Mar 2014 12:36:35 -
@@ -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 -	1.178.2.2
+++ Makefile	21 Mar 2014 12:52:34 -
@@ -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 

Re: [PostgreSQL] Updates for -current and -stable (5.5, 5.4 and 5.3)

2014-03-26 Thread Pierre-Emmanuel André
On Fri, Mar 21, 2014 at 02:18:23PM +0100, Pierre-Emmanuel André wrote:
> 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 ?


ping ??


-- 
Pierre-Emmanuel André 
GPG key: 0xBB8D3F0E



Re: [PostgreSQL] Updates for -current and -stable (5.5, 5.4 and 5.3)

2014-03-27 Thread LEVAI Daniel
On sze, márc 26, 2014 at 16:57:41 +0100, Pierre-Emmanuel André wrote:
> On Fri, Mar 21, 2014 at 02:18:23PM +0100, Pierre-Emmanuel André wrote:
> > 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 ?
> 
> 
> ping ??

No 5.3, but it's been working well for me on 5.4 i386.


Daniel

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



Re: [PostgreSQL] Updates for -current and -stable (5.5, 5.4 and 5.3)

2014-03-28 Thread Pierre-Emmanuel André
On Thu, Mar 27, 2014 at 10:14:45PM +0100, LEVAI Daniel wrote:
> On sze, márc 26, 2014 at 16:57:41 +0100, Pierre-Emmanuel André wrote:
> > On Fri, Mar 21, 2014 at 02:18:23PM +0100, Pierre-Emmanuel André wrote:
> > > 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 ?
> > 
> > 
> > ping ??
> 
> No 5.3, but it's been working well for me on 5.4 i386.
> 

Thanks for your report. It's committed.
Regards,

-- 
Pierre-Emmanuel André 
GPG key: 0xBB8D3F0E