Re: pg_restore --no-post-data and --post-data-only

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: pg_restore --no-post-data and --post-data-only
Дата
Msg-id CA+TgmoaW3-WfgBzXsFrPpFFWcAqisSXsa=y3hRGaTN16Ya5kAA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore --no-post-data and --post-data-only  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: pg_restore --no-post-data and --post-data-only  (Jeff Davis <pgsql@j-davis.com>)
Re: pg_restore --no-post-data and --post-data-only  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Fri, Aug 26, 2011 at 11:22 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
>> But we could also add these switches to pg_dump too if people feel it's
>> worthwhile. I haven't looked but the logic should not be terribly hard.
>
> Something like the attached, in fact, which seems pretty simple.

It seems like there are three sets of things you might want here:
pre-data, data, post-data.  So in the end we could end up with:

--pre-data-only
--post-data-only
--data-only
--no-pre-data
--no-post-data
--no-data

And then maybe someone will want just the create index commands and
not the constraint commands.  It seems like it might be more elegant
to come up with a single switch where you can list which things you
want:

--sections='predata data'
--sections='postdata'
--sections='index'

Just thinking out loud....

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: [GENERAL] pg_upgrade problem
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: pg_restore --no-post-data and --post-data-only