Nouvelles hebdomadaires de PostgreSQL - 27 juin 2010

PostgreSQL est à la recherche de citations/témoignages pour la publication de la version 9.0. Si vous attendez avec impatience une ou plusieurs des fonctionnalités de la 9.0, et que vous représentez une entreprise ou une organisation gouvernementale ou non, envoyez-nous s'il vous plait votre participation à josh@postgresql.org.

PGXN, le "PostgreSQL Extension Network", inspiré du CPAN, a été lancé : http://www.pgxn.org/

Les nouveautés des produits dérivés

• Slony-I 2.0.4, un système de réplication-en-cascade-maître-à-multiples-esclaves pour PostgreSQL : http://www.slony.info/
• Benetl 3.5, un outil d'ETL pour PostgreSQL, spécialisé dans les fichiers : http://www.benetl.net
• Muldis-D 0.130.0, une spécification pour un langage objet-relationnel prévu pour utiliser, entre autres systèmes, PostgreSQL : http://muldis.com/Muldis_D.html

Offres d'emplois autour de PostgreSQL en juin

• Internationales : http://archives.postgresql.org/pgsql-jobs/2010-06/threads.php;
• Francophones : http://forums.postgresql.fr/viewforum.php?id=4.

PostgreSQL Local

• CHAR(10), la conférence PostgreSQL dédiée au clustering, à la haute-disponibilité et à la réplication vient d'ouvrir les inscriptions en ligne et les réservations. 2 & 3 juillet 2010, Oriel College, Université d'Oxford (Royaume-Uni) : http://www.char10.org/
• Le PDXPUG Day est programmé pour le 18 juillet 2010 à "l'Oregon Convention Center" à Portland. D'avantage d'informations : http://wiki.postgresql.org/wiki/PDXPUGDay2010
• L'OSCON aura lieu à Portland (Oregon) du 19 au 23 juillet 2010 : http://www.oscon.com/oscon2010
• La FrOSCon 2010 aura lieu à St. Augustin, Allemagne les 21 & 22 août 2010. Le PUG allemand a obtenu sa propre salle de dev. et est à la recherche de conférenciers. Plus de détails : http://andreas.scherbaum.la/blog/archives/711-FrOSCon-2010-PostgreSQL-devroom-Call-for-papers.html

PostgreSQL dans les média

• Planet PostgreSQL : http://planet.postgresql.org/
• Planet PostgreSQLFr : http://planete.postgresql.fr/

PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter. Traduction par l'équipe PostgreSQLFr sous licence CC BY-NC-SA.

Proposez vos articles ou annonces avant dimanche 15:00 (heure du Pacifique). Merci de les envoyer en anglais à david (a) fetter.org, en allemand à pwn (a) pgug.de, en italien à pwn (a) itpug.org et en espagnol à pwn (a) arpug.com.ar.

