pgArchiHub logo
pgArchiHubA DATAIOTECH product family

PostgreSQL zero-downtime migration

Product / 01pgArchiMigratorv2.0.0Community Edition

PostgreSQL schema changes, without the downtime.

pgArchiMigrator analyzes the change, automatically selects a safe strategy, and shows exactly what will happen before it touches your database. v2.0.0 adds a second mode: moving an entire database to another PostgreSQL instance.

Download free from GitHubSee how it works
DRY-RUN/STRATEGY ROUTER/DATABASE MIGRATION/LOCK MONITOR/AUDIT TRAIL
Migration plane / readyPG / 12—18
Technical architecture showing a live PostgreSQL schema moving to a new schema without interruption

Strategy router

Change ready for a safe route

READY

Dry-run preview

Enabled

Operation types

12 supported

PostgreSQL

12 — 18

Apache-2.0 / Community Edition

A visible, controlled, open-source trust layer for schema changes and database moves.

PREVIEW/STRATEGY SELECTION/DATABASE MIGRATION/LOCK MONITOR/AUDIT TRAIL/CHECKPOINT/WEB DASHBOARD

Release notes

Latest updates

A single announcement stream for every pgArchiHub product, tagged so you can see at a glance what changed and where.

RELEASE/pgArchiMigrator/v2.0.0

Database Migration, four new operations, redesigned dashboard

v2.0.0 adds a second migration mode that moves an entire database to another PostgreSQL instance over native logical replication, plus RENAME_TABLE, ADD_FOREIGN_KEY, ADD_GENERATED_COLUMN and PARTITION_TABLE, a redesigned dashboard shell and one-line install scripts. From this version on, pgArchiMigrator ships as the Community Edition, developed by ArchiOrbit Labs.

RELEASE/pgArchiMigrator/v1.0.0

First stable release

Automatic strategy routing, dry-run preview, lock monitor and JSON audit log are now stable, with the web dashboard shipping in the container image.

COMPATIBILITY/pgArchiMigrator/v0.9.0

PostgreSQL 18 in the CI matrix

The full 12—18 version range is now exercised on every commit; older versions are refused instead of risking full-table rewrites.

PROJECT/pgArchiHub/—

Open-source roadmap published

Shadow-table replication improvements and a CLI-first workflow are next on the public roadmap.

Products

One product line for PostgreSQL operations.

pgArchiHub builds focused, open-source tools for teams that run PostgreSQL in production. pgArchiMigrator is the first of them.

Products / 01

pgArchiMigrator

Zero-downtime PostgreSQL schema changes and whole-database moves, with preview, strategy routing and verification.

v2.0.0Community EditionApache 2.0PostgreSQL 12—18
Open the product page

Products / 02

pgArchiHub builds focused, open-source tools for teams that run PostgreSQL in production. pgArchiMigrator is the first of them.

Downloadable resources

See the decision engine at a glance.

An infographic on how the decision engine routes every schema change, plus the v2.0 quick reference cheatsheet.

InfographicpgArchiMigrator v2.0.0
pgArchiMigrator decision engine infographic: 12 operation types routed to three execution strategies.
Download infographic (PNG)

Quick reference cheatsheet

Quick reference cheatsheet

Install commands, CLI commands, the operation-to-strategy table, roles and dashboard shortcuts on one page.

Download cheatsheet (PNG)

Free and open source

See your next schema change before it happens.

Review the source, try v2.0.0 with Docker or a one-line installer, and bring pgArchiMigrator into your PostgreSQL operations workflow.

Download free from GitHub