Reading the 20 or so Re's to NFS issues as well as the last few months of
list watching, as well as my own crash experience etc, what is the current
direction/state of things regarding backup, replication etc with postgresql?
Do you foresee pg_dump being used in the long term? It is sounding like
people are screaming for an automated, reliable way/state for shifting data
out of the database. Or a "hot copy" function.
Storage providers out there (storageway, storage networks, etc) are beating
their heads working with terabyte backups of oracle monsters and finding
ingenious ways to shunt these systems off to permanent storage while they're
running full speed. Veritas has a whole slew of approaches to backing up
these running monsters.
Not that postgresql would become the maven and apple of the storage
provider's eye ... but ...
I've yet to figure out a reliable automation backing up my hot postgresql
which doesn't involve *me* alert & oriented x 4.
Thanks,
George Johnson