Re: "Hot standby"?

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