Re: Re: Re: PostgreSQL over NFS?

Mike Castle <dalgoda(at)ix(dot)netcom(dot)com> writes:

> Another point of concern is state of the system when a backup is taken.
> Other threads pointed out the concern about backing up files during the
> middle of transactions and the like. Better if able to ask the LVM layer
> (or whatever) to take a snapshot, and then back THAT up. Does netapp offer
> such facilities? (I would imagine so, but not positive). If not, one may
> still have to do a pg_dump just to maintain stable backups.

I don't think that LVM (or snapshots in general, which NetApps do
indeed offer) will help without a way to tell PG to quiesce itself and
flush all caches to disk. A random snapshot of a PG database will
almost certainly not be consistent.

I don't think PG has anything like Oracle's "hot backup" mode, except
for pg_dump itself.

-Doug