Nouvelles hebdomadaires de PostgreSQL - 28 février 2010

PostgreSQL 9.0alpha4 est disponible. À vos tests ! Détails et téléchargement : http://www.postgresql.org/developer/alpha http://www.postgresql.org/ftp/source/9.0alpha4

Les inscriptions pour la PGCon 2010 sont ouvertes : http://www.pgcon.org/2010/registration.php

Le BWPUG [ndt: Baltimore/Washington PUG] se réunira à Falls Church (Virginie, États-Unis) le 10 mars à 18h30 : http://www.xzilla.net/blog/2010/Feb/BWPUG-March-10th,-Falls-Church-take-two..html

L'appel aux conférenciers pour l'OSBridge est lancé ! http://opensourcebridge.org/events/2010/proposals/

Les nouveautés des produits dérivés

• "The Karoo Project", une plateforme de développement pour applications PostgreSQL distribuées, propose maintenant un ensemble de widgets pour les interfaces web : http://www.zwartberg.com/widgets.html
• pgFouine 1.2, un analyseur de log pour PostgreSQL écrit en PHP : http://pgfouine.projects.postgresql.org/

La fonctionnalité 9.0 de la semaine

La suite "pgbench" est maintenant multi-threadée, prenant ainsi avantage des processeurs à cœurs multiples.

Offres d'emplois autour de PostgreSQL en février

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

PostgreSQL Local

• Le PUG germanophone aura un stand dans le "Project Lounge" du hall 2 au Cebit 2010 du 2 au 6 mars 2010 à Hanovre : http://andreas.scherbaum.la/blog/archives/649-PostgreSQL-stand-at-Cebit-2010.html
• Le PUG allemand aura un stand aux Linuxdays de Chemnitz les 13 et 14 mars 2010. Andreas (ads) Scherbaum y donnera une conférence sur PostgreSQL 9.0 et dirigera un atelier sur la configuration de PostgreSQL : http://andreas.scherbaum.la/blog/archives/652-PostgreSQL-stand-at-Chemnitz-Linux-Days-2010.html http://chemnitzer.linux-tage.de/2010/vortraege/plan.html
• La "JDCon East" aura lieu à Philadelphie (Pennsylvanie, États-Unis) du 25 au 28 mars 2010 : http://www.postgresqlconference.org/2010/east
• La "Linuxfest Northwest 2010" aura lieu à Bellingham, Washington, États-Unis les 24 et 25 avril. Conférences, réunions et mécénat sont proposables : http://linuxfestnorthwest.org/
• Andreas (ads) Scherbaum enseignera au centre pour adultes de Magdeburg (All.) du 3 au 7 mai 2010 sur le sujet "PostgreSQL for Corporate Use". Détails ci-dessous : http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Schulung-als-Bildungsurlaub-03.-07.05.2010-in-Magdeburg.html
• La PgCon 2010 aura lieu les 20 & 21 mai 2010 à Ottawa avec des tutoriels les 18 et 19. L'appel à conférenciers est lancé ! http://www.pgcon.org/2010/registration.php
• 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.

