Re: Consistent pg_dump's

From: Doug McNaught <doug(at)wireboard(dot)com>
To: alexey(at)serinbol(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Consistent pg_dump's
Date: 2001-03-29 02:48:38
Message-ID: m3k859s321.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexey Rodriguez Yakushev <alexey(at)serinbol(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Rodriguez Yakushev 2001-03-29 02:56:18 Consistent pg_dump's
Previous Message Lincoln Yeoh 2001-03-29 01:07:34 Re: Re: Tables grow in size when issuing UPDATEs! Why??