| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Scot Kreienkamp <SKreien(at)la-z-boy(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: question about pg_dump |
| Date: | 2009-10-22 14:45:11 |
| Message-ID: | 2f4958ff0910220745u5e093660s4fea120d818458@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 22, 2009 at 3:42 PM, Scot Kreienkamp <SKreien(at)la-z-boy(dot)com>wrote:
> Hi everyone,
>
>
>
> I have a question about pg_dump backups. Will changes made in the database
> made during a pg_dump operation be reflected in the dumped datafile? Or is
> the data the exact dataset that was in the database as of the start of the
> backup?
>
> pg_dump opens transaction, on a serializable isolation level. In short, it
is the proper full isolation level (as oppose to the default one: "read
committed"). It can cause locks up on database, but the idea is that the
dump it self is a snapshot, and is fully atomic.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-10-22 14:46:47 | Re: leak in libpq, getpwuid |
| Previous Message | Tom Lane | 2009-10-22 14:43:05 | Re: FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so |