Re: Option to dump foreign data in pg_dump - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Option to dump foreign data in pg_dump
Date
Msg-id 9FABF670-7F3B-4FDD-9D73-0EABF785C8DB@yesql.se
Whole thread Raw
In response to Option to dump foreign data in pg_dump  (Luis Carril <luis.carril@swarm64.com>)
Responses Re: Option to dump foreign data in pg_dump
Re: Option to dump foreign data in pg_dump
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Option to dump foreign data in pg_dump
Next
From: Tom Lane
Date:
Subject: Re: subscriptionCheck failures on nightjar