Transaction ID wraparound error

Up until a few weeks ago I thought I will never see transaction ID wraparound error on some of my databases. Not that I would miss it but it felt like something with very very low possibility of occurrence. Well, not any more… We implemented logical replication...

Block some user from connecting into PostgreSQL

Lately I started to see in postgresql log brute force attacks on postgres user: 2019-03-07 08:12:57.064 UTC [24942] postgres@postgres FATAL: password authentication failed for user “postgres” 2019-03-07 08:12:57.064 UTC [24942] postgres@postgres DETAIL:...