Re: pg_dump consistent on live database with 7.0.3 ? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_dump consistent on live database with 7.0.3 ?
Date
Msg-id Pine.LNX.4.30.0103112209531.809-100000@peter.localdomain
Whole thread Raw
In response to pg_dump consistent on live database with 7.0.3 ?  (Rob van Nieuwkerk <robn@verdi.et.tudelft.nl>)
List pgsql-hackers
Rob van Nieuwkerk writes:

> But I still have some worries: is it OK to run pg_dump on *live* databases ?

Yes.

> Do you get consistent dumps from it when there is inserting and updating
> going on ?

Yes.

>    "Dumps created by pg_dump are internally consistent, that is, updates
>     to the database while pg_dump is running will not be in the dump."
>
> That looks great.  But we are using v7.03.  Does this mean that the v7.1
> documentation is just more detailed and that the same applies to v7.03 ?

Yes.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Rob van Nieuwkerk
Date:
Subject: pg_dump consistent on live database with 7.0.3 ?
Next
From: Franck Martin
Date:
Subject: RE: doxygen & PG