PDO + PgBouncer Testing Suite

Testing PostgreSQL PDO compatibility with PgBouncer in transaction pooling mode

Status: Connected ✓

PostgreSQL: PostgreSQL 17.7 (Ubuntu 17.7-3.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit

PHP: 7.4.33

Connection: 127.0.0.1:6432 (PgBouncer) → sandbox database

1. Prepared Statements Test

Tests if PDO prepared statements work correctly through PgBouncer. In transaction pooling mode, server-side prepared statements may not persist across transactions.

2. WITH Queries (CTE) Test

Tests Common Table Expressions (WITH queries) through PgBouncer. CTEs should work fine, but combining them with prepared statements might reveal issues.

3. Transactions Test

Tests transaction handling (BEGIN, COMMIT, ROLLBACK) through PgBouncer. This is critical since PgBouncer in transaction mode pools at the transaction boundary.