== Wöchentlicher PostgreSQL Newsletter - 22. März 2009 ==

Der Originalartikel befindet sich unter:
http://www.postgresql.org/community/weeklynews/pwn20090322

== Wöchentlicher PostgreSQL Newsletter - 22. März 2009 ==

Sicherheitsupdates für 8.3.7, 8.2.13, 8.1.17, 8.0.21 und 7.4.25
veröffentlicht. Diese Releases beseitigen einen Denial of Service beim
Umwandeln von Encodings, alle Nutzer sollten zum nächsten verfügbaren
Zeitpunkt die Datenbank aktualisieren.

Code Stücke haben jetzt im Wiki ein neues Zuhause.
http://wiki.postgresql.org/wiki/Snippets

Fernando Ike de Oliveira hat eine identica Gruppe für PostgreSQL
erstellt.
http://identi.ca/group/postgresql

pgCon Zeitplan ist verfügbar: http://www.pgcon.org/2009/schedule/

PgDay Brasilien wird am 17. April stattfinden. Kontaktiere fernando.ike
AT gmail DOT com oder eduardo DOT santos AT planejamento DOT gov DOT
br, wenn du teilnehmen möchtest.

Der CfP für den PgDay in Sao Paulo am 24. April ist eröffnet.
Kontaktiere marins DOT consultoria AT gmail DOT com oder marcelojscosta
AT gmail DOT com wenn du teilnehmen möchtest.

Es werden weiterhin PgDays am 29. April in Porto Velho, RO und am 20.
April in Ji-Parana, RO stattfinden. Kontaktiere Luis Fernando Bueno:
proflfbueno AT gmail DOT com wenn du teilnehmen möchtest.

== PostgreSQL Produkt Neuigkeiten ==

Benetl 2.6, ein ETL für Dateien in PostgreSQL, ist erschienen.
http://www.benetl.net

dataPro 1.6, ein visuelles Datenbank Management, Entwicklungs und
Konversationsprogramm, ist erschienen.
http://www.vive.net/products/datapro.htm

Simpycity 0.2.0a9, ein Python Mapping System für PostgreSQL, ist
erschienen.
https://projects.commandprompt.com/public/simpycity/repo/trunk/dist/Simpycity-0.2.0a9-py2.6.egg

== PostgreSQL 8.4 Feature der Woche ==

Funktionen editieren: psql erlaubt es mit dem Befehl \ef, Funktionen
direkt im bevorzugten Editor zu bearbeiten.

== PostgreSQL Tipp der Woche ==

bonnie++, dd und iozone sind brauchbare Werkzeuge, um die Performance
des Dateisystems und des I/O-Systems zu testen. Wenn deine Datenbank
größer als der verfügbare Hauptspeicher ist, bildet das Speichermedium
den limitierenden Faktor.

== PostgreSQL Jobs im März ==

Http://archives.postgresql.org/pgsql-jobs/2009-03/threads.php

== PostgreSQL Lokal ==

PostgreSQLFr wird einen Stand auf der Solutions Linux 2009 in Paris
haben. Anmelden unter sas AT postgresql DOT fr oder im
französischen Wiki.
http://postgresql.fr/sl2009:start

Die Registrierung für die PostgreSQL Konferenz (JDCon) East 2009
ist jetzt möglich:
http://www.postgresql.us/purchase

Kevin Kempter wird über Backup und Wiederherstellen auf dem ersten
Denver PUG Meeting am 8. April 2009 sprechen.
http://www.diapug.org/Meeting.html

PostgreSQL Conference U.S. (JDCon) wird einen PgDay auf dem Linuxfest
Nordwest am 25. und 26. April veranstalten. Der Call for Papers ist
unter:
http://www.postgresqlconference.org/

Michael Renner wird einen Workshop über PostgreSQL Replikation auf
der Netways OSDC 2009 in Nürnbern, Deutschland geben.
http://www.netways.de/english/osdc/y2009/programm/w/michael_renner_postgresql_repliziert_ein_ueberblick/

PGCon 2009 wird vom 21. bis 22. Mai 2009 in Ottawa an der Universität
von Ottawa stattfinden. Dem gehen zwei Tage mit Tutorials vom 19. bis
20. Mai 2009 voraus.
http://www.pgcon.org/2009/

Termin vormerken: pgDay San Jose, am Sonntag dem 19. Juli unmittelbar
vor der OSCON. CfP und mehr Informationen bald.

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden.

== PostgreSQL in den News ==

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

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Josh Berkus.

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Peter Eisentraut committed:

- In pgsql/src/bin/pg_dump/pg_dump.c, add -w option to --help output.
It was apparently forgotten when -w was implemented.

- Rename pg_restore -m to -j, and add documentation about what good
numbers are. Per discussion on -hackers.

Bruce Momjian committed:

- In pgsql/src/backend/utils/adt/datetime.c, document that datetime
year '0' is considered in a recent century, not just '00'.

