Re: PostgreSQL capabilities

Alex Pilosov wrote:
>
> > http://networkdna.com/database/index.html mentions that PostgreSQL is
> > capable of "Online backup". What does that exactly mean?
>
> It means Postgres can do a reliable backup (a consistent snapshot) of a
> database without shutting down the database.

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?

Regards,
Ed Loehr