From: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | Metagration: PostgreSQL migration tool in PL/pgSQL |
Date: | 2020-05-27 21:34:25 |
Message-ID: | CACxu=vLWZZ6iim8DUe8MkJZhmq-bJdDtVZResLewZw1H3MqWpw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
Metagration (https://github.com/michelp/metagration) is a full featured
PostgreSQL migration tool written entirely in PostgreSQL's native PL/pgSQL
scripting language. No external tools or languages are required to migrate
your database and all these features are available using any PostgreSQL
client:
- Up/Down scripts are stored procedures in any pl language.
- No external tools, any PostgreSQL client can manage migration.
- Cloud-friendly single ~400 line SQL file for any PostgreSQL >= 11.
- One simple function for new SQL scripts.
- Procedures can be transactional, and transaction aware.
- Generates Point In Time Recovery restore points before migration.
- Metagration can export/import to/from SQL files.
- Metagrations are just rows so `pg_dump/pg_restore` them.
- Can use pgTAP for powerful migration verification.
- Postgres docker container entrypoint friendly.
Check it out!
From | Date | Subject | |
---|---|---|---|
Next Message | Akshay Joshi | 2020-05-28 10:29:49 | pgAdmin 4 v4.22 released |
Previous Message | Hans-Jürgen Schönig | 2020-05-27 06:25:06 | PostgreSQL TDE 12.3 available |