(lien vers l'article original)

Correctifs appliqués

Heikki Linnakangas a commité :

• Move documentation of all recovery.conf option to a new chapter. They used to be scattered between the "backup and restore" and "streaming replication" chapters.
• Fix streaming replication starting at the very first WAL segment. Per complaint from Greg Stark.
• In pgsql/doc/src/sgml/high-availability.sgml, small streaming replication document improvements. Be more explicit that it's asynchronous.
• In pgsql/doc/src/sgml/high-availability.sgml, fix typo. Fujii Masao.
• In pgsql/doc/src/sgml/recovery-config.sgml, clarify that the connection string for primary_conninfo is in the same format as in PQconnectdb(). As pointed out by Thom Brown.
• Document max_standby_delay=-1 option, now that it's allowed again.

Tom Lane a commité :

• In pgsql/src/backend/storage/file/fd.c, adjust pg_fsync_writethrough so that it will set errno when failing on a platform that doesn't support this operation. The former coding would allow an unrelated errno to be reported, which would be quite misleading. Not sure if this has anything to do with the current buildfarm failures, but it's certainly bogus as-is.
• In pgsql/src/port/copydir.c, let's try forcing errno to zero before issuing fsync. The current buildfarm results claiming EBADF seem improbable enough that I'm not convinced fsync is really returning that --- could it be failing to set errno at all?
• In pgsql/src/port/copydir.c, some platforms reject fsync() on files opened O_RDONLY.
• In pgsql/src/bin/pg_dump/pg_backup_tar.c, minor style policing for error messages in pg_dump tar code. Notably, change "dumping data out of order is not supported" to "restoring data out of order is not supported", because you get that error during pg_restore not pg_dump. Also fix some comments that didn't look so good after being pgindented as perhaps they did originally.
• In pgsql/doc/src/sgml/ref/pg_dump.sgml, clarify statements about tar archive format.
• Fix configure's regexp for extracting the Perl version number from perl -v output. Per bug #5339, Perl 5.11 has changed the format of that output enough to break the previous coding. Alex Hunsaker
• Add an OR REPLACE option to CREATE LANGUAGE. This operates in the same way as other CREATE OR REPLACE commands, ie, it replaces everything but the ownership and ACL lists of an existing entry, and requires the caller to have owner privileges for that entry. While modifying an existing language has some use in development scenarios, in typical usage all the "replaced" values come from pg_pltemplate so there will be no actual change in the language definition. The reason for adding this is mainly to allow programs to ensure that a language exists without triggering an error if it already does exist. This commit just adds and documents the new option. A followon patch will use it to clean up some unpleasant cases in pg_dump and pg_regress.
• In pgsql/src/test/regress/pg_regress.c, make pg_regress use CREATE OR REPLACE LANGUAGE, so that --load-language will work whether or not the specified language is preinstalled. This responds to some complaints about having to change test scripts because plpgsql is preinstalled as of 9.0.
• In pgsql/src/bin/pg_dump/pg_dump.c, use CREATE OR REPLACE LANGUAGE in pg_dump to avoid the need for a couple of significantly uglier kluges that were working around the change in plpgsql's preinstalled status.
• In pgsql/src/bin/pg_dump/pg_dump.c, un-break pg_dump for the case of zero-column tables. This was evidently broken by the CREATE TABLE OF TYPE patch. It would have been noticed if anyone had bothered to try dumping and restoring the regression database ...
• Fix patch for printing backend and pg_dump versions so that it works in a desirable fashion in archive-dump cases, ie you should get the pg_dump version not the pg_restore version.
• Allow zero-dimensional (ie, empty) arrays in contrib/ltree operations. The main motivation for changing this is bug #4921, in which it's pointed out that it's no longer safe to apply ltree operations to the result of ARRAY(SELECT ...) if the sub-select might return no rows. Before 8.3, the ARRAY() construct would return NULL, which might or might not be helpful but at least it wouldn't result in an error. Now it returns an empty array which results in a failure for no good reason, since the ltree operations are all perfectly capable of dealing with zero-element arrays. As far as I can find, these ltree functions are the only places where zero array dimensionality is rejected unnecessarily. Back-patch to 8.3 to prevent behavioral regression of queries that worked in older releases.
• In pgsql/src/backend/access/transam/xlog.c, make pg_stop_backup's reporting a bit more verbose in hopes of making error cases less intimidating for novices. Per discussion. Greg Smith.
• In pgsql/doc/src/sgml/plperl.sgml, improve warning about creating nested named subroutines in plperl. Per discussion.
• In pgsql/src/backend/optimizer/util/predtest.c, allow predicate_refuted_by() to deduce that NOT A refutes A. We had originally made the stronger assumption that NOT A refutes any B if B implies A, but this fails in three-valued logic, because we need to prove B is false not just that it's not true. However the logic does go through if B is equal to A. Recognizing this limited case is enough to handle examples that arise when we have simplified "bool_var = true" or "bool_var = false" to just "bool_var" or "NOT bool_var". If we had not done that simplification then the btree-operator proof logic would have been able to prove that the expressions were contradictory, but only for identical expressions being compared to the constants; so handling identical A and B covers all the same cases. The motivation for doing this is to avoid unexpected asymmetrical behavior when a partitioned table uses a boolean partitioning column, as in today's gripe from Dominik Sander. Back-patch to 8.2, which is as far back as predicate_refuted_by attempts to do anything at all with NOTs.
• Back-patch addition of ssl_renegotiation_limit into 7.4 through 8.1.
• In pgsql/src/backend/utils/mb/mbutils.c, undo some more pgindent breakage. Per buildfarm.
• Entity-ify a few new uses of literal <, >, and &.
• Insert a hack into get_float8_nan (both core and ecpg copies) to deal with the fact that NetBSD/mips is currently broken, as per buildfarm member pika. Also add regression tests to ensure that get_float8_nan and get_float4_nan are exercised even on platforms where they are not needed by float8in/float4in. Zoltan Boszormenyi and Tom Lane.
• Assorted code cleanup for contrib/xml2. No change in functionality, just make it a bit less ugly in places.
• Fix up memory management problems in contrib/xml2. Get rid of the code that attempted to funnel libxml2's memory allocations into palloc. We already knew from experience with the core xml datatype that trying to do this is simply not reliable. Unlike the core code, I did not bother adding a lot of PG_TRY/PG_CATCH logic to try to ensure that everything is cleaned up on error exit. Hence, we might leak some memory if one of these functions fails partway through. Given the deprecated status of this contrib module and the fact that errors partway through the functions shouldn't be too common, it doesn't seem worth worrying about. Also fix a separate bug in xpath_table, that it did the wrong things if given a result tuple descriptor with less than 2 columns. While such a case isn't very useful in practice, we shouldn't fail or stomp memory when it occurs. Add some simple regression tests based on all the reported crash cases that I have on hand. This should be back-patched, but let's see if the buildfarm likes it first.
• Back-patch changes of 2009-05-13 in xml.c's memory management to 8.3. I was afraid to do this when these changes were first made, but now that 8.4 has seen some field use it should be all right to back-patch. These changes are really quite necessary in order to give xml.c any hope of co-existing with loadable modules that also wish to use libxml2.

Bruce Momjian a commité :

• In pgsql/doc/src/sgml/backup.sgml, briefly document in two places that pg_dump and pg_dumpall cannot be used for continuous archiving.
• Use the term "bundled distribution" instead of "official distribution" in configure warnings.
• In pgsql/doc/src/sgml/protocol.sgml, remove protocol documentation paragraph about environment variable passing being "covered elsewhere", per Dave Page.
• Revert configure warning to use "official distribution".
• Document that pg_ctl cares about the PGHOST environment variable.
• In pgsql/doc/src/sgml/ref/create_table.sgml, remove long-commented-out paragraph in documentation about function inheritance in create table, per Andrew Dunstan.
• In pgsql/doc/src/sgml/ref/pg_restore.sgml, update pg_restore documentation to show new pg_restore custom listing format. Pavel Golub.
• Supress convertion of zero hours to '12' for intervals when using to_char with Hitoshi Harada, e.g. to_char(interval '0d 0h 12m 44s', 'DD HH24 MI SS'); now returns: '00 00 12 44' not: '00 12 12 44'.
• In pgsql/doc/src/sgml/ref/copy.sgml, make documentation more direct about the handling of COPY files based on the client encoding.
• In pgsql/src/backend/utils/adt/formatting.c, secondary patch to fix interval to_char() for "HH" where hours >= 12.
• Revert recent change of to_char('HH12') handling for intervals; instead improve documentation, and add C comment.
• In pgsql/doc/src/sgml/ref/copy.sgml, revert recent COPY manual change about encoding; add mention of "server".
• In pgsql/src/bin/pg_dump/pg_backup_archiver.c, have pg_dump (-v) verbose mode output the pg_dump and server versions in text output mode, like we do in custom output mode. Jim Cox
• Update startup scripts for Linux and FreeBSD. Kevin Grittner.
• In pgsql/contrib/start-scripts/freebsd, modify freebsd start script to just exit 0 with message.
• Remove pre-7.4 documentaiton mentions, now that 8.0 is the oldest supported release.
• Revert removal of pre-7.4 documenation behavior mentions.
• In pgsql/doc/src/sgml/ref/pg_restore.sgml, document that pg_restore -t can use -n for its schema qualification.
• In pgsql/doc/src/sgml/datatype.sgml, clearly document that timestamp alone means timestamp without timezone, per SQL standard, and mention 7.3 behavior at the end.
• In pgsql/src/backend/utils/adt/formatting.c, add C comment that do_to_timestamp() lacks error checking.
• In pgsql/doc/src/sgml/config.sgml, document clearly the meaning of none/all for log_statements.
• In pgsql/doc/src/sgml/ref/create_function.sgml, document that after triggers that need to see changed rows should not be marked stable.
• In pgsql/doc/src/sgml/datatype.sgml, remove 'emphasis' markup inside literal; not allowed.
• In pgsql/src/tools/pgindent/README, update pgindent instructions to avoid changes to flex output files.
• In pgsql/src/tools/pgindent/typedefs.pl, add pgindent typedefs file to CVS.
• pgindent run for 9.0.
• In pgsql/src/tools/pgindent/README, update pgindent instructions.
• In pgsql/doc/src/sgml/perform.sgml, document pg_restore --jobs as a performance enhancement.
• Call output file typedefs.list; update README.
• In pgsql/src/bin/scripts/vacuumdb.c in vacuumdb --help, call analyze "statistics", not "hints".
• In pgsql/src/tools/pgindent/README, document why pgindent wants a fresh CVS checkout.
• In pgsql/src/tools/pgindent/README, update pgindent docs to use maintainer-clean.
• In pgsql/src/tools/pgindent/README, wording improvements to README.
• Revert pgindent changes to ecpg include files that are part of ecpg regession test output, and update pgindent script to avoid them in the future.
• In pgsql/src/tools/pgindent/README, suggest gmake installcheck-world for pgindent testing.
• In pgsql/doc/src/sgml/wal.sgml, document ATAPI drive flush command, and mention SSD drives.
• In pgsql/doc/src/sgml/libpq.sgml, use <> for libpq #include in example programs, per suggestion from Josh Berkus.
• In pgsql/doc/src/sgml/config.sgml, document trace_recovery_messages() parameter as an enum, not string. Fujii Masao.
• Document ATAPI FLUSH CACHE EXT.
• In pgsql/src/backend/utils/adt/pg_locale.c, back out unintended change to pg_locale.c.
• Update complex locale example in the documentation.

ITAGAKI Takahiro a commité :

• In pgsql/contrib/dblink/dblink.c, remove useless codes to initialize TupleDesc from dblink_exec.

Alvaro Herrera a commité :

• In pgsql/doc/src/sgml/mvcc.sgml, remove stray semicolon, per report from Sandro (strk) Santilli strk AT keybit DOT net.

Magnus Hagander a commité :

• In pgsql/doc/src/sgml/plperl.sgml, fix typos, per Richard Huxton
• Add configuration parameter ssl_renegotiation_limit to control how often we do SSL session key renegotiation. Can be set to 0 to disable renegotiation completely, which is required if a broken SSL library is used (broken patches to CVE-2009-3555 a known cause) or when using a client library that can't do renegotiation. Back-patch to 8.2.

Michael Meskes a commité :

• Make sure ecpg uses the same header files in the same order as the backend.

Gregory Stark a commité :

• In pgsql/src/port/copydir.c, second try at fsyncing directories in CREATE DATABASE. Let's see what the build farm says of opening directories read-only and ignoring EBADF from fsync of directories.
• In pgsql/src/port/copydir.c, Add EPERM to the list of return codes to expect from opening directories based on Vista results

Correctifs rejetés (à ce jour)

• Pas de déception cette semaine :-)

Correctifs en attente

• Magnus Hagander sent in a patch to fix the SSL negotiation issue.
• Fujii Masao sent in a doc patch for Hot Standby.
• Simon Riggs sent in a patch to add a pg_abort_backup() function per discussion about Hot Standby/Streaming Replication.
• Gabrielle Roth sent in a doc patch explaining which statements get logged at different levels of log_level in postgresql.conf.
• Fujii Masao sent in a patch for streaming replication to use lastPageTLI instead of curFileTLI as the timeline of the last applied record.
• Teodor Sigaev sent in a patch against tsearch2 which allows for underscores.
• ITAGAKI Takahiro sent in a cleanup for the sequential scan code.
• Piyush Newe sent in a patch to change the error message thrown in ambiguous cases of the argument.function notation.
• Hiroshi Inoue and Bruce Momjian sent in patches to get to_char to do the right thing on Windows with UTF-8 encoding.