Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgcopy clone with no filter condition #741

Open
rudonx opened this issue Apr 16, 2024 · 2 comments
Open

pgcopy clone with no filter condition #741

rudonx opened this issue Apr 16, 2024 · 2 comments

Comments

@rudonx
Copy link

rudonx commented Apr 16, 2024

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

@kbarber
Copy link
Contributor

kbarber commented May 8, 2024

@rudonx what version of pgcopydb was this? It looks like it might be skipping an extension schema, which was fixed here: 82c406c#diff-66883d8b337cf7ecc0ba3366792d6bad71bbbfffd1477153ea5350096c91af64L454 could you test using the newer version?

@rudonx
Copy link
Author

rudonx commented May 8, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants