At 12:55 AM 12/1/00 -0800, Nathan Myers wrote:
>Many people hope to run PostgreSQL 24x7x365. With vacuuming, you
>might just as well shut down afterward; but when that goes away
>(in 7.2?), when will you get the chance to take your backups?
>Clearly we need either another form of snapshot backup that can
>be taken with the database running, and compatible with the
>current WAL (or some variation on it); or, we need another kind
>of log, in addition to the WAL.
Vadim's not ignorant of such matters, when he says "make a copy
of the files" he's not talking about using tar on a running
database. BAR tools are needed, as Vadim has pointed out here in
the past.
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.