pgcopydb icon indicating copy to clipboard operation
pgcopydb copied to clipboard

pgcopydb clone is not honouring extension requirements

Open arajkumar opened this issue 1 year ago • 0 comments

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.

arajkumar avatar Jul 25 '24 09:07 arajkumar