== PostgreSQL Weekly News - April 19 2015 ==
== PostgreSQL Product News ==
Ora2PG 15.2, a migration system for moving from Oracle to PostgreSQL, released.
http://ora2pg.darold.net/
pgBadger 6.4, a parallel PostgreSQL log analyzer written in Perl, released:
https://sourceforge.net/projects/pgbadger/
Development:
https://github.com/dalibo/pgbadger/
pgFormatter v1.4, a SQL formatter/beautifier which supports keywords
from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL
keywords are not in the standard, released.
http://sqlformat.darold.net/
pg_monz v2.0, a Zabbix template for monitoring PostgreSQL, released.
http://pg-monz.github.io/pg_monz/index-en.html
== PostgreSQL Jobs for April ==
http://archives.postgresql.org/pgsql-jobs/2015-04/threads.php
== PostgreSQL Local ==
The 4th Turkish PostgreSQL Conference will be held on May 9, 2015 in
Istanbul.
http://pgday.postgresql.org.tr/en/index.html
The second Swiss Postgres Conference will be held June 25-26, 2015 at
HSR Rapperswil.
http://www.postgres-conference.ch/
There is a Postgres track in a database technology conference(DTCC) in
April 18, 2015 in Beijing, China.
http://dtcc.it168.com/list_jiabin.html
pgDay Paris will be held in Paris France on April 21, 2015.
http://pgday.paris/
Call for Papers for PGDay in Belfort, France ends April 13, 2015.
The conference will be held June 2, 2015.
http://select-2-6-2015-as-pgday.org
PGCon 2015 is June 16-20 in Ottawa, Canada.
http://www.pgcon.org/2015/
PGDay UK, Conference will be taking place on 7th July 2015 – it is aimed at
the UK PostgreSQL Community. The CfP is open until 13 April 2015.
http://www.postgresqlusergroup.org.uk
The Call For Papers for PostgresOpen 2015, being held in Dallas, Texas
from September 16th to 18th, is now open.
http://2015.postgresopen.org/callforpapers/
== 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 ==
Peter Eisentraut pushed:
- emacs: Set indent-tabs-mode in perl-mode This matches existing
practice, but makes the setup complete and consistent with the C
code setup.
http://git.postgresql.org/pg/commitdiff/442663f133f1caec51919402463e6e31362baee3
- Move pgbench from contrib/ to src/bin/. Reviewed-by: Michael
Paquier michael.paqu...@gmail.com
http://git.postgresql.org/pg/commitdiff/81134af3ec09d67043833f8d614fd688f17cb213
- pgbench: Attempt fix build on Windows
http://git.postgresql.org/pg/commitdiff/d577bb868dfb595aa8df95974cd1c79e1baba924
- Move pg_upgrade from contrib/ to src/bin/. Reviewed-by: Michael
Paquier michael.paqu...@gmail.com
http://git.postgresql.org/pg/commitdiff/9fa8b0ee90c44c0f97d16bf65e94322988c94864
- Integrate pg_upgrade_support module into backend. Previously, these
functions were created in a schema binary_upgrade, which was
deleted after pg_upgrade was finished. Because we don't want to
keep that schema around permanently, move them to pg_catalog but
rename them with a binary_upgrade_... prefix. The provided
functions are only small wrappers around global variables that were
added specifically for pg_upgrade use, so keeping the module
separate does not create any modularity. The functions still check
that they are only called in binary upgrade mode, so it is not
possible to call these during normal operation. Reviewed-by:
Michael Paquier michael.paqu...@gmail.com
http://git.postgresql.org/pg/commitdiff/30982be4e5019684e1772dd9170aaa53f5a8e894
Fujii Masao pushed:
- Silence gettext warning about '\r' escape sequence in translatable
string. gettext was unhappy about the commit b216ad7 because it
revealed the problem that internationalized messages may contain
'\r' escape sequence in pg_rewind. This commit moves '\r' to a
separate printf() call. Michael Paquier, bug reported by Peter
Eisentraut
http://git.postgresql.org/pg/commitdiff/1f94bec7a9e3e6b4fa5468236cf531fec16d1093
Heikki Linnakangas pushed:
- Refactor and fix TAP tests of pg_rewind * Don't pass arguments to
prove, since that's not supported on perl 5.8 which is the minimum
version supported by the TAP tests. Refactor the test files
themselves to run the tests twice, in both local and remote mode. *
Use eq rather than == for string comparison. This thinko caused the
remote versions of the tests to never run. * Add use strict and
use warnings, and fix warnings that that produced. * Increase the
delay after standby promotion, to make the tests more robust. * In
remote mode, the connection string to the promoted standby was
incorrect, leading to connection errors. Patch by Michael Paquier,
to address Peter Eisentraut's report.
