Re: Re: Re: PostgreSQL over NFS?

Mike Castle <dalgoda@ix.netcom.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