Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group