PG Migrate

About

Database migration tool for PostgreSQL written in Rust.

Features

• Create migration
• Upgrade / Downgrade database
• Get current migration
• Get head migration
• Get migrations history

Installation

cargo install pg_migrate

Set up the database URL in the environment variable DATABASE_URL.

DATABASE_URL=postgresql://username:password@localhost/dbname

CLI Usage

• Create migration:

cargo run --bin pg_migrate_cli -- new <migration name>

• Upgrade / Downgrade: There is multiple options to upgrade or downgrade the database:

  • Upgrade to the latest migration:

    cargo run --bin pg_migrate_cli -- upgrade head
    

  • Upgrade / Downgrade to a specific migration by migration id:

    cargo run --bin pg_migrate_cli -- upgrade/downgrade migration-id <migration-id>
    

  • Upgrade / Downgrade by number of migrations:

    cargo run --bin pg_migrate_cli -- upgrade/downgrade number <number>
    

• Get head:

cargo run --bin pg_migrate_cli -- head

• Get current migration:

cargo run --bin pg_migrate_cli -- current

• Get migrations history

cargo run --bin pg_migrate_cli -- history