(lien vers l'article original)

Correctifs appliqués

Heikki Linnakangas a commité :

• In pgsql/src/pl/plpgsql/src/pl_exec.c, in a PL/pgSQL "FOR cursor" statement, the statements executed in the loop might close the cursor, rendering the Portal pointer to it invalid. Closing the cursor in the middle of the loop is not a very sensible thing to do, but we must handle it gracefully and throw an error instead of crashing.

Robert Haas a commité :

• Minor markup improvements for Hot Standby documentation.
• Deprecate the use of => as an operator name. In HEAD, emit a warning when an operator named => is defined. In both HEAD and the backbranches (except in 8.2, where contrib modules do not have documentation), document that hstore's text => text operator may be removed in a future release, and encourage the use of the hstore(text, text) function instead. This function only exists in HEAD (previously, it was called tconvert), so backpatch it back to 8.2, when hstore was added. Per discussion.
• In pgsql/contrib/hstore/expected/hstore.out, updated expected-output file for hstore. This is an oversight in my previous patch to deprecate => as an operator name. Per buildfarm.
• Add TCP keepalive support to libpq. This adds four additional connection parameters to libpq: keepalives, keepalives_idle, keepalives_count, and keepalives_interval. keepalives default to on, per discussion, but can be turned off by specifying keepalives=0. The remaining parameters, where supported, can be used to adjust how often keepalives are sent and how many can be lost before the connection is broken. The immediate motivation for this patch is to make sure that walreceiver will eventually notice if the master reboots without closing the connection cleanly, but it should be helpful in other cases as well. Tollef Fog Heen, Fujii Masao, and me.
• In pgsql/src/backend/postmaster/postmaster.c, add stray "else" that seems to have gone missing.
• In pgsql/doc/src/sgml/release-9.0.sgml, further 9.0 release notes updates. Josh Berkus.
• In pgsql/doc/src/sgml/high-availability.sgml, some copy-editing of the Hot Standby documentation. Thanks to Joshua Tolley for the review.
• In pgsql/doc/src/sgml/installation.sgml, make AIX suggestions about disabling ipv6 more version-sensitive. Chris Browne, based on a report from John Pierce.
• In pgsql/doc/src/sgml/libpq.sgml, rewrite docs for new libpq keepalive parameters. The revised documentation makes it more clear that these are client-side parameters, rather than server side parameters. It also puts the main point of each parameter first, and consolidates the conditions under which it might be ignored in a single list at the end.

Bruce Momjian a commité :

• In pgsql/doc/src/sgml/ref/pg_ctl-ref.sgml, update pg_ctl docs to explain server output behavior differences on win32 and non-win32 platforms.
• Fix pg_upgrade's use of pg_ctl on Win32 to not send command and sever output to the same file, because it is impossible. Also set user name for pg_dumpall in pg_upgrade.
• Add username designations to all pg_upgrade utility calls that support it.
• In pgsql/doc/src/sgml/ref/alter_table.sgml, mention that when alter rewrites a table, indexes are also rebuilt.

Simon Riggs a commité :

• Fix log_temp_files docs and comments to say bytes not kilobytes. stat(2) field st_size returns bytes not kilobytes. Bug found during recent performance tuning for PostgreSQL user.

Tom Lane a commité :

• Fix thinko in tok_is_keyword(): it was looking at the wrong union variant of YYSTYPE, and hence returning the wrong answer for cases where a plpgsql "unreserved keyword" really does conflict with a variable name. Obviously I didn't test this enough :-(. Per bug #5524 from Peter Gagarinov.
• In pgsql/src/bin/pg_dump/pg_backup_custom.c, fix pg_restore so parallel restore doesn't fail when the input file doesn't contain data offsets (which it won't, if pg_dump thought its output wasn't seekable). To do that, remove an unnecessarily aggressive error check, and instead fail if we get to the end of the archive without finding the desired data item. Also improve the error message to be more specific about the cause of the problem. Per discussion of recent report from Igor Neyman. Back-patch to 8.4 where parallel restore was introduced.

Correctifs rejetés (à ce jour)

• Pas de déception cette semaine :-)

Correctifs en attente

• Guillaume Lelarge sent in a patch to add a CHECK_FOR_INTERRUPTS call to the copy_relation_data(), copy_dir(), and copy_file() functions, which fixes an issue where cancelling ALTER TABLE ... SET TABLESPACE and ALTER DATABASE ... SET TABLESPACE did not work.
• Heikki Linnakangas sent in a patch to fix an issue where the server would crash while trying to read an expression using pg_get_expr().
• Andrew Dunstan sent in a WIP patch to make ENUMs alterable.
• Kevin Grittner sent in a cleaned-up version of the patch to allow dividing money by money.
• Peter Eisentraut sent in a patch to make PostgreSQL compile under clang.
• Peter Eisentraut sent in another revision of the patch which allows ommission of non-aggregate columns in certain situations in GROUP BY.
• Pavel Baros sent in a patch to implement materialized views.
• Robert Haas sent in a patch to simplify emode_for_corrupt_record.
• Mark Fowler sent in another revision of the patch to add an xpath_exists function.
• Mark Fowler sent in another revision of the patch to add XMLEXISTS to the grammar.
• Robert Haas sent in a patch to allow suppressing crash recovery after a crash, per discussion on -performance about a volatile version of PostgreSQL.