Re: PostgreSQL capabilities

Michael Meskes wrote:
>
> On Wed, May 31, 2000 at 09:26:51AM -0500, Ed Loehr wrote:
> > Hmmm. My backup procedure, based on earlier discussions in this group,
> > involves blocking all write-access during a pg_dump. That is effectively
> > shutting down the database from my perspective. Is there a quicker way
> > to take a consistent snapshot while still allowing writes?
>
> You mean write commands fail during backup? I never tried doing this but
> have some experience backing up a running Oracle system. Of course you
> cannot allow writes to the data files itself during backup, but they
> shouldn't fail IMO.

There was at least one pre-7.0, pre-24Dec1999 report that writes during
vacuum caused corruption (I couldn't find the post in deja the other
day). I have no idea if that is still true, nor have I tested it.

Regards,
Ed Loehr