ar bg de en es fr id it nl pl pt sv tr zh

pgbouncer

May Linux Patch Wednesday

Alexander Leonov

May Linux Patch Wednesday. A total of 1,638 vulnerabilities (474 in the Linux kernel). For comparison, in April there were 1,035 vulnerabilities (a record!). And this time it turns out to be a record again, more than one and a half times higher! The acceleration is both impressive and alarming....

How Blocking-Lock Brownouts Can Escalate from Row-Level to Complete System Outages

Jeremy

This article is a shortened version. For the full writeup, go to https://github.com/ardentperf/pg-idle-test/tree/main/conn_exhaustion This test suite demonstrates a failure mode when application bugs which poison connection pools collide with PgBouncers that are missing peer config and...

Moving tables across PostgreSQL instances

Anantha Kumaran

At work, we recently had to move a few tables from one PostgreSQL instance to another. In my previous post, I discussed how to use Google’s Database Migration Service (DMS) to migrate data from one instance to another. Unfortunately, that option was not available here, since DMS only allows the...