On Thursday, June 27, 2024, Ron Johnson <
ronljohnsonjr@gmail.com> wrote:
Ron Johnson <ronljohnsonjr@gmail.com> 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_y2022m08
That 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.