Jeff,
> The downside is
> this method will only work on that specific version of PG and it isn't the
> "cleanest" thing in the world since you are essentially simulating a power
> failure to PG. Luckly the WAL works like a champ. Also, these backups can
> be much larger since it has to include the indexes as well. but this is a
> price you have to pay.
The other downside is, of course, that the database needs to be shut down.
> COOL HUH?
Certainly very useful in the DBA's arsenal of backup tools.
--
Josh Berkus
Aglio Database Solutions
San Francisco