Nouvelles hebdomadaires de PostgreSQL - 6 juin 2010

Le 11 juin 2010, Gabriele Bartolini (de 2^ndQuadrant Italia) interviendra lors de la conférence italienne sur les Logiciels Libres à Cagliari, Sardaigne ; intervention titrée "High Availability of business databases with PostgreSQL" [ndt: Haute Disponibilité de bases de données d'entreprises avec PostgreSQL] : http://www.confsl.org/

Le 12 juin 2010, le PUG italien fera la promotion de PostgreSQL lors de la conférence italienne sur les Logiciels Libres à Cagliari, Sardaigne avec une journée entière d'ateliers autour de PostgreSQL allant d'une "Introduction" à la "Haute Disponibilité" : http://www.confsl.org/

Les nouveautés des produits dérivés

• ChronicDB v2.2.2, un outil de déploiement de schéma : http://chronicdb.com

Offres d'emplois autour de PostgreSQL en juin

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

PostgreSQL Local

• La "Southeast Linuxfest 2010" aura lieu à Spartanburg (Caroline du Sud, États-Unis) du 11 au 13 juin. Nos PG-gourous Joshua Drake et Andrew Dunstan donneront des présentations à ne pas manquer : http://southeastlinuxfest.org/
• Conférence de Michael Renner au Netways OSDC à Nuremberg (All.) les 23 & 24 juin 2010 : http://www.netways.de/osdc/y2010/programm/
• 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

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/backend/replication/walsender.c, send all outstanding WAL before exiting when smart shutdown is requested. This was broken by my previous patch to send WAL in smaller batches. Patch by Fujii Masao.
• In pgsql/src/backend/access/transam/xlog.c, fix obsolete comments that I neglected to update in a previous patch. Fujii Masao.

Bruce Momjian a commité :

• In pgsql/doc/src/sgml/config.sgml, reword fsync and full_page_writes docs to be clearer about when to turn them off. Josh Berkus, with slight wording changes by me.
• In pgsql/src/pl/plpgsql/src/pl_exec.c, add error hint that PL/pgSQL "EXECUTE of SELECT ... INTO" can be performed by "EXECUTE ... INTO". Jaime Casanova.
• In pgsql/doc/src/sgml/docguide.sgml, document how to find TeX overflow boxes in our documentation build, per details from Alvaro Herrera.
• In pgsql/doc/src/sgml/docguide.sgml, update TeX overflow documentation page pattern mask, in docs.
• In pgsql/doc/src/sgml/docguide.sgml, overflow box is on page after listed page number, per Alvaro.
• In pgsql/src/backend/commands/indexcmds.c, show schema name for REINDEX. Greg Sabino Mullane.
• In pgsql/doc/src/sgml/extend.sgml, add documentation section "Using C++ for Extensibility". Craig Ringer
• In pgsql/doc/src/sgml/extend.sgml, fix SGML markup for tag title.
• In pgsql/doc/src/sgml/extend.sgml, mention palloc/pfree for C++ memory allocation in docs.
• Comment out C++ docs for later user. Tone down C++ compatibility in 9.0 release notes.
• In pgsql/doc/src/sgml/release-9.0.sgml, update C++ release note item wording.
• In pgsql/doc/src/sgml/func.sgml, document that && geometric operator is true even if only a point overlaps. David Fetter.
• In pgsql/doc/src/sgml/func.sgml, clarify array generate_subscripts() documentation example. Tim Landscheidt.
• In pgsql/doc/src/sgml/citext.sgml, document that citext operators must be in the current search path.
• In pgsql/doc/src/sgml/extend.sgml, document use of C++ for extension use.
• In pgsql/doc/src/sgml/func.sgml, document regexp_matches() better and show example of single-row usage.
• In pgsql/doc/src/sgml/extend.sgml, markup fix.
• In pgsql/doc/src/sgml/release-9.0.sgml, update 9.0 release notes to current.
• In pgsql/doc/src/sgml/release-9.0.sgml, fix CREATE TRIGGER release mention, WHERE -> WHEN.

Alvaro Herrera a commité :

• In pgsql/doc/src/sgml/ref/reassign_owned.sgml, add note about database ownership to REASSIGN OWNED command documentation, per Josh Berkus. Add ALTER DATABASE to the "see also" section, too.
• In pgsql/src/include/catalog/pg_control.h, add comments about definitions that may affect PG_CONTROL_VERSION, per recent unintended-initdb-forcing fiasco

Andrew Dunstan a commité :

• In pgsql/src/tools/msvc/vcregress.pl, run recently backported plperlu_plperl regression tests when building with MSVC on releases 8.4 and 8.3. Regression tests weren't supported before that.
• In pgsql/src/tools/msvc/vcregress.pl, fix regression test name for plperlu_plperl in msvc.

Robert Haas a commité :

• On clean shutdown during recovery, don't warn about possible corruption. Fujii Masao. Review by Heikki Linnakangas and myself.

ITAGAKI Takahiro a commité :

• In pgsql/contrib/dblink/dblink.c, fix dblink to treat connection names longer than NAMEDATALEN-2 (62 bytes). Now long names are adjusted with truncate_identifier() and NOTICE messages are raised if names are actually truncated. Backported to release 8.0.
• Replace "slave" to "standby" in documentation for consistent terminology. Almost all of the terms in docs and messages were replaced, but still remains in a few comments and README files in codes.
• Ensure default-only storage parameters for TOAST relations to be initialized with proper values. Affected parameters are fillfactor, analyze_threshold, and analyze_scale_factor. Especially uninitialized fillfactor caused inefficient page usage because we built a StdRdOptions struct in which fillfactor is zero if any reloption is set for the toast table. In addition, we disallow toast.autovacuum_analyze_threshold and toast.autovacuum_analyze_scale_factor because we didn't actually support them; they are always ignored. Report by Rumko on pgsql-bugs on 12 May 2010. Analysis by Tom Lane and Alvaro Herrera. Patch by me. Backpatch to 8.4.

Tom Lane a commité :

• In pgsql/src/include/catalog/pg_control.h, bump PG_CONTROL_VERSION to account for the incompatible change committed earlier.
• In pgsql/doc/src/sgml/release-9.0.sgml, remove link that breaks HISTORY file generation.
• Add current WAL end (as seen by walsender, ie, GetWriteRecPtr() result) and current server clock time to Streaming Replication data messages. These are not currently used on the slave side but seem likely to be useful in future, and it'd be better not to change the Streaming Replication protocol after release. Per discussion. Also do some minor code review and cleanup on walsender.c, and improve the protocol documentation.
• In pgsql/src/backend/replication/walsender.c, adjust misleading comment in walsender.c. We try to send all WAL data that's been written out from shared memory, but the previous phrasing might be read to say that we send only what's been fsync'd.
• In pgsql/doc/src/sgml/func.sgml, improve our explanation of the OVERLAPS operator. Per gripe from Frank van Vugt.

Peter Eisentraut a commité :

• Fix some inconsistent quoting of wal_level values in messages.
• Translation updates for 9.0beta2.
• When referring to postgresql.conf syntax, then it's without quotes (wal_level=archive); in narrative it's with double quotes. But never single quotes.
• In pgsql/src/backend/libpq/hba.c, fix reference to nonexistent configure option --enable-ssl -> --with-openssl

Marc Fournier a commité :

• Tag 9.0beta2.

Michael Meskes a commité :

• Added variable handling for RETURNING clause to ecpg. While the values were correctly returned they were not moved into C variables as they should be. Closes: Bug #5489.

Correctifs rejetés (à ce jour)

• Bruce Momjian's patches to allow setting wal_keep_segments to -1, which would mean, "never get rid of any." This was agreed not to be a good idea.
• Pavel Stehule's patch to add new custom GUCs for date and time formats. Too many GUCs.

Correctifs en attente

• Fujii Masao sent in three patches to fix streaming replication.
• Jan Urbanski and Tom Lane traded patches to fix tsvector stats.
• Peter Eisentraut sent in a patch to allow a client to authenticate a server over unix-domain sockets.
• Tom Lane sent in a WIP patch to fix some some misbehavior on INSERT-only tables.
• Andy Balholm sent in a WIP patch to allow dividing money by money.
• Daniele Varrazzo sent in a patch to implement a regexp_match() function which returns an array rather than a SETOF matches as regexp_matches() does.
• KaiGai Kohei sent two different patches intended to close some information leaks in VIEWs.
• Dean Rasheed sent in a patch to fix the docs for ALTER TABLE ... DISABLE/ENABLE TRIGGER. They are out of date.