Undo_partition.py

Undo_partition.py

undo_partition.py

PostgreSQL Partition Manager

Learn Laravel, React, VueJS and Python
read programming books

Install undo_partition.py

  • Debian apt-get install postgresql-9.6-partman Click to copy
  • Ubuntu apt-get install postgresql-10-partman Click to copy
  • Raspbian apt-get install postgresql-9.6-partman Click to copy

postgresql-9.6-partman

PostgreSQL Partition Manager

pg_partman is a PostgreSQL extension to create and manage both time-based and serial-based table partition sets. Sub-partitioning is also supported. Child table & trigger function creation is all managed by the extension itself. Tables with existing data can also have their data partitioned in easily managed smaller batches. Optional retention policy can automatically drop partitions no longer needed. A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.

postgresql-10-partman

PostgreSQL Partition Manager

postgresql-9.5-partman

PostgreSQL Partition Manager
Install the latest version of undo_partition.py in Debian, Ubuntu and Raspbian from terminal. To install the undo_partition.py just copy the above command for your OS and run into terminal. After you run the command it will grab the latest version of undo_partition.py from the respository and install it in your computer/server.