| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Hisham Al-Shurafa <halshurafa(at)rim(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump integrity question |
| Date: | 2003-10-02 19:37:39 |
| Message-ID: | 20031002193739.GC18417@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 02, 2003 at 15:10:52 -0400,
Hisham Al-Shurafa <halshurafa(at)rim(dot)net> wrote:
> Hello,
>
>
> Anyone know if it is safe to do a pg_dump on a database while other programs might be making changes to the data? Is the integrity of the dumped data guaranteed? Does pg_dump lock the whole database when reading from it?
It is safe to use pg_dump while other people are using the DB. It will
dump the DB as it was when the dump started so that the dump is a consistant
view of the DB. It does not lock the DB while doing this because with MVCC
it doesn't have to.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arguile | 2003-10-02 20:17:57 | Re: migrate from postgres to mysql |
| Previous Message | Bruno Wolff III | 2003-10-02 19:35:56 | Re: Type of application that use PostgreSQL |