Re: [Gnumed-devel] update database - no problem

[Karsten Hilbert]

On Sun, Oct 07, 2007 at 12:18:34AM +0000, Syan Tan wrote:

> write-ahead log based backup ? 
WAL, yes, however, what we do here and takes so long is
pg_dump based with bzip2 in the pipe

> anyway, the other day I tried a backup over usb 2.0 as a direct file system
> copy and it took about 15 minutes.
Sure, that doesn't take long. But it requires the PostgreSQL
server to be stopped or else the backup is useless (unless
you use a snapshottable filesystem such as ZFS).

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346