Skip to content

Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 ==

ruby-pg ist jetzt ein offizielles rubyforge Projekt für "postgres" ruby

== PostgreSQL Produkt Neuigkeiten ==

DBI-Link wurde für Debian packetiert.

PL/Proxy wurde für Debian packetiert.

PostgreSQL Maestro 7.12 erschienen.

PgBouncer 1.1.2 erschienen.

Continuent uni/cluster für PostgreSQL 2007.1 erschienen.

Viewalyzer 1.0.0 erschienen.

== PostgreSQL Jobs im Dezember ==

== PostgreSQL Lokal ==

PGCon 2008 Call for Papers startet am 19. Dezember. Jetzt mit den
Papers beginnen.

Die BSD und PostgreSQL Teams haben einen gemeinsamen Developer Room auf
der FOSDEM 2008 in Brüssel. Wenn du einen Vortrag halten möchtest oder
beim Managing des Rooms helfen möchtest, kontaktiere
Für mehr Informationen siehe:

PostgreSQL Conference East '08 ist am 28. und 29. März.

FISL 9.0 findet vom 17. bis 19. April 2008 auf der PUCRS in Porto
Alegre, Brasilien statt. Vorträge sind bis zum 1. November 2007

== PostgreSQL in den News ==

Planet PostgreSQL:

General Bits, Archive und gelegentliche News Artikel:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Fernando Ike de Oliveira.

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an, deutsche an, italienische an

== Angewandte Patches ==

Andrew Dunstan committed:

- Fix example archive_command for standalone backups so it doesn't
return spurious non-zero.

Peter Eisentraut committed:

- In pgsql/src/backend/postmaster/pgarch.c, provide a more accurate,
detailed log message when the archive command fails.

- Clarify log messages in pgsql/src/backend/postmaster/postmaster.c
and pgsql/src/backend/storage/file/fd.c

- In pgsql/doc/src/sgml/Makefile, make error message more accurate.

Alvaro Herrera committed:

- Extend the format of CSV logs to include the additional information
supplied with the logged event. CSV logs are now a first-class
citizen along plain text logs in that they carry much of the same
information. Per complaint from depesz on bug #3799.

- Correct result type of convert_to, per Pavel Stehule.

Magnus Hagander committed:

- Use _USE_32BIT_TIME_T when building with MSVC. Also, enforce that
it's used when building addons. Dave Page

- Typo pointed out by Erwin Brandstetter. Remove the whole makes it
even better, per JD.

- In pgsql/src/bin/pgevent/Makefile, get dllwrap name from variable
instead of hardcoded. Per complaint from Richard Evans.

Bruce Momjian committed:

- Document how to turn off disk write cache on popular operating

- In pgsql/doc/src/sgml/wal.sgml, write cache doc cleanups. Greg

- In pgsql/doc/src/sgml/wal.sgml, wording improvement for write-cache
disabling instructions.

- In pgsql/doc/src/sgml/release.sgml, Mention Stefan Kaltenbrunner as
contributor for text search because of psql work.

- Add release note introduction.

- Remove Stefan Kaltenbrunner mention from full text release note

- In pgsql/doc/src/sgml/release.sgml, adjust release notes for
HISTORY.html generation.

- Remove item "Allow free-behind capability for large sequential scans
to avoid kernel cache spoiling" from TODO. Fixed in a different

- Add random I/O URL to TODO.

- Mark items needing updating for beta stamping.

- Add default error rules for making postgres.pdf and,
suggesting proper target names.

- In pgsql/doc/src/sgml/Makefile, use clearer error message for gmake
postgres.pdf: "Makefile:171: *** Invalid target; use
postgres-A4.pdf or postgres-US.pdf as targets. Stop."

- In pgsql/doc/src/sgml/release.sgml, mark 8.3 as likely now January,
2008 in release notes.

- In pgsql/doc/src/sgml/high-availability.sgml, update pgpool-II

- In pgsql/doc/src/sgml/runtime.sgml, mention pg_ctl kill for Win32 in

- In pgsql/doc/src/sgml/runtime.sgml, add docs about OOM killer.
lst_hoe01 AT

- Update OOM wording.

