initial slot snapshot too large

[ramkly]

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?

[ahouska]

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.