>> 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