is there anything planned in terms of updating the current PostgreSQL Version from 9.6 to anything newer ?
Asking because AWS has set a deadline for Support 9.6 RDS Instances until Jan 18, 2022 and it would be pretty neat to have an idea if somethings needs to be rethought in the Architecture.
Upgrading PostgreSQL is definitely on our To Do list, but there are a few bumps in the road. The first is that a glibc upgrade causes big problems for sort in PostgreSQL, which we have to work around first. We have changed our replication very recently as a first step towards getting to a newer PostgreSQL. As for exactly when that will happen, I’m not totally certain, but it is actively being worked on.
As you can imagine, we have to be very careful with this as it’s fine and dandy for us to manage our own PostgreSQL, but to introduce a breaking change into On-Prem Sentry would be bad for everyone. Once we get it sorted for our own installations, we’ll get On-Prem Sentry sorted as well.
Oh, btw we are going to be adding a custom plugin for Postgres into our setup for a service called “CDC” , short for Change Data Capture, which pipes Postgres events to Clickhouse for faster processing on some dimensions.
Don’t think this would work with RDS so you may want to consider alternatives anyway.
Our production environment is actually quite similar to the On-Prem setup, but scaled horizontally at basically every spot and with more redundancies put in place. There is some secret sauce, but nothing too far deviated as that would make maintaining the different repos more difficult. A key focus for the Operations team right now is to deduplicate work across our various repos to get to a more homogenous state.