Supported operations
Capabilities
Twelve supported PostgreSQL schema operations plus whole-database migration, each evaluated against its own risk profile.
Back to product overviewSupported operations
Twelve schema operations. One trust model.
From everyday DDL needs to table partitioning and major type conversions, each operation is evaluated against its own risk profile and routed through the same strategy engine.
Explore the source codeADD_COLUMNAdd a column
DROP_COLUMNDrop a column
ALTER_COLUMN_TYPEChange a column type
ADD_INDEXAdd an index
DROP_INDEXDrop an index
SET_NOT_NULLApply NOT NULL
ADD_CONSTRAINTAdd a constraint
RENAME_COLUMNRename a column
RENAME_TABLERename a table
ADD_FOREIGN_KEYAdd a foreign key
ADD_GENERATED_COLUMNAdd a generated column
PARTITION_TABLEPartition a table
Automatic strategy selection
It does not use the same method for every change.
pgArchiMigrator selects the safest, lowest-cost path from three execution strategies based on the nature of the change.
Direct DDL
Direct execution for PostgreSQL metadata operations that are fast and safe.
Safe path
Expand & Backfill
Controlled, batched, and observable progress across large data sets.
Safe path
Shadow Table
A logical-replication shadow-table path for the most disruptive changes.
Safe path
New in v2.0.0
Move a whole database, not just a schema.
Database Migration is a second mode next to zero-downtime schema migration: it moves schema and data to a different host, a different cloud provider or a newer PostgreSQL version, built on PostgreSQL's own native logical replication.
Structured connections
Host, port, username, password and database as separate fields instead of a raw connection string.
Schema and table picker
Real schemas and tables listed from the source, with a read-only check against the target before anything starts.
Row-for-row validation
A job only reports itself ready after its data is validated row for row against the source.
Retry with review
Retrying a failed job shows exactly what will be reused, with an editable replication address and no password re-exposed.
Cutover stays yours: pgArchiMigrator prepares and validates the target, but repointing application traffic remains a separate, deliberate step.
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