Skip to content

Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007



Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/


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

ruby-pg ist jetzt ein offizielles rubyforge Projekt für "postgres" ruby
gem. http://www.rubyforge.org/projects/ruby-pg

== PostgreSQL Produkt Neuigkeiten ==

DBI-Link wurde für Debian packetiert.
http://packages.debian.org/dbi-link

PL/Proxy wurde für Debian packetiert.
http://packages.debian.org/postgresql-8.2-plproxy

PostgreSQL Maestro 7.12 erschienen.
http://www.sqlmaestro.com/products/postgresql/maestro/

PgBouncer 1.1.2 erschienen.
http://pgfoundry.org/projects/pgbouncer/

Continuent uni/cluster für PostgreSQL 2007.1 erschienen.
http://www.continuent.com

Viewalyzer 1.0.0 erschienen.
http://sourceforge.net/project/showfiles.php?group_id=211124

== PostgreSQL Jobs im Dezember ==

http://archives.postgresql.org/pgsql-jobs/2007-12/threads.php

== PostgreSQL Lokal ==

PGCon 2008 Call for Papers startet am 19. Dezember. Jetzt mit den
Papers beginnen.
http://www.pgcon.org/2008/papers.php

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 fosdem@pgug.eu.
Für mehr Informationen siehe:
http://fosdem.org/2008/schedule/devroom/bsdpostgresql

PostgreSQL Conference East '08 ist am 28. und 29. März.
http://www.postgresqlconference.org/

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
einzureichen.
https://fisl.softwarelivre.org/9.0/

== PostgreSQL in den News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

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 david@fetter.org, deutsche an
pwn@pgug.de, italienische an pwn@itpug.org.

== 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
systems.

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

- 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
item.

- 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
way.

- Add random I/O URL to TODO.

- Mark items needing updating for beta stamping.

- Add default error rules for making postgres.pdf and postgres.ps,
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
mention.

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

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

- 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
improvement.

- 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
log."

- 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
low.

- 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
was.

- 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
#3799.

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.
  • Twitter
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007
  • Bloglines Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007
  • Technorati Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007
  • Fark this: Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at YahooMyWeb
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at Furl.net
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at reddit.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at blinklist.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at Spurl.net
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at Simpy.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 at blogmarks
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 16. Dezember 2007 with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

No Trackbacks

Comments

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