news
PostgreSQL News: pgCluu v5.0, BackupDrill, pgrecon, SafeGrd
-
PostgreSQL ☛ pgCluu v5.0 has been released
pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL server using psql and sar, a reports builder that will generate all HTML and charts output.
Version 6.0 of pgCluu have been released, this is a major release that adds several new features and reports. It also fixes issues reported since the last release.
-
PostgreSQL ☛ BackupDrill: open-source Supabase Postgres backups with automated restore drills
BackupDrill backs up Supabase Postgres databases to a bucket you own, then restores each backup into a throwaway PostgreSQL instance to check it restores.
Most teams find out whether their pg_dump backups work on the day they need them. BackupDrill makes that check a routine step.
-
PostgreSQL ☛ pgrecon: open-source Oracle to PostgreSQL migration assessment and schema conversion
pgrecon, an Apache-2.0 licensed Oracle to PostgreSQL migration assessment and schema conversion tool, is now public. The current release is 0.7.3.
pgrecon works entirely offline. A reviewable, read-only SQL*Plus script produces a dump, and the tool builds a local inventory from it; it never connects to either database. A deterministic rule engine runs 80 rules over the inventory, covering data types and length semantics, storage and partitioning, PL/SQL constructs (parsed with a full grammar, not pattern matching), supplied-package usage, schema objects, and performance posture, each with line-level evidence and remedy guidance. An effort estimator produces person-day ranges from named components with stated assumptions.
-
PostgreSQL ☛ SafeGrd: PostgreSQL backups that are restored and checked on a schedule
SafeGrd is a new backup service for PostgreSQL 13 and later that restores every backup on a schedule and checks the row counts.
It takes a backup, restores it later into memory or a throwaway database, and counts what came back, so you find out a backup is broken before you need it.