- Mention that HOT helps with DELETE space reuse.

- In pgsql/doc/src/sgml/wal.sgml, update write-cache docs to mention
windows behavior for various fsync_methods. Magnus Hagander.

- In pgsql/doc/src/sgml/wal.sgml, Windows write-cache wording

- In TODO, update item description to read: "Consider having the
background writer update the transaction status hint bits before
writing out the page. Implementing this requires the background
writer to have access to system catalogs and the transaction status

- In pgsql/src/tools/pgindent/README, mention installing /contrib
libraries for pgindent.

- In pgsql/src/tools/pgindent/README, mention use all configure
options when getting pgindent typedefs.

Tom Lane committed:

- Make an editorial pass over the newly SGML-ified contrib
documentation. Fix lots of bad markup, bad English, bad
explanations. Second round of commits. pgcrypto and pgstandby
still to go...

- In pgsql/contrib/vacuumlo/vacuumlo.c, make vacuumlo prompt for
password when needed, thus making its -W switch optional, as is the
case for every other one of our programs. I had already documented
its -W as being optional, so this is bringing the code into line
with the docs ...

- Remove the -P options of oid2name and pgbench, as they are security
hazards. Instead teach these programs to prompt for a password when
necessary, just like all our other programs. I did not bother to
invent -W switches for them, since the return on investment seems so

- Remove the long-deprecated -u option from psql, since it does
nothing very useful and confuses people who think it is the same as
-U. (Eventually we might want to re-introduce it as being an alias
for -U, but that should not happen until the switch has actually not
been there for a few releases.) Likewise in pg_dump and pg_restore.
Per gripe from Robert Treat and subsequent discussion.

- Make documentation of -W options more accurate and uniform.

- In pgsql/doc/src/sgml/arch-dev.sgml, change 'merge sort join', a
phrase we use nowhere else, to the more usual 'merge join'.

- In pgsql/src/backend/postmaster/pgarch.c, clean up unportable
attempt to use #if inside a macro call, also faulty code in third
arm of #if. Per buildfarm reports.

- Improve the method of localizing column names and other fixed
strings in psql's \d commands and other uses of printQuery().
Previously we would pass these strings through gettext() and then
send them to the server as literals in the SQL query. But the code
was not set up to handle doubling of quotes in the strings, causing
failure if a translation attempted to use the wrong kind of quote
marks, as indeed is now the case for (at least) the French
translation of \dFp. Another hazard was that gettext() would
translate to whatever encoding was implied by the client's LC_CTYPE
setting, which might be different from the client_encoding setting,
which would probably cause the server to reject the query as
mis-encoded. The new arrangement is to send the untranslated ASCII
strings to the server, and do the translations inside printQuery()
after the query results come back. Per report from Guillaume
Lelarge and subsequent discussion.

- In pgsql/doc/src/sgml/textsearch.sgml, change a couple of examples
to say ALTER MAPPING instead of ADD MAPPING, per Oleg.

- Improve documentation about Julian dates; in particular, point out
the difference between Julian and Gregorian reckoning of when JD 0

- Make an editorial pass over the newly SGML-ified contrib
documentation. Fix lots of bad markup, bad English, bad
explanations. Last ones ... whew. Man, that was tedious.

== Abgelehnte Patches (bis jetzt) ==

Mark Kirkwood's patch to create tablespaces automatically. This
feature was previously removed on grounds of foot-gun-itude.

== Eingesandte Patches ==

Alvaro Herrera sent in a patch to fix the CSV logging gap from Bug

Dave Page sent in a patch to introduce a delay between client
connection setup and the start of the benchmark itself in pgbenchmark.

Tom Lane sent in a patch which disallows sending passwords in libpq.

Zdenek Kotala sent in a patch to pgsql/doc/src/sgml/wal.sgml which
explains how write cache works on Solaris.

Tom Lane sent in a patch which chagnes the way psql deals with
localization of column names and other fixed strings in the output of
\d and related commands, per gripe from Guillaume LeLarge.

Simon Riggs sent in a patch which changes the display of the archiver
under ps so that it can be monitored during archiving.


No Trackbacks


Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options