Skip to content

Metadata Files

During Operation, Debezium Runner engine produces metadata files under $PGDATA/pg_synchdb. Currently 2 types of metadata files are generated and persisted: * offset file: contains the offset to resume the replication operation at start up * schema history file: contains the schema information to build all the tables for a replication. This is created during the initial data snapshot sync and can be updated during operation.

These metadata filenames consist of:

  • (connector type)_(connector name)_offsets.dat

  • (connector type)_(connector name)_schemahistory.dat

ls $PGDATA/pg_synchdb
mysql_mysqlconn_offsets.dat        sqlserver_sqlserverconn_offsets.dat
mysql_mysqlconn_schemahistory.dat  sqlserver_sqlserverconn_schemahistory.dat

These binary files' contents can be viewed with hexdump command:

hexdump -C $PGDATA/pg_synchdb/mysql_mysqlconn_offsets.dat
hexdump -C $PGDATA/pg_synchdb/mysql_mysqlconn_schemahistory.dat

Reset Connector

A connector can be reset (re-copy and re-synchronize) specified tables, simply by:

  • stop the connector
  • Remove both the offsets and schemahistory file
  • start the connector