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! 🙏
4 Replies
ratty-blushOP•6mo ago
Hey folks, just following up on this — I’m still running into WAL retention issues with Neon + Airbyte CDC.
I posted this earlier but haven’t gotten any replies yet.
Also reached out via Neon’s official support a while ago, but haven’t heard back yet there either.
@Daniel — would really appreciate any guidance here, especially on how to increase WAL retention (or an alternative) since ALTER SYSTEM SET wal_keep_size = '2048MB' gives a permission error.
Thanks in advance!
equal-aqua•6mo ago
Hi @mfhanif In Neon, direct adjustments to this parameter aren’t user-configurable, but Support can assist in making changes on your behalf. I see your ticket in the queue already, so hopefully they get to you very shortly.
ratty-blushOP•5mo ago
Hi @Daniel , I reached out to support a week ago, but I’m still having an issue and haven’t heard back from them. Is it normal for Neon support to take so long to respond?
equal-aqua•5mo ago
Hi @mfhanif I see your ticket. Looks like it was closed previously then reopened. I'll ping the team.