Re: PG_DUMP and table locking in PG7.4

From: Yann Michel <yann-postgresql(at)spline(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PG_DUMP and table locking in PG7.4
Date: 2005-11-16 00:34:32
Message-ID: 20051116003432.GA4824@zoom.spline.inf.fu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

On Sun, Nov 13, 2005 at 03:22:23AM +0100, Yann Michel wrote:
>
> I'm using PG_DUMP for backing up a postgres 7.4 database. As I have
> seen, the pg_dump aquires a table lock while dump the table's content.
> What will happen, if I have a basic table and several inherited tables.
> Will the PG_DUMP tool only aquire locks on the inherited tables or on
> the parent-table, too?

Is anyone out there who could answer this question or even give me a
hint about where to read about this if there is any writen things about
that?

Thanks!

Yann

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-11-16 00:47:34 Re: prepareThreshold=1 and statement.executeBatch() ??
Previous Message Bruce Momjian 2005-11-16 00:31:23 Re: MERGE vs REPLACE