Skip site navigation (1) Skip section navigation (2)

== Notiziario settimanale PostgreSQL - 28 giugno 2009 ==

From: Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>
To: pgsql-it-generale <pgsql-it-generale(at)postgresql(dot)org>
Subject: == Notiziario settimanale PostgreSQL - 28 giugno 2009 ==
Date: 2009-07-19 23:30:28
Message-ID: 20090719233028.GC5222@eee.gi (view raw or flat)
Thread:
Lists: pgsql-it-generale
== Notiziario settimanale PostgreSQL - 28 giugno 2009 ==

(Traduzione parziale in lingua italiana delle PostgreSQL Weekly News a
 cura di Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>)

Presto uscirà la 8.4.0. Nel mentre, continuate con i test!  
http://www.postgresql.org/developer/beta

Si terrà una conferenza in Athens, Georgia, USA il 19 settembre
2009. È aperto il CfP.  
http://www.postgresqlconference.org/2009/pgday/athens

Lo stand PostgreSQL a FISL in Porto Alegre, Brazil era molto
affollato. Le foto sono disponibili qua:  
http://picasaweb.google.com/diogob/FISL2009?feat=directlink

Domenica 23 agosto 2009 il PostgreSQL User Group tedesco avrà una dev
room a FrOSCon. È aperto il Call for Papers:  
http://andreas.scherbaum.la/blog/archives/573-Call-for-Papers-fuer-den-PostgreSQL-Devroom-auf-der-FrOSCon-2009.html

Si terrà una conferenza a Seattle, Washington, USA nei giorni 16-18
ottobre 2009. È aperto il CfP.  
http://www.postgresqlconference.org/2009/west

== Novità sul prodotto PostgreSQL ==

Andreas (ads) Scherbaum terrà un corso "PostgreSQL for Corporate Use"
al centro di formazione per adulti in Magdeburgo, Germania, dal 7
all'11 settembre 2009. Trovate i dettagli qua:  
http://andreas.scherbaum.la/blog/archives/574-PostgreSQL-als-Bildungsurlaub.html

Rilasciata la versione 3.03 di MyJSQLView, un front-end Java UI per
l'editing dei dati.  
http://myjsqlview.org/projects/MyJSQLView/index.html

Rilasciate le versioni 0.9.0 e 0.8.2 di py-postgresql, un client
(driver) per PostgreSQL e un toolkit generico per lavorare con
PostgreSQL in Python.  
http://python.projects.postgresql.org/?utm_source=release&utm_medium=email&utm_campaign=py-postgresql-0.9.0

== Il suggerimento della settimana == 

Dovete inviare dati a MS Excel? "COPY ... WITH CSV HEADERS"

== Offerte di lavoro su PostgreSQL per giugno 2009 ==

http://archives.postgresql.org/pgsql-jobs/2009-06/threads.php

== Notizie locali su PostgreSQL ==

Il pgDay di San Jose (USA) si terrà domenica 19 luglio 2009, dando il
via ad OSCON.  Iscrivetevi qui:  
http://postgresql.meetup.com/1/calendar/10626647

Nei giorni 22 e 23 agosto 2009, a St. Augustin, in Germania, vicino a
Bonn e Colonia, si terrà OpenSQL Camp. La scadenza per presentare
comunicazioni è il 19 luglio 2009. Inviate le vostre proposte!  
http://opensqlcamp.org/Events/2009/Call_for_Participation

Il CfP per PyCon Argentina è aperto fino al 29 giugno 2009, 23:59
ART. La conferenza si terrà in Buenos Aires nei giorni 4 e 5 settembre
2009.  
http://ar.pycon.org/2009/rfp/

È aperto il CfP per PGCon Brazil, che si svolgerà Il 23 e 24 ottobre
2009 presso Unicamp, nella città di Campinas, stato di San Paolo.  
http://pgcon.postgresql.org.br/2009/chamadas.en.php

Dal primo ottobre, 2ndQuadrant offrirà supporto gratuito agli studenti
dell'Università dell'Aquila, per un periodo di 15 mesi. Per ulteriori
informazioni:  
http://blog.2ndquadrant.it/it/2009/06/2ndquadrant-universita-aquila.html

Il PGDay.EU 2009 si terrà a Telecom ParisTech in Parigi nei giorni 6 e
7 novembre 2009.  
http://www.pgday.eu/

Gli organizzatori della conferenza per il decimo anniversario di JPUG
stanno accettando proposte. La conferenza si terrà i giorni 20 e 21
novembre 2009 a Tokio.  
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

== Rassegna stampa su PostgreSQL ==

Planet PostgreSQL: http://planet.postgresql.org/

