pg_dump/restore --no-tableam
От | Justin Pryzby |
---|---|
Тема | pg_dump/restore --no-tableam |
Дата | |
Msg-id | 20211207153930.GR17618@telsasoft.com обсуждение исходный текст |
Ответ на | tableam options for pg_dump/ALTER/LIKE (Justin Pryzby <pryzby@telsasoft.com>) |
Ответы |
Re: pg_dump/restore --no-table-am
Re: pg_dump/restore --no-tableam |
Список | pgsql-hackers |
I first suggested this a couple years ago. Is it desirable to implement in pg_dump and pg_restore ? It'd be just like --tablespace. On Tue, Jan 28, 2020 at 07:33:17AM -0600, Justin Pryzby wrote: > I made these casual comments. If there's any agreement on their merit, it'd be > nice to implement at least the first for v13. > > In <20190818193533.GL11185@telsasoft.com>, I wrote: > > . What do you think about pg_restore --no-tableam; similar to > > --no-tablespaces, it would allow restoring a table to a different AM: > > PGOPTIONS='-c default_table_access_method=zedstore' pg_restore --no-tableam ./pg_dump.dat -d postgres > > Otherwise, the dump says "SET default_table_access_method=heap", which > > overrides any value from PGOPTIONS and precludes restoring to new AM. > > That appears to be a trivial variation on no-tablespace: > > /* do nothing in --no-tablespaces mode */ > if (ropt->noTablespace) > return; ...
В списке pgsql-hackers по дате отправления: