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 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
