Re: Option to dump foreign data in pg_dump

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Option to dump foreign data in pg_dump
Дата
Msg-id 20191112151123.GA914@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Option to dump foreign data in pg_dump  (Luis Carril <luis.carril@swarm64.com>)
Ответы Re: Option to dump foreign data in pg_dump
Список pgsql-hackers
On 2019-Nov-12, Luis Carril wrote:

> But, not all foreign tables are necessarily in a remote server like
> the ones referenced by the postgres_fdw.
> In FDWs like swarm64da, cstore, citus or timescaledb, the foreign
> tables are part of your database, and one could expect that a dump of
> the database includes data from these FDWs.

BTW these are not FDWs in the "foreign" sense at all; they're just
abusing the FDW system in order to be able to store data in some
different way.  The right thing to do IMO is to port these systems to be
users of the new storage abstraction (table AM).  If we do that, what
value is there to the feature being proposed here?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Collation versioning
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Missing dependency tracking for TableFunc nodes