Re: Consistent pg_dump's - Mailing list pgsql-general

From Doug McNaught
Subject Re: Consistent pg_dump's
Date
Msg-id m3k859s321.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Consistent pg_dump's  (Alexey Rodriguez Yakushev <alexey@serinbol.com>)
Responses Re: Consistent pg_dump's  (Alexey Rodriguez Yakushev <alexey@serinbol.com>)
List 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

pgsql-general by date:

Previous
From: Alexey Rodriguez Yakushev
Date:
Subject: Consistent pg_dump's
Next
From: "Russell Hires"
Date:
Subject: Re: Determine Time in other Time Zone