Re: Option to dump foreign data in pg_dump
| От | Pavel Stehule |
|---|---|
| Тема | Re: Option to dump foreign data in pg_dump |
| Дата | |
| Msg-id | CAFj8pRAe-1RH=zpxce4yPoosPv3HEUNA1DBRk4gxkMQ-eUuExg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Option to dump foreign data in pg_dump (Daniel Gustafsson <daniel@yesql.se>) |
| Список | pgsql-hackers |
pá 28. 6. 2019 v 17:17 odesílatel Daniel Gustafsson <daniel@yesql.se> napsal:
> 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?
It can be used for migrations, porting, testing (where FDW sources are not accessible).
pg_dump has not any safeguards against bad usage. But this feature has sense only if foreign tables are dumped as classic tables - so some special option is necessary
Pavel
cheers ./daniel
В списке pgsql-hackers по дате отправления: