pá 28. 6. 2019 v 17:17 odesílatel Daniel Gustafsson <dan...@yesql.se> napsal:
> > On 28 Jun 2019, at 16:49, Luis Carril <luis.car...@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 > >