Questo notiziario settimanale PostgreSQL è stato realizzato da David
Fetter e Josh Berkus; traduzione parziale in lingua italiana a cura di
Gianni Ciolli.

Notizie o annunci destinati a questo notiziario dovranno pervenire
entro la mezzanotte di domenica (le 15 nel fuso orario della
California). I comunicati in lingua italiana dovranno essere inviati a
pwn(at)itpug(dot)org; per le lingue inglese o tedesca, si scriva
rispettivamente a david(at)fetter(dot)org o a pwd(at)pgug(dot)de(dot)

== Patch applicate ==

Tom Lane committed:

- In pgsql/src/backend/utils/adt/arrayfuncs.c, revert dubious message
  wording change.

- Make to_timestamp and friends skip leading spaces before an integer
  field, even when not in Fujii Masao mode.  This improves
  compatibility with Oracle and with our pre-8.4 behavior, as per bug
  #4862.  Add a couple of regression test cases for this.  In passing,
  get rid of the labeling of the individual test cases; doesn't seem
  to be good for anything except causing extra work when inserting a
  test...  Brendan Jurd and Tom Lane

- For bulk write operations (eg COPY IN), use a ring buffer of 16MB
  instead of the 256KB limit originally enforced by a patch committed
  2008-11-06.  Per recent test results, the smaller size resulted in
  an undesirable decrease in bulk data loading speed, due to COPY
  processing frequently getting blocked for WAL flushing.  This area
  might need more tweaking later, but this setting seems to be good
  enough for 8.4.

- Fix the makefiles to fail cleanly if Perl is needed but not present.
  This used to work as intended, but got broken some time ago (a
  quoted empty string is not an empty string), and got broken some
  more by the changes to generate ecpg's preproc.y automatically.
  Given all the unprotected uses of $(PERL) elsewhere, it seems best
  to make use of the $(missing) script rather than trying to ensure
  each such use is protected individually.  Also fix various bits of
  documentation that omitted to mention Perl as a requirement for
  building from a CVS pull.  Per a complaint from Robert Haas.

- In pgsql/src/backend/utils/adt/geo_ops.c, fix an ancient error in
  dist_ps (distance from point to line segment), which a number of
  other geometric operators also depend on.  It miscalculated the
  slope of the perpendicular to the given line segment anytime that
  slope was other than 0, infinite, or +/-1.  In some cases the error
  would be masked because the true closest point on the line segment
  was one of its endpoints rather than the intersection point, but in
  other cases it could give an arbitrarily bad answer.  Per bug #4872
  from Nick Roosevelt.  Bug goes clear back to Berkeley days, so patch
  all supported branches.  Make a couple of cosmetic adjustments while
  at it.

- In pgsql/doc/src/sgml/dml.sgml, provide a link to the UPDATE
  reference page in the 'Updating Data' section of the docs.  Per
  suggestion from Brad Bowman.

- In pgsql/contrib/pg_standby/pg_standby.c, make prior patch
  pgindent-safe.

- In pgsql/src/backend/utils/error/elog.c, add
  __attribute__((format_arg(1))) to the declaration of err_gettext(),
  to restore gcc's ability to crosscheck format arguments within
  elog.c.  Noted in a test compilation with -Wformat-nonliteral
  enabled.

- Cleanup and code review for the patch that made bgwriter active
  during archive recovery.  Invent a separate state variable and
  inquiry function for XLogInsertAllowed() to clarify some tests and
  make the management of writing the end-of-recovery checkpoint less
  klugy.  Fix several places that were incorrectly testing InRecovery
  when they should be looking at RecoveryInProgress or
  XLogInsertAllowed (because they will now be executed in the bgwriter
  not startup process).  Clarify handling of bad LSNs passed to
  XLogFlush during recovery.  Use a spinlock for setting/testing
  SharedRecoveryInProgress.  Improve quite a lot of comments.  Heikki
  Linnakangas and Tom Lane.

- In pgsql/doc/src/sgml/backup.sgml, marginal improvement of
  description of recovery_end_command.

- In pgsql/doc/src/sgml/monitoring.sgml, add a note about SystemTap vs
  DTrace spelling of probe names.

- In pgsql/doc/src/sgml/release-8.4.sgml, update release notes in
  final preparation for 8.4.0.

