Re: Option to dump foreign data in pg_dump

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: Option to dump foreign data in pg_dump
Дата
Msg-id 9FABF670-7F3B-4FDD-9D73-0EABF785C8DB@yesql.se
обсуждение исходный текст
Ответ на Option to dump foreign data in pg_dump  (Luis Carril <luis.carril@swarm64.com>)
Ответы Re: Option to dump foreign data in pg_dump  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Option to dump foreign data in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> On 28 Jun 2019, at 16:49, Luis Carril <luis.carril@swarm64.com> wrote:

>   pg_dump ignores the dumping of data in foreign tables
>   on purpose, this patch makes it optional as the user maybe
>   wants to manage the data in the foreign servers directly from
>   Postgres. Opinions?

Wouldn’t that have the potential to make restores awkward for FDWs that aren’t
writeable?  Basically, how can the risk of foot-gunning be minimized to avoid
users ending up with dumps that are hard to restore?

cheers ./daniel


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Option to dump foreign data in pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: subscriptionCheck failures on nightjar