Nouvelles hebdomadaires de PostgreSQL - 8 décembre 2013
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
- DataFiller version 1.1.5, un générateur de données aléatoires pour PostgreSQL basé sur le schéma de la base + instructions : https://www.cri.ensmp.fr/people/coelho/datafiller.html
- pg8000 1.9.0, un connecteur en pur python, compatible DB-API 2.0, pour PostgreSQL. Driver : https://pypi.python.org/pypi/pg8000/ Docs : http://pythonhosted.org/pg8000/
- pg_activity 1.1.0 : https://github.com/julmon/pg_activity/
- Pyrseas 0.7.1, une boîte à outils pour la gestion de version sous PostgreSQL : https://github.com/pyrseas/Pyrseas
- sqlserver2pgsql, un utilitaire Perl basé sur Ketl d'aide à la conversion depuis MS-SQL : https://github.com/dalibo/sqlserver2pgsql
Offres d'emplois autour de PostgreSQL en décembre
- Internationales : http://archives.postgresql.org/pgsql-jobs/2013-12/threads.php
- Francophones : http://forums.postgresql.fr/viewforum.php?id=4.
PostgreSQL Local
- FOSDEM PGDay, une conférence d'une journée, tenue avant le FOSDEM à Bruxelles, aura lieu le 31 janvier 2014. Détails :
http://fosdem2014.pgconf.eu/
L'appel à conférenciers se termine le 15 décembre 2013 : http://fosdem2014.pgconf.eu/callforpapers/
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
Robert Haas a poussé :
- Avoid out-of-bounds read in errfinish if error_stack_depth < 0. If errordata_stack_depth < 0, we won't find that out and correct the problem until CHECK_STACK_DEPTH() is invoked. In the meantime, elevel will be set based on an invalid read. This is probably harmless in practice, but it seems cleaner this way. Xi Wang http://git.postgresql.org/pg/commitdiff/9d140f7be2836e3baf6c9dc7989dea69ef693532
- Make NUM_TOCHAR_prepare and NUM_TOCHAR_finish macros declare "len". Remove the variable from the enclosing scopes so that nothing can be relying on it. The net result of this refactoring is that we get rid of a few unnecessary strlen() calls. Original patch from Greg Jaskiewicz, substantially expanded by me. http://git.postgresql.org/pg/commitdiff/a8656a3ab02db5b1de0d696dc8cf588efe7c1341
- Flag mmap implemenation of dynamic shared memory as resize-capable. Error noted by Heikki Linnakangas http://git.postgresql.org/pg/commitdiff/c6d4b1dd3e9eabca68caea6256ed8bc58dfa0917
Tom Lane a poussé :
- Increase git_changelog's timestamp_slop from 10 min to 1 day. Many committers seem to now be using a work flow in which back-patched commits are timestamped minutes or even hours apart in different branches (most likely because they commit in one branch before starting work on the next one). git_changelog was failing to merge its reports in such cases, so increase the max time it's willing to merge commits across. I considered getting rid of the limit altogether, but that produces some odd results in terms of how the merged commit gets sorted relative to unrelated commits. http://git.postgresql.org/pg/commitdiff/7a1e34d3713c13b3b2c81f0410a6629362b37b00
- Improve draft release notes. Per suggestions from Andres Freund. Also fix spelling of Sergey Burladyan's name. http://git.postgresql.org/pg/commitdiff/b8b7b723f29e39769486545aef61d71edcadff80
- Update release notes for 9.3.2, 9.2.6, 9.1.11, 9.0.15, 8.4.19. http://git.postgresql.org/pg/commitdiff/02bb4bbc66ce2ce7ebfcb27a8a9e002ed9cadd2a
- Fix crash in assign_collations_walker for EXISTS with empty SELECT list. We (I think I, actually) forgot about this corner case while coding collation resolution. Per bug #8648 from Arjen Nienhuis. http://git.postgresql.org/pg/commitdiff/7ab321404c4f721a22e86f36f68fe5e94f65e54d
- Clear retry flags properly in replacement OpenSSL sock_write function. Current OpenSSL code includes a BIO_clear_retry_flags() step in the sock_write() function. Either we failed to copy the code correctly, or they added this since we copied it. In any case, lack of the clear step appears to be the cause of the server lockup after connection loss reported in bug #8647 from Valentine Gogichashvili. Assume that this is correct coding for all OpenSSL versions, and hence back-patch to all supported branches. Diagnosis and patch by Alexander Kukushkin. http://git.postgresql.org/pg/commitdiff/74242c23c1c6428c6da09fa37264c7f4f1438738
Bruce Momjian a poussé :
- doc: update wording of ineffective SET and ABORT commands. Wording by Alvaro Herrera http://git.postgresql.org/pg/commitdiff/54916b99f7e97aa6e32a4f265527f7517539d802
- Update C comment for pg_fe_getauthname. This function no longer takes an argument. http://git.postgresql.org/pg/commitdiff/6a6b7bbb81cd21d0f9aa70b850b791b61fb7e03d
- C comment: again update comment for pg_fe_sendauth for error cases http://git.postgresql.org/pg/commitdiff/4a8adfd4d09c7885daf548ecd53d4999f168a174
- libpq: change PQconndefaults() to ignore invalid service files. Previously missing or invalid service files returned NULL. Also fix pg_upgrade to report "out of memory" for a null return from PQconndefaults(). Patch by Steve Singer, rewritten by me http://git.postgresql.org/pg/commitdiff/9e0a97f1c8316e36fa4a8626e0a60792b0fb0c2e
- doc: split long query into multiple lines. Report from Erik Rijkers http://git.postgresql.org/pg/commitdiff/5043fc8251fa272177c69b86a8df2cb79d926521
- build: pass EXTRA_REGRESS_OPTS to secondary regression tests. Christoph Berg http://git.postgresql.org/pg/commitdiff/86ef4796f5120c55d1a48cfab52e51df8ed271b5
- docs: clarify SSL certificate authority chain docs. Previously, the requirements of how intermediate certificates were handled and their chain to root certificates was unclear. http://git.postgresql.org/pg/commitdiff/fa4add50c4ea97c48881fa8cb3863df80141643c
- docs: update partition encryption options. Text from Adam Vande More http://git.postgresql.org/pg/commitdiff/8fe3d90d34c26083e9856cb134dfe17a5f6999aa
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é :
- Expose qurey ID in pg_stat_statements view. The query ID is the internal hash identifier of the statement, and was not available in pg_stat_statements view so far. Daniel Farina, Sameer Thakur and Peter Geoghegan, reviewed by me. http://git.postgresql.org/pg/commitdiff/91484409bdd17f330d10671d388b72d4ef1451d7
Magnus Hagander a poussé :
- Fix a couple of typos. Noted by Peter Geoghegan http://git.postgresql.org/pg/commitdiff/54aa5ef7f2dbe979843daf0c7a0d98f6709da4e6
- Fix pg_stat_statements build on 32-bit systems. Peter Geoghegan http://git.postgresql.org/pg/commitdiff/33d3f5594ac0cc4b6df3bf29b39db93bc32f1213
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.