- In pgsql/doc/Makefile, revert addition of "o" to tar options.  This
  was intended to fix bug #4883, but the cure appears to be worse than
  the disease.  It turns out that GNU tar versions 1.14.x misinterpret
  -o as --same-owner, not --no-same-owner, leading to exactly the
  wrong behavior for both root and nonroot users.  While that bug has
  been fixed for nearly five years, these tar versions are still found
  in the wild, notably in OS X 10.4.  Given that #4883 was the first
  complaint we'd heard, it's definitely not worth fixing at the risk
  of breaking things for other users.  Perhaps revisit at a later date
  when we're not up against a release deadline.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/ref/move.sgml, add more explicit note that the
  parameters of MOVE are identical to FETCH.  Per David Wheeler.

- In pgsql/src/backend/access/gist/gistsplit.c, correct grammar in
  picksplit debug messages

- In pgsql/doc/src/sgml/Makefile, man pages back to lowercase names,
  with additional fixup to make the .so links work.

- In pgsql/doc/Makefile, use $(TAR) instead of tar in makefiles.

- In pgsql/doc/Makefile, extract tarballs with "o" option (tar xof),
  to behave reasonably when run as root, as would usually be the case
  during make install.  Per bug #4883.

- Translation updates for 8.4 release.  File that are translated less
  than 80% have been removed, as per new translation team policy.

Marc Fournier committed:

- Bundle RC2.

- Bundle v8.4.0.

Magnus Hagander committed:

- Properly initialize SSL engines when used from libpq.  This is
  required for most external engines.  Per report and initial code
  from Lars Kanis.

- In pgsql/src/backend/libpq/hba.c, parse_ident_usermap() should use
  ereport(LOG) and not ERROR, and put the return value in the *error_p
  variable.  Noted by Tom Lane.

- In pgsql/doc/src/sgml/client-auth.sgml, fix incorrect LDAP example,
  noted by Tom Lane.

- In pgsql/src/backend/libpq/auth.c, disallow empty passwords in LDAP
  authentication, the same way we already do it for PAM.

Heikki Linnakangas committed:

- Disable pg_standby -l option because the backend doesn't expect the
  recovered file to be a symlink.  We tried to fix this issue with an
  earlier server-side patch, but it didn't fix the whole issue.  The
  same bug is present in older releases as well, but the 8.4 train is
  about to leave the station, and I'm not sure if have consensus on
  whether we can remove the -l option in back-branches or do we need
  to attempt a server-side fix to make symlinking safe.  Patch by
  Simon Riggs, per discussion on bug identified by Fujii Masao.

- In pgsql/src/backend/access/transam/twophase.c, the code to unlink
  dropped relations in FinishPreparedTransaction() was acting like
  runs inside WAL recovery, but it doesn't.  I must've copy-pasted
  this from a redo-function in the relation forks patch.  Noticed by
  Tom Lane while he was looking through callers of smgrdounlink().

- Fix some serious bugs in archive recovery, now that bgwriter is
  active during it: When bgwriter is active, the startup process can't
  perform mdsync() correctly because it won't see the fsync requests
  accumulated in bgwriter's private pendingOpsTable.  Therefore make
  bgwriter responsible for the end-of-recovery checkpoint as well,
  when it's active.  When bgwriter is active (= archive recovery), the
  startup process must not accumulate fsync requests to its own
  pendingOpsTable, since bgwriter won't see them there when it
  performs restartpoints.  Make startup process drop its
  pendingOpsTable when bgwriter is launched to avoid that.  Update
  minimum recovery point one last time when leaving archive recovery.
  It won't be updated by the end-of-recovery checkpoint because
  XLogFlush() sees us as out of recovery already.  This fixes bug
  #4879 reported by Fujii Masao.

== Patch rifiutate (per adesso) ==

No one was disappointed this week :-)

== Patch in coda ==

ITAGAKI Takahiro sent in a patch to add missing_ok to GetUserMapping()
and makes dblink use it.

Robert Haas sent in a patch to make pg_listener.h conform better to
PostgreSQL coding standards.

Zoltan Boszormenyi sent in a patch to add dynamic cursors and SQLDA to
ECPG.

Fujii Masao and Magnus Hagander traded patches to remove pg_standby's
dependency on libpq.so.5.

KaiGai Kohei sent in a patch to add DAC security checks on large
objects.

Scara Maccai sent in a patch to add a query progress indicator.

Tsutomu Yamada sent in a patch to make PostgreSQL more portable to
64-bit platforms.

Nedyalko Borisov sent in a JOIN optimization for partitioned tables.

Robert Haas sent in a patch to make generated header files work better
with building subsystems.


pgsql-it-generale by date

Next:From: Gianni CiolliDate: 2009-07-19 23:34:26
Subject: == Notiziario settimanale PostgreSQL - 5 luglio 2009 ==
Previous:From: Gianni CiolliDate: 2009-07-19 22:10:19
Subject: == Notiziario settimanale PostgreSQL - 21 giugno 2009 ==

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group