On May, 12ve, Bruce Momjian committed new contrib module for 9.0 - pg_upgrage. As I understand - this is what was available before as pg-migrator. If you're not familiar with it - it's a tool that allows upgrade of $PGDATA from some ...

As some of you know, I've been working lately for OmniTI company. When doing things for them (PostgreSQL related of course :), I stumbled on very interesting problem. One of our clients is working on PostgreSQL 8.2, and wants to upgrade ...

Usually I write about new features in 8.4, but this time I'd like to write about feature that will be actually missing in 8.4. And thank God, it will be missing. On Mon, 09 Mar 2009 11:22:47 -0400 Greg Sabino Mullane ...

On 2nd of February Andrew Dunstan committed his patch (with editing by Tom Lane) that: Log Message: ----------- Provide for parallel restoration from a custom format archive. Each data and post-data step is run in a separate worker child (a thread on Windows, a ...

Great (and admittedly long overdue) patch by Tom Lane: Make pg_dump --data-only try to order the table dumps so that foreign keys' referenced tables are dumped before the referencing tables. This avoids failures when the data is loaded with the FK constraints ...