Operations
Zero-Downtime PostgreSQL Major Upgrade | Logical Replication
Move PostgreSQL 14 to 16, 17 or 18 with seconds of downtime using logical replication: sequences, replica identity, WAL slots, Patroni, cutover and rollback.
Based in Saudi Arabia
Worlber Insights · Engineering blog
Runbooks and deep dives from the engineers who run production databases.
High availability, backup and recovery, performance tuning, security, and cloud databases — written by the people on call for them.
Lead story · Security
PostgreSQL audit logging that a superuser can't quietly rewrite
pgAudit records what a DBA did, but a superuser can switch it off or edit the files. How to close those gaps for NCA ECC 2-12, and where PGEE fits.
Latest guides
All guides
PostgreSQL
Live Dashboards vs. OLTP PostgreSQL: What GPU Acceleration Changes
Dashboards slowing your OLTP PostgreSQL? What GPU acceleration in CYBERTEC PGEE GPU Edition changes, what stays the same, and when it is the wrong fit.
PostgreSQL
Your test database is a copy of production, and that is the problem
Production data ends up in dev and test databases. Here is how masking works in CYBERTEC PGEE, and where it fits in a release pipeline.
Your test database is a copy of production, and that is the problem
Production data ends up in dev and test databases. Here is how masking works in CYBERTEC PGEE, and where it fits in a release pipeline.
300 GB deleted in seconds: what GitLab's database incident still teaches us
GitLab lost six hours of production database changes after an engineer deleted the primary PostgreSQL data directory. The failure chain shows what broke, what should have been done, and how pg_hardstorage can reduce the damage today.
Moving off SQL Server without rewriting the application
Babelfish translates T-SQL over the TDS protocol so many SQL Server apps run on PostgreSQL unchanged. Where it works, where it stops, how to scope it.
PostgreSQL data masking: keeping production data out of test copies
How column-level masking in CYBERTEC PGEE keeps live customer data out of test and staging copies, and the limits worth knowing first.
You cannot migrate a database estate you have never counted
Why an accurate database inventory decides migration cost and timeline, and how Worlber's free PG-Inventory tool maps a PostgreSQL estate.
PostgreSQL in production: what to settle after the proof of concept works
A proof of concept with PostgreSQL is easy to pass. Five operational decisions decide whether the same database is still quiet two years later.
Archive