Matthias van de Meent comments

Results 68 comments of


                                            Matthias van de Meent

Add GUC controlling whether to pause recovery if some critical GUCs at replica have smaller value than on primary

>> What's the behaviour when we see >max_connections concurrently active transactions on a hot standby? > > I have added test for this case. Transactions are normally applied. It is...

Add GUC controlling whether to pause recovery if some critical GUCs at replica have smaller value than on primary

> But I failed to reproduce the problem with recovery failure with max_)connections at primary equal to 100 and at replica - just 5. I run 90 parallel transactions and...

Add GUC controlling whether to pause recovery if some critical GUCs at replica have smaller value than on primary

OK, I've found a case where we hit the `elog(ERROR)` in KnownAssignedXidsAdd on the secondary. Configuration: Primary: ``` max_connections=1000 ``` Secondary: ``` max_connections=2 autovacuum_max_workers=1 max_worker_processes=5 max_wal_senders=1 superuser_reserved_connections=0 ``` Execute 650+...

Add GUC controlling whether to pause recovery if some critical GUCs at replica have smaller value than on primary

@knizhnik can you verify my findings?

Add GUC controlling whether to pause recovery if some critical GUCs at replica have smaller value than on primary

> As far as replica is always restarted from most recent LSN, it skips this transactions which cause this failure and most likely will be able to process. I don't...

Update Debain base images

It's been a while since you opened the PR, but unless I'm using the available information incorrectly the hashes don't seem to match the latest versions of the Debian images,...

chore: support hadron JWT set-up

> (original PR is #179). I have some serious doubts about that.

Enable the PostGIS test

The tests failed, but there's no failure reported in Allure. Is that an oversight?