Add db_converter - Githubissues

dhamaniasad / awesome-postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

http://dhamaniasad.github.io/awesome-postgres

Creative Commons Zero v1.0 Universal

9.98k stars 805 forks source link

Add db_converter #304

Open O2eg opened 3 years ago

O2eg commented 3 years ago

db_converter is an open-source database migration tool for PostgreSQL 9.6+ designed for high loaded installations.

Tasks that can be solved using db_converter:

Transactional modification of data of any volume
Database structure changing with locks control
System and application notifications via mattermost (or any other messenger)
Database maintenance (deleting old data, creating new schemas, etc.)
Export data in csv format into encrypted archive

The key features are:

Only plain SQL scripts with placeholders
Parallel processing of several databases
Handling of the locks to avoid impact on the regular workload