Re: Option to dump foreign data in pg_dump
Daniel Gustafsson <daniel@yesql.se>
From: Daniel Gustafsson <daniel@yesql.se>
To: Luis Carril <luis.carril@swarm64.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2019-06-28T15:17:01Z
Lists: 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
Commits
-
pg_dump: Allow dumping data of specific foreign servers
- 2f9eb3132094 13.0 landed