Recently someone was looking for help with script from Pg wiki. I never really checked it, but when talking with the guy needing help, I looked at it. And didn't really like it.

On 24th of March, Andrew Dunstan committed patch: Add parallel pg_dump option. New infrastructure is added which creates a set number of workers (threads on Windows, forked processes on Unix). Jobs are then handed out to these workers by the master process as needed. pg_restore ...

Some time ago I wrote a piece on speeding up dump/restore process using custom solution that was parallelizing process. Later on I wrote some tools ("fast dump and restore") to do it in more general way. But all of them had a ...

So, you just installed your PostgreSQL, and you have no idea how to use it - there is no icon in the menu of your OS, so how can you use it? Well, with the dreadful command line. Of course - ...

On 14h of December, Andrew Dunstan committed patch: Add --exclude-table-data option to pg_dump. Andrew Dunstan, reviewed by Josh Berkus, Robert Haas and Peter Geoghegan. This allows dumping of a table definition but not its data, on a per table basis. Table name patterns are ...

March 2nd, 2011 by depesz | Tags: , , , , , , , | Comments Off on Waiting for 9.1 – EXTENSIONS

On 8th of February, Tom Lane committed patch: Core support for "extensions", which are packages of SQL objects. This patch adds the server infrastructure to support extensions. There is still one significant loose end, namely how to make it play nice with pg_upgrade, ...

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