Re: PG_DUMP and table locking in PG7.4

Поиск
Список
Период
Сортировка
От Yann Michel
Тема Re: PG_DUMP and table locking in PG7.4
Дата
Msg-id 20051116003432.GA4824@zoom.spline.inf.fu-berlin.de
обсуждение исходный текст
Ответ на PG_DUMP and table locking in PG7.4  (Yann Michel <yann-postgresql@spline.de>)
Ответы Re: PG_DUMP and table locking in PG7.4  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: PG_DUMP and table locking in PG7.4  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: MERGE vs REPLACE
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [JDBC] prepareThreshold=1 and statement.executeBatch() ??