Versions correctives 9.3.2, 9.2.6, 9.1.11, 9.0.15 et 8.4.19 disponibles. Mettez à jour à la première occasion : http://www.postgresql.org/about/news/1492/

La 7ème conférence annuelle "Prague PostgreSQL Developers Day" (P2D2) aura lieu le 6 février 2014 à la Faculté des Sciences Mathématiques & Physiques de l'Université Charles (Malostranske namesti 25, Prague). Infos en langue tchèque ci-après. L'appel à conférenciers court jusqu'au 3 janvier 2014 : http://www.p2d2.cz/

Le PUG de Singapore, PUGS, s'est constitué. Informations : http://www.meetup.com/PUGS-Postgres-Users-Group-Singapore/

Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en décembre

PostgreSQL Local

PostgreSQL dans les média

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

Robert Haas a poussé :

Tom Lane a poussé :

Bruce Momjian a poussé :

Peter Eisentraut a poussé :

  • doc: Refine documentation about recovery command exist status. Add more documentation about how different exit codes and signals are handled in each case. Reviewed-by: Peter Geoghegan <pg@heroku.com> http://git.postgresql.org/pg/commitdiff/95e3d50539afcdcd4b75b4ac5baa9f8fc05324d9
  • Report exit code from external recovery commands properly. When an external recovery command such as restore_command or archive_cleanup_command fails, report the exit code properly, distinguishing signals and normal exists, using the existing wait_result_to_str() facility, instead of just reporting the return value from system(). Reviewed-by: Peter Geoghegan <pg@heroku.com> http://git.postgresql.org/pg/commitdiff/fef88b3fdaa3537c64e3d7df9261bc75ece80d3f
  • Fix whitespace http://git.postgresql.org/pg/commitdiff/dfd5151c5800448a2be521797f95e1aa63d87b67
  • SSL: Add configuration option to prefer server cipher order. By default, OpenSSL (and SSL/TLS in general) lets the client cipher order take priority. This is OK for browsers where the ciphers were tuned, but few PostgreSQL client libraries make the cipher order configurable. So it makes sense to have the cipher order in postgresql.conf take priority over client defaults. This patch adds the setting "ssl_prefer_server_ciphers" that can be turned on so that server cipher order is preferred. Per discussion, this now defaults to on. From: Marko Kreen <markokr@gmail.com> Reviewed-by: Adrian Klaver <adrian.klaver@gmail.com> http://git.postgresql.org/pg/commitdiff/ef3267523d1ecf53bb6d4ffbeb6a0ae1af84ed47
  • SSL: Support ECDH key exchange. This sets up ECDH key exchange, when compiling against OpenSSL that supports Emmanuel Cecchet. Then the ECDHE-RSA and ECDHE-ECDSA cipher suites can be used for SSL connections. The latter one means that Emmanuel Cecchet keys are now usable. The reason for Emmanuel Cecchet key exchange is that it's faster than DHE and it allows to go to higher security levels where RSA will be horribly slow. There is also new GUC option ssl_ecdh_curve that specifies the curve name used for ECDH. It defaults to "prime256v1", which is the most common curve in use in HTTPS. From: Marko Kreen <markokr@gmail.com> Reviewed-by: Adrian Klaver <adrian.klaver@gmail.com> http://git.postgresql.org/pg/commitdiff/3164721462d547fa2d15e2a2f07eb086a3590fd5

Heikki Linnakangas a poussé :

  • Fix full-page writes of internal GIN pages. Insertion to a non-leaf GIN page didn't make a full-page image of the page, which is wrong. The code used to do it correctly, but was changed (commit 853d1c3103fa961ae6219f0281885b345593d101) because the redo-routine didn't track incomplete splits correctly when the page was restored from a full page image. Of course, that was not right way to fix it, the redo routine should've been fixed instead. The redo-routine was surreptitiously fixed in 2010 (commit 4016bdef8aded77b4903c457050622a5a1815c16), so all we need to do now is revert the code that creates the record to its original form. This doesn't change the format of the WAL record. Backpatch to all supported versions. http://git.postgresql.org/pg/commitdiff/22122c83f1331d03e8317afbfcfbb65bef9c82d2
  • Don't include unused space in LOG_NEWPAGE records. This is the same trick we use when taking a full page image of a buffer passed to XLogInsert. http://git.postgresql.org/pg/commitdiff/9e857436ef7dff8fb8a0bf43cfe62650e2be6be9

