Use PGmigrate with YugabyteDB YSQL

PGmigrate is a database migration tool with following key features:

• Transactional and non-transactional migrations.
• Callbacks: You can run some DDL on specific steps of the migration process (for example, drop some code before executing migrations, and create it back after migrations were applied).
• Online migrations: You can execute series of transactional migrations and callbacks in a single transaction. So, if something goes wrong, a basic ROLLBACK will bring back the transaction to a consistent state.

Because YugabyteDB's YSQL API is wire-compatible with PostgreSQL, PGmigrate can connect to YugabyteDB just like with PostgreSQL.

Setup

To run the PGmigrate tutorial, do the following:

1. Start a YugabyteDB cluster. Refer to YugabyteDB Prerequisites.

2. Use the following configuration file for PGmigrate:

   propertiesCopy

   callbacks:
       beforeAll:
           - callbacks/beforeAll
       beforeEach:
           - callbacks/beforeEach
       afterEach:
           - callbacks/afterEach
       afterAll:
           - callbacks/afterAll
           - grants
   conn: host=yb_tserver_ip dbname=foodb user=yugabyte password=yugabyte port=5433
   

3. Proceed with the tutorial using the preceding configuration.