pgcopy clone with no filter condition
when I run this commend without any filter conditions:
root@iv-yd33vnf30gqc6ilej4j3:/tmp# pgcopydb clone
but the logs show below:
18:28:36.652 1064 INFO /usr/bin/pg_dump -Fc --snapshot 00000003-00000274-1 --section pre-data --exclude-schema bookings --exclude-schema bookings --file /tmp/pgcopydb/schema/pre.dump 'postgres://[email protected]:5436/demo?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60'
May I know why I am not add any filter conditon but the pgcopydb add a filter --exclude-schema bookings
@rudonx what version of pgcopydb was this? It looks like it might be skipping an extension schema, which was fixed here: https://github.com/dimitri/pgcopydb/commit/82c406c81259b96d104c0b662ab975191ae853f9#diff-66883d8b337cf7ecc0ba3366792d6bad71bbbfffd1477153ea5350096c91af64L454 could you test using the newer version?
the version is
root@iv-yd33vnf30gqc6ilej4j3:~# pgcopydb --version 19:54:55.416 1653027 INFO Running pgcopydb version 0.15-1.pgdg120+1 from "/usr/bin/pgcopydb" pgcopydb version 0.15-1.pgdg120+1 compiled with PostgreSQL 16.1 (Debian 16.1-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit compatible with Postgres 11, 12, 13, 14, 15, and 16