| 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: | Whole Thread | Raw Message | 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 |