Re: Consistent pg_dump's

Doug McNaught <doug@wireboard.com>

From: Doug McNaught <doug@wireboard.com>
To: alexey@serinbol.com
Cc: pgsql-general@postgresql.org
Date: 2001-03-29T02:48:38Z
Lists: pgsql-general
Alexey Rodriguez Yakushev <alexey@serinbol.com> writes:

> Are pg_dump's consistent? Do i have to shutdown the system in order
> to make a pg_dump? What other alternatives are for backing up a
> database without shutting down the system in order to allow
> consistent backups?  Another question: Can the rows that haven't
> been vaccumed yet retrieved?

Yes.  No.  None.  Theoretically, but no tools exist AFAIK.

HTH.  HAND.

-Doug