On Thu, Jun 27, 2024 at 11:05 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:Ron Johnson <ronljohnsonjr@xxxxxxxxx> writes:
> $ pg_restore -v -a -t tapschema.batch_rp4_y2022m08 -Fd --dbname=tap tap
I think what you have to do is write -n tapschema -t batch_rp4_y2022m08That indeed is the solution. Should have seen it in the docs.pg_restore's use of "-t" is inconsistent with other utilities (pg_dump, vacuumdb, reindexdb, clusterdb). That seems to be a design bug.
I suppose writing the extra matching logic for in-file matching was more difficult than doing the same when the data sits in catalogs and you have a regexp operator. Less a bug and more a decision of convenience I suppose. No pressure from me to change it.
On a related note, the third tip refers to an out-of-support version. Shouldn’t we do away with it?
David J.
