Questions icon indicating copy to clipboard operation
Questions copied to clipboard

pgcopydb copy command fails to create a logical replication slot

Open DBA15 opened this issue 1 year ago • 1 comments

Hi Team, As part of migration, we are using pgcopydb to initiate database copy from source ( PostgreSQL 10) to destination ( PostgreSQL 15). The destination server is being installed with pgcopydb packages .

Kindly assist me on the below mentioned error.

Error:

INFO copydb.c:105 Using work dir "/tmp/pgcopydb" ERROR pgsql.c:3664 Failed to send CREATE_REPLICATION_SLOT command: ERROR pgsql.c:2815 [SOURCE 26950] [58P01] ERROR: could not access file "test_decoding": No such file or directory ERROR pgsql.c:2829 [SOURCE 26950] Context: CREATE_REPLICATION_SLOT "pgcopydb" LOGICAL "test_decoding" ERROR snapshot.c:423 Failed to create a logical replication slot and export a snapshot, see above for details

DBA15 avatar Jun 20 '24 19:06 DBA15

Could someone please advise me whether pgcopydb is supported to copy data from PostgreSQL 10 version ?

pgcopydb ping INFO Running pgcopydb version 0.15 from "/usr/pgsql-15/bin/pgcopydb" INFO Successfully could connect to source database Postgres 10.23 at "postgres://[email protected]:5432/DB1?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" INFO Successfully could connect to target database Postgres 15.3 at "postgres://[email protected]:5432/DB1?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60"

INFO copydb.c:105 Using work dir "/tmp/pgcopydb" ERROR pgsql.c:3664 Failed to send CREATE_REPLICATION_SLOT command: ERROR pgsql.c:2815 [SOURCE 16105] [58P01] ERROR: could not access file "test_decoding": No such file or directory ERROR pgsql.c:2829 [SOURCE 16105] Context: CREATE_REPLICATION_SLOT "pgcopydb" LOGICAL "test_decoding" ERROR snapshot.c:423 Failed to create a logical replication slot and export a snapshot, see above for details

DBA15 avatar Jul 09 '24 11:07 DBA15