Archiwizowane December, 2013

Otto Bretz reported bug in OmniPITR. The bug was that when using -dr (remote destinations for backups) - you couldn't use --skip-xlogs. Obvious overlook on my side. Fix was trivial, and so 1.3.2 version was born.

On 12th of December, Simon Riggs committed patch: Allow time delayed standbys and recovery Set min_recovery_apply_delay to force a delay in recovery apply for commit and restore point WAL records. Other records are replayed immediately. Delay is measured between WAL record time and local ...

On 12th of December, Tom Lane committed patch: Improve EXPLAIN to print the grouping columns in Agg and Group nodes. Per request from Kevin Grittner.

On 11th of December, Peter Eisentraut committed patch: PL/Perl: Add event trigger support From: Dimitri Fontaine

December 18th, 2013 by depesz | Tags: , , , , , , | No comments »

Right after releasing 1.3.0 I realized that I forgot about one thing. If you're using ext3 (and possibly other, not sure) file system, removal of large file can cause problems due to heavy IO traffic. We did hit this problem earlier at ...

On 11th of December, Robert Haas committed patch: Add new wal_level, logical, sufficient for logical decoding. When wal_level=logical, we'll log columns from the old tuple as configured by the REPLICA IDENTITY facility added in commit 07cacba983ef79be4a84fcd0e0ca3b5fcb85dd65. This makes it possible a properly-configured logical replication ...

December 16th, 2013 by depesz | Tags: , , , , , | 2 comments »

I just now committed new version of OmniPITR. You can download it from: GitHub PGXN The important change about 1.3.0 is that there is new tool - omnipitr-backup-cleanup. What is it for?

In release notes to latest release you can find: Fix VACUUM's tests to see whether it can update relfrozenxid (Andres Freund) In some cases VACUUM (either manual or autovacuum) could incorrectly advance a table's relfrozenxid value, allowing tuples to escape freezing, causing those rows ...