pgcopydb
pgcopydb copied to clipboard
pgcopydb clone is not honouring extension requirements
I want to maintain the extension version as same as on the source. I tried using --requirements with pgcopydb clone, but it doesn't work.
pgcopydb list extensions --requirements --json > /tmp/reqs.json
pgcopydb clone --no-acl --no-owner --plugin wal2json --restart --drop-if-exists --fail-fast --requirements /tmp/reqs.json
By default, the pre-data restore performs CREATE EXTENSION IF NOT EXISTS <ext_name>;, which causes the extension to created with the latest version available on the target.