Easy dump of partitioned and inherited data

Поиск
Список
Период
Сортировка
От Przemysław Sztoch
Тема Easy dump of partitioned and inherited data
Дата
Msg-id 9ffc4e51-ed98-5831-6c34-0374e53c61f3@sztoch.pl
обсуждение исходный текст
Ответы Re: Easy dump of partitioned and inherited data  (Przemysław Sztoch <przemyslaw@sztoch.pl>)
Список pgsql-hackers
1. Switch --load-via-partition-root is very useful.
Would it be a big deal to add extra information to the
dump custom format so that this switch can be specified from pg_restore level?

2. Another common usability problem is a quick dump of the selected parent table.
It is important that it should includes all inherited tables or subpartitions.
Now you can't just specify -t root-table-name, because you'll usually get an empty data dump.

The list of necessary tables is sometimes very long and, when using timescaledb, partition tables are called not humanly.

--
Przemysław Sztoch | Mobile +48 509 99 00 66

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How do I set a different language to test psql? (/**** QUERY ****/)
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: Possible regression setting GUCs on \connect