Re: Adding WHERE clause to pg_dump

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Adding WHERE clause to pg_dump
Дата
Msg-id 1217064956.3894.1115.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Adding WHERE clause to pg_dump  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Adding WHERE clause to pg_dump  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Fri, 2008-07-25 at 12:38 -0700, Joshua D. Drake wrote:

> Gained. Code complexity. 

Hardly, patch is very small. I would recognise that as a factor
otherwise.

> What I see is a recipe for inconsistent, un-restorable backups without a
> user realizing what they have done.

I agree on the backup side, but then who would extract just a portion of
their data for backup? It would be no backup at all. 

If you did use this as part of an incremental backup scheme, then they
would have to test it (just like any backup method). Incremental backups
rarely have self-consistency except as part of a greater whole.

As a dev tool it makes sense.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Transaction-controlled robustness for replication
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Research/Implementation of Nested Loop Join optimization