> I know about pg_dumpall, which creates a humongous SQL file, but is > there something equivalent in the postgresql world, like a > "pgsqlhotcopy" which copies data folders in a similar way as > mysqlhotcopy? If you're lucky enough to be using a filesystem which supports atomic snapshotting of directories (LVM and ZFS, I believe), you could just take a snapshot of your entire Postgres data directory. See e.g. http://lethargy.org/~jesus/archives/92-PostgreSQL-warm-standby-on-ZFS-crack.html Note that mysqlhotcopy essentially works by forcibly locking all tables while the copy is going on -- for any moderately big and busy server, this is a huge problem. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
