toluaina / pgsync

Postgres to Elasticsearch/OpenSearch sync
https://pgsync.com
MIT License
1.11k stars 174 forks source link

Max_replication_slots value and Checkpoint file generation #421

Closed accelq closed 1 year ago

accelq commented 1 year ago

PGSync version: Latest

Postgres version: 10

Elasticsearch version: 8.6.2

Redis version: 6.0.16

Python version: 3.11.2

Problem Description:

  1. Can you let me know the minimum number of replication slots required in max_replication_slots field?
  2. During execution of bootstrap command it says no checkpoint file found? What shall I do here? Is it a setup or something I need to perform? image https://pgsync.com/getting-started/setup/

Error Message (if any): Here it says max_replication_slots = 1, is minimum required. But during run of bootstrap -c command it fails due to the reason it tries to create more slots one with name _tmp_ and one more.

toluaina commented 1 year ago

Hi.

Also what is you schema structure?