[falcolas]

Why not use a binary backup method? Faster to backup and restore.

[martin_]

Agreed. I've been successfully using mylvmbackup on 10gb+ databases for a few years now.

http://www.lenzg.net/mylvmbackup/

[fud]

We use our own lvm solution at work, works great, we do something like pgsnap to swap to the snapshot or pgsnap master to work on the master. I'll check this out.

[obsession]

Interesting, I'll have to take a look.