Skip to content

Wöchentlicher PostgreSQL Newsletter - 11. April 2010

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 11. April 2010 ==

== PostgreSQL Produkt Neuigkeiten ==

Versionen 1.2.21 und 2.0.3 von Slony1, eine kaskadierende Master-Slave
Replikationslösung für PostgreSQL, sind erschienen.

Postgre-XC, ein synchroner Multi-Master Cluster für PostgreSQL,
ist erschienen.

py-postgresql Version 1.0, ein nativer Python 3 Treiber
für PostgreSQL, ist erschienen.

ODBC-Link 1.0 und das ODBC-basierte Datenbank Link System, sind

== PostgreSQL 9.0 Feature der Woche ==

Du kannst jetzt GRANT und REVOKE auf alle Objekte eines Schemas
mit einem Befehl durchführen.

== PostgreSQL Jobs im April ==

== PostgreSQL Lokal ==

Der CfP für CHAR(10) in Oxford, England vom 1. bis 3. Juli 2010
ist offen. Proposals sind bis zum 20. April einzureichen.

Bruce Momjian wird über PostgreSQL Replikationslösungen auf dem
NYPUG Treffen am 20. April um 18:30-20:30 im Penn Plaza sprechen.
Details und Anmeldung unter:

Linuxfest Nordwest 2010 findet in Bellingham, Washington, USA am
24. und 25. April statt. Vortragsreihen, Stände und Sponsoring
sind verfügbar.

Andreas (ads) Scherbaum hält einen Kurs "PostgreSQL im
Unternehmenseinsatz" an der VHS Magdeburg, Deutschland, vom 03. bis 07.
Mai 2010. Details unter:

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19.

Der CfP für OSBridge ist eröffnet! OSBridge findet vom 1. bis 4.
Juni 2010 in Portland, Oregon statt.

Das Southeast Linuxfest 2010 findet in Spartanburg, SC, USA am
12. und 13. Juni statt. Stände und Sponsoringmöglichkeiten sind
noch verfügbar.

OSCON wird in Portland, Oregon vom 19. bis 23. Juli 2010 stattfinden.

== PostgreSQL in den News ==

Planet PostgreSQL:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David

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

== Angewandte Patches ==

ITAGAKI Takahiro committed:

- Assorted tab-completion improvements in psql.  Added missing
  completions for ALTER SEQUENCE name OWNER TO, ALTER TYPE name RENAME
  ALTER VIEW name SET SCHEMA.  Fix wrong completions for ALTER
  FUNCTION/AGGREGATE name (arguments) where the "arguments" part was
  ignored, and ALTER ... SET SCHEMA, where "SCHEMA" was considered to
  be a variable name.

- In pgsql/src/bin/pg_ctl/pg_ctl.c, add cygwin version check before
  using cygwin_conv_path(), and use cygwin_conv_to_full_win32_path()
  in older versions.

- In pgsql/src/bin/psql/tab-complete.c, psql tab completion for ALTER

Bruce Momjian committed:

- In pgsql/doc/src/sgml/ddl.sgml, reword exclusion constriants to
  mention that the operator can return false or null, per Tom.

Simon Riggs committed:

- Change some debug ereports to elogs, as requested by translation

- In pgsql/src/backend/access/transam/xlog.c, further message changes
  when recovery.conf parameters missing.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/recovery.conf.sample, rename
  "Log-streaming replication parameters" header to "Standby server
  parameters" in recovery.conf, to match the grouping in the
  documentation.  Fujii Masao.

- Forbid using pg_xlogfile_name() and pg_xlogfile_name_offset() during
  recovery. We might want to relax this in the future, but
  ThisTimeLineID isn't currently correct in backends during recovery,
  so the filename returned was wrong.  Fujii Masao.

- Allow quotes to be escaped in recovery.conf, by doubling them. This
  patch also makes the parsing a little bit stricter, rejecting
  garbage after the parameter value and values with missing ending
  quotes, for example.

Magnus Hagander committed:

- In pgsql/src/timezone/pgtz.c, log the actual timezone name that we
  fail to look up the values for in case the registry data doesn't
  follow the format we expect, to facilitate debugging.

- In pgsql/src/timezone/pgtz.c, proceed to look for the next timezone
  when matching a localized Windows timezone name where the
  information in the registry is incomplete, instead of aborting.
  This fixes cases when the registry information is incomplete for a
  timezone that is alphabetically before the one that is in use.  Per
  report from Alexander Forschner

- In pgsql/src/timezone/pgtz.c, update list of Windows timezones we
  try to match localized names against to one that's up to date with
  Windows 2003R2.

- In pgsql/src/timezone/pgtz.c, clean up inconsistent commas.

- Perltidy run over the MSVC build system files, to clean up code
  formatting and indentation styles.

Tom Lane committed:

- Fix to_char YYY, YY, Y format codes so that FM zero-suppression
  really works, rather than only sort-of working as the previous
  attempt had left it.  Clean up some unnecessary differences between
  the way these were coded and the way the YYYY case was coded.
  Update the regression test cases that proved that it wasn't working.

Robert Haas committed:

- Make smart shutdown work in combination with Hot Standby/Streaming
  Replication.  At present, killing the startup process does not
  release any locks it holds, so we must wait to stop the startup and
  walreceiver processes until all read-only backends have exited.
  Without this patch, the startup and walreceiver processes never
  exit, so the server gets permanently stuck in a half-shutdown state.
  Fujii Masao, with review, docs, and comment adjustments by me.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Simon Riggs sent in two revisions of a patch to downgrade a FATAL
message to a WARNING for hot standby when primary_conninfo or
restore_command are left out.

Greg Sabino Mullane sent in a patch to show schema name for each table
when REINDEX DATABASE is called.

Simon Riggs sent in a patch for Hot Standby to recover prepared
transactions when starting up from shutdown.

Heikki Linnakangas sent in a patch to add signaling between
walreceiver and startup process.

Heikki Linnakangas sent in a patch to keep a variable in shared memory
to track the latest removed WAL segment.  This can help with streaming
replication in the case of a "disk full" condition on the primary.

Heikki Linnakangas sent in a patch to fix unsafe threading for
syslogger on Windows.

Simon Riggs and Heikki Linnakangas traded patches to fix the issue
where Hot Standby doesn't work right with shutdowns at an inopportune

Jaime Casanova sent in a WIP patch to fix "make standbycheck".


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