Alvaro Herrera a poussé :

  • Avoid resetting Xmax when it's a multi with an aborted. update HeapTupleSatisfiesUpdate can very easily "forget" tuple locks while checking the contents of a multixact and finding it contains an aborted update, by setting the HEAP_XMAX_INVALID bit. This would lead to concurrent transactions not noticing any previous locks held by transactions that might still be running, and thus being able to acquire subsequent locks they wouldn't be normally able to acquire. This bug was introduced in commit 1ce150b7bb; backpatch this fix to 9.3, like that commit. This change reverts the change to the delete-abort-savept isolation test in 1ce150b7bb, because that behavior change was caused by this bug. Noticed by Andres Freund while investigating a different issue reported by Noah Misch. http://git.postgresql.org/pg/commitdiff/07aeb1fec571920839822c11851d38ef48952d6c
  • Fix improper abort during update chain locking. In 247c76a98909, I added some code to do fine-grained checking of MultiXact status of locking/updating transactions when traversing an update chain. There was a thinko in that patch which would have the traversing abort, that is return HeapTupleUpdated, when the other transaction is a committed lock-only. In this case we should ignore it and return success instead. Of course, in the case where there is a committed update, HeapTupleUpdated is the correct return value. A user-visible symptom of this bug is that in REPEATABLE READ and SERIALIZABLE transaction isolation modes spurious serializability errors can occur: ERROR: could not serialize access due to concurrent update In order for this to happen, there needs to be a tuple that's key-share- locked and also updated, and the update must abort; a subsequent transaction trying to acquire a new lock on that tuple would abort with the above error. The reason is that the initial FOR KEY SHARE is seen as committed by the new locking transaction, which triggers this bug. (If the UPDATE commits, then the serialization error is correctly reported.) When running a query in READ COMMITTED mode, what happens is that the locking is aborted by the HeapTupleUpdated return value, then EvalPlanQual fetches the newest version of the tuple, which is then the only version that gets locked. (The second time the tuple is checked there is no misbehavior on the committed lock-only, because it's not checked by the code that traverses update chains; so no bug.) Only the newest version of the tuple is locked, not older ones, but this is harmless. The isolation test added by this commit illustrates the desired behavior, including the proper serialization errors that get thrown. Backpatch to 9.3. http://git.postgresql.org/pg/commitdiff/312bde3d404f770943c992992565c73f0336d21b

Fujii Masao a poussé :

Magnus Hagander a poussé :

Joe Conway a poussé :

  • Fix performance regression in dblink connection speed. Previous commit e5de601267d98c5d60df6de8d436685c7105d149 modified dblink to ensure client encoding matched the server. However the added PQsetClientEncoding() call added significant overhead. Restore original performance in the common case where client encoding already matches server encoding by doing nothing in that case. Applies to all active branches. Issue reported and work sponsored by Zonar Systems. http://git.postgresql.org/pg/commitdiff/d6ca510d9dbacceb3444f00fcfbba2c80dca4c8f

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Brar Piening sent in a patch to enable Microsoft Visual Studio 2013 as additional build environment.
  • Sergey Muraviov sent in a patch to help psql display wide tables more legibly.
  • Zoltan Boszormenyi and Antonin Houska traded patches to allow backup throttling.
  • Amit Kapila and Haribabu Kommi traded patches to reduce WAL for update operations.
  • Heikki Linnakangas sent in a patch to optimize log_newpage by leaving out unused space from the block.
  • Marko Kreen sent in a patch to allow using TLSv1.1+ in libpq.
  • Stas Kelvich sent in another revision of a patch to add KNN support to the cube extension.
  • SAKAMOTO Masahiko sent in another revision of a patch to allow forcing a WAL log when setting a hint bit.
  • MauMau sent in two revisions of a patch to place DLLs in the bin folder for ECPG on Windows.
  • Tom Lane sent in a patch intended to bridge the gap between ruleutils and empty targetlists.
  • Etsuro Fujita sent in another revision of a patch to get more out of indexes via pathkeys and unique indexes.
  • MauMau sent in two revisions of a patch to fix an issue where "pg_ctl stop" times out when it should respond quickly.
  • Fabrízio de Royes Mello sent in two more revisions of a patch to enable creating time-delayed standbys.
  • KaiGai Kohei and Shigeru HANADA traded patches implementing (and fixing typos in) a custom scan API.
  • MauMau sent in a patch to fix a bug where psql's \conninfo reports an incorrect destination on Windows.
  • Andres Freund sent in another flock of patches for logical changesets.
  • Zoltan Boszormenyi sent in another revision of a patch to implement ECPG readahead.
  • Zoltan Boszormenyi sent in two more revisions of a patch to fix the ECPG infrastructure.
  • Peter Geoghegan sent in a patch to do some performance optimization of btree binary search.
  • Michael Paquier sent in a patch to fix a bug where regression tests fail if not launched on a database itself called "regression."
  • Kevin Grittner sent in a patch to fix a pg_archivecleanup issue.
  • Antonin Houska sent in a patch to reference to a parent query from ANY sublink.
  • MauMau sent in a patch to fix an issue where pg_ctl fails with config-only directory on Windows.
  • Dr. Andreas Kunert sent in three revisions of a patch to allow logging SSL connections.
  • MauMau sent in two revisions of a patch to fix an issue on Windows where pg_ctl always used the same event source.
  • MauMau sent in a patch to allow a client-only installation on Windows.
  • Andres Freund sent in a patch to add %z ((s)size_t) support to elog/ereport.
  • Pavel Stehule and Dean Rasheed traded more revisions of the patch to add DROP ... IF EXISTS ... in the current places where that construct makes sense.