== PostgreSQL Weekly News - December 20 2015 ==
PostgreSQL 9.5RC1 released. Test!
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5
The annual Indian PGday will be held in Bengaluru, Karnataka, India on
February 26, 2016. The CfP is open.
http://pgday.in
Nordic PGDay 2016 is a one day one track conference which will be held in
Helsinki, Finland, on March 17, 2016. The CfP is open.
http://2016.nordicpgday.org/
== PostgreSQL Jobs for December ==
http://archives.postgresql.org/pgsql-jobs/2015-12/
== PostgreSQL Local ==
PostgreSQL@SCaLE is a two day, two track event which takes place on Jan.
21-22, 2016, at Pasadena Convention Center, as part of SCaLE 14X.
https://www.socallinuxexpo.org/scale/14x/cfp
FOSDEM PGDay is a one day conference that will be held ahead of FOSDEM in
Brussels, Belgium, on Jan 29th, 2016. Details and CfP below:
http://fosdem2016.pgconf.eu/
Prague PostgreSQL Developer Day 2016 (P2D2 2016) is a two-day conference
that will be held on February 17-18 2016 in Prague, Czech Republic.
Czech language web site below:
http://www.p2d2.cz/
The first pan-Asian PostgreSQL conference will be held March 2016 in
Singapore. The CfP is open.
http://2016.pgday.asia/
PGConf US 2016 will take place April 18-20, 2016 in NYC. The CfP is
open until January 31st, 2016, 11:59pm EST.
http://www.pgconf.us/2016/
PGCon 2016 will be held May 17-21, 2016 in Ottawa. The CfP is out.
http://www.pgcon.org/
== PostgreSQL in the News ==
Planet PostgreSQL: http://planet.postgresql.org/
PostgreSQL Weekly News is brought to you this week by David Fetter
Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to da...@fetter.org, German language
to p...@pgug.de, Italian language to p...@itpug.org. Spanish language
to p...@arpug.com.ar.
== Applied Patches ==
Andres Freund pushed:
- Correct statement to actually be the intended assert statement.
e3f4cfc7 introduced a LWLockHeldByMe() call, without the
corresponding Assert() surrounding it. Spotted by Coverity.
Backpatch: 9.1+, like the previous commit
http://git.postgresql.org/pg/commitdiff/2a3544960eaa114d34e5e83ab19e180c8efcd299
- Fix bug in SetOffsetVacuumLimit() triggered by
find_multixact_start() failure. Previously, if
find_multixact_start() failed, SetOffsetVacuumLimit() would install
0 into MultiXactState->offsetStopLimit if it previously succeeded.
Luckily, there are no known cases where find_multixact_start() will
return an error in 9.5 and above. But if it were to happen, for
example due to filesystem permission issues, it'd be somewhat bad:
GetNewMultiXactId() could continue allocating mxids even if close to
a wraparound, or it could erroneously stop allocating mxids, even if
no wraparound is looming. The wrong value would be corrected the
next time SetOffsetVacuumLimit() is called, or by a restart.
Reported-By: Noah Misch, although this is not his preferred fix
Discussion: 20151210140450.ga22...@alap3.anarazel.de Backpatch: 9.5,
where the bug was introduced as part of 4f627f
http://git.postgresql.org/pg/commitdiff/cca705a5d93446e1a9c775b94c7d5900986c0488
- Fix tab completion for ALTER ... TABLESPACE ... OWNED BY.
Previously the completion used the wrong word to match 'BY'. This
was introduced brokenly, in b2de2a. While at it, also add completion
of IN TABLESPACE ... OWNED BY and fix comments referencing
nonexistent syntax. Reported-By: Michael Paquier Author: Michael
Paquier and Andres Freund Discussion:
CAB7nPqSHDdSwsJqX0d2XzjqOHr==HdWiubCi4L=zs7yftun...@mail.gmail.com
Backpatch: 9.4, like the commit introducing the bug
http://git.postgresql.org/pg/commitdiff/130d94a7b868f5b6df512e5fde94a64e5e71178b
Heikki Linnakangas pushed:
- Fix out-of-memory error handling in ParameterDescription message
processing. If libpq ran out of memory while constructing the
result set, it would hang, waiting for more data from the server,
which might never arrive. To fix, distinguish between out-of-memory
error and not-enough-data cases, and give a proper error message
back to the client on OOM. There are still similar issues in
handling COPY start messages, but let's handle that as a separate
patch. Michael Paquier, Amit Kapila and me. Backpatch to all
supported versions.
http://git.postgresql.org/pg/commitdiff/7b96bf445a42b1cb2a435854f9825c38253f79a2
Kevin Grittner pushed:
- Remove xmlparse(document '') test This one test was behaving
differently between the ubuntu fix for CVE-2015-7499 and the base
"expected" file. It's not worth having yet another version of the
expected file for this test, so drop it. Perhaps at some point when
all distros have settled down to the same behavior on this test, it
can be restored. Problem found by me on libxml2
(2.9.1+dfsg1-3ubuntu4.6). Solution suggested by Tom Lane.
Backpatch to 9.5, where the test was added.