From: Justin Pryzby <pryzby@telsasoft.com>
To: pgsql-hackers@postgresql.org
Cc: Andres Freund <andres@anarazel.de>
Subject: pg_dump/restore --no-tableam
Date: Tue, 7 Dec 2021 09:39:30 -0600
Message-ID: <20211207153930.GR17618@telsasoft.com> (raw)
In-Reply-To: <20200128133317.GZ13621@telsasoft.com>
References: <20200128133317.GZ13621@telsasoft.com>
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;
...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pryzby@telsasoft.com, andres@anarazel.de
Subject: Re: pg_dump/restore --no-tableam
In-Reply-To: <20211207153930.GR17618@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox