ERROR: permission denied to set parameter wal_keep_size
Hey everyone! 
I’m using Neon as the PostgreSQL source for Airbyte (CDC mode), and I’m getting this error:
“Saved offset is before replication slot’s confirmed LSN. Please reset the connection, and then increase WAL retention…”
I tried running:
ALTER SYSTEM SET wal_keep_size = '2048MB';
But got:
“ERROR: permission denied to set parameter wal_keep_size”
Looks like I don’t have permission to change this on Neon.
Has anyone run into this before? Any workaround to increase WAL retention in Neon or keep the WAL logs longer for Airbyte?
Would appreciate any tips!
I’m using Neon as the PostgreSQL source for Airbyte (CDC mode), and I’m getting this error:
“Saved offset is before replication slot’s confirmed LSN. Please reset the connection, and then increase WAL retention…”
I tried running:
ALTER SYSTEM SET wal_keep_size = '2048MB';
But got:
“ERROR: permission denied to set parameter wal_keep_size”
Looks like I don’t have permission to change this on Neon.
Has anyone run into this before? Any workaround to increase WAL retention in Neon or keep the WAL logs longer for Airbyte?
Would appreciate any tips!
