cybertec-postgresql
initial slot snapshot too large
Most of the time, pg_squeeze is unsuccessful in my databases and returns the error: 'initial slot snapshot too large.' Is there any way to resolve this issue? Currently, wal_keep_size is set to 0, and max_slot_wal_keep_size is set to -1. I’m wondering if adjusting these settings could help resolve the issue?
I wonder if this error is specific to pg_squeeze. Does the same error occur if you run the following?
psql -d 'replication=database dbname=postgres' -c 'CREATE_REPLICATION_SLOT pg_squeeze_test_slot LOGICAL pg_squeeze'
Please do not forget to drop the slot after each test:
psql -d 'replication=database dbname=postgres' -c 'DROP_REPLICATION_SLOT pg_squeeze_test_slot'
I don't think that wal_keep_size or max_slot_wal_keep_size can fix the issue. These settings can cause removal of WAL which pg_squeeze still needs, in which case the process executing pg_squeeze should be terminated.
