search

toluaina / pgsync

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

Deactive Replications Slots | APM tool alert #378

Open orangehaired opened 1 year ago

orangehaired commented 1 year ago

PGSync version: Version: 2.3.2

Postgres version: PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

Elasticsearch version: 8.4.2

Redis version: Redis server v=5.0.7 sha=00000000:0 malloc=jemalloc-5.2.1 bits=64 build=66bd629f924ac924

Python version: 3.8

Problem Description:

select * from pg_replication_slots;

I see two slots with "active:false". Are these slots consumed by pgsync? Btw sync two tables to elasticsearch.

toluaina commented 1 year ago

Yes those slots are created and used by pgsync. they are created when you run the bootstrap command. if you no longer wish to use a configured schema you can tear it down with bootstrap -t -c schema.json