- In pgsql/src/backend/utils/adt/datetime.c, improve zero-year
comments.

- In pgsql/doc/src/sgml/client-auth.sgml, clarify 'cert'
authentication documention.

- In pgsql/doc/src/sgml/libpq.sgml, clarify libpq 'sslverify'
documentation wording.

Tom Lane committed:

- In pgsql/doc/src/sgml/release.sgml, add just-assigned CVE number to
release notes for recent security issue.

- In pgsql/doc/src/sgml/intarray.sgml, be more clear about when to use
gist__int_ops vs. gist__intbig_ops. Per suggestion from Ron Mayer.

- Optimize multi-batch hash joins when the outer relation has a
nonuniform distribution, by creating a special fast path for the
(first few) most common values of the outer relation. Tuples having
hashvalues matching the MCVs are effectively forced to be in the
first batch, so that we never write them out to the batch temp
files. Bryce Cutt and Ramon Lawrence, with some editorialization by
me.

- Remove the datetime keywords ABSTIME and RELTIME, which we'd been
treating as noise words for the last twelve years, for compatibility
with Berkeley-era output formatting of the special INVALID values
for those datatypes. Considering that the datatypes themselves have
been deprecated for awhile, this is taking backwards compatibility a
little far. Per gripe from Josh Berkus.

- Remove the -d and -D options of pg_dump and pg_dumpall. The
functionality is still available, but you must now write the long
equivalent --inserts or --column-inserts. This change is made to
eliminate confusion with the use of -d to specify a database name in
most other Postgres client programs. Original patch by Greg Sabino
Mullane, modified per subsequent discussion.

- Clean up pg_SSPI_error() coding a little bit: make the messages more
consistent, translate where intended, const-ify declarations.
Resolves a gripe from Alvaro Herrera as well as some stuff I didn't
like.

- Add isExtend to the parameters of the buffer_read_start and
buffer_read_done DTrace probes, so that ordinary reads can be
distinguished from relation extension operations. Move
buffer_read_start probe to before the smgrnblocks() call that's
needed in the isExtend case, since really that step should be
charged as part of the time needed for the extension operation.
(This makes it slightly harder to match the read_start with the
associated read_done, since now you can't match them on blockNumber,
but it should still be possible since isExtend operations on the
same relation can never be interleaved.) Per recent discussion. In
passing, add the page identity (forkNum/blockNum) to the parameters
of the buffer_flush_start/buffer_flush_done probes, which were
unaccountably lacking the info.

- More fixes for 8.4 DTrace probes. Remove useless
BUFFER_HIT/BUFFER_MISS probes --- the BUFFER_READ_DONE probe
provides the same information and more besides. Expand the
LOCK_WAIT_START/DONE probe arguments so that there's actually some
chance of telling what is being waited for. Update and clean up the
documentation.

Heikki Linnakangas committed:

- In pgsql/src/backend/postmaster, fix Windows-specific race condition
in syslogger. This could've been the cause of the "could not write
to log file: Bad file descriptor" errors reported at
http://archives.postgresql.org//pgsql-general/2008-06/msg00193.php
Backpatch to 8.3, the race condition was introduced by the CSV
logging patch. Analysis and patch by Gurjeet Singh.

- Add seven kanji characters defined in the Windows 950 codepage to
our big5/win950 <-> UTF8 conversion tables. Per report by Roger
Chang.

- Fix case of the just resurrected UCS_to_BIG5.pl script, and update
Makefile to use it.

- In pgsql/contrib/pg_standby/pg_standby.c, don't intercept SIGQUIT as
a signal to trigger failover; that's what postmaster uses for
immediate shutdown. Trap SIGUSR1 as the preferred signal for that.
Per report by Fujii Masao and subsequent discussion on -hackers.

- In pgsql/contrib/pg_standby/pg_standby.c, don't set the signal
handler for SIGQUIT on Windows. Buildfarm shows that reinstalling
the default signal handler doesn't work as it is on Windows.
Presumably core dumps on SIGQUIT are not a problem on Windows, so
rather than figure out what header files or other changes are
required to make it work, just don't bother.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Koichi Suzuki sent in another revision of the PITR performance
improvement patch.

Magnus Hagander sent in a patch which changes the path separator for
files on windows to a backslash unconditionally.

Teodor Sigaev sent in another revision of the patch to add B-Tree
emulation to GIN indexes.

Shrish Purohit sent in another revision of the Thick Index patch.

Michael Renner sent in a doc patch to clarify between redo and
checkpoint records.

Pavel Stehule sent in a WIP patch to add transformationHook.

Sergey Burladyan sent in a patch to check for ngettext in configure,
add some new macros for ngettext, and change psql's "(1 row)" messages
to _P(...) macros.

Tom Lane sent in a patch which fixes some libxml incompatibilities.

--
Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group: http://www.pgug.de
DPWN: http://andreas.scherbaum.la/blog/categories/18-PWN