>> Incidentally, we billed pg_dump as hot backup at some point. It *is* "hot backup" as in taken while the database is running and fully accessible.
> mysql calls "mysqlhotcopy" a script that locks and flushes all tables, > then makes a copy of the database directory (all queries being locked > out while this is in progress, of course). Which is actually 'cold backup'; it's only "hot" compared to earlier MySQLs where you had to shut the db down. So it's sort of a "lukewarm backup". -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers