Datapunt Amsterdam postgres table partitioning module
Project description
# pg_partition
Utility to partition new/existing PostgreSql database tables. Data can be migrated. Only date range partition type is supported.
Required environment variables:
```
DATABASE_HOST : hostname/ip of the PostgreSql server
DATABASE_NAME : database to operate on
DATABASE_USER : PostgreSql login
DATABASE_PASSWORD : PostgreSql password
```
#### Install ####
```
pip install -r requirements.txt
```
#### Usage ####
```
usage: pg_partition.py [-h] {create,add} ...
positional arguments:
{create,add}
optional arguments:
-h, --help show this help message and exit
```
#### Create Usage ####
```
usage: pg_partition.py create [-h] [--type {day,week,month}] table column
positional arguments:
table table to be partitioned
column column to be used for range
optional arguments:
-h, --help show this help message and exit
--type {day,week,month}
```
#### Add Usage ####
```
usage: pg_partition.py add [-h] [--num NUM] [--date DATE]
table {day,week,month}
positional arguments:
table table to be partitioned
{day,week,month}
optional arguments:
-h, --help show this help message and exit
--num NUM partitions to create
--date DATE start date (yyyymmdd)
```
#### Creating partitions ####
```
# Convert 'table' to a range partitioned table by 'column'
# No data is migrated
python pg_partition.py create table column
# Convert 'table' to a range partitioned table by 'column'
# Data is migrated in week partitions
python pg_partition.py create table column --type week
```
#### Adding partitions ####
```
# Adds 10 day partitions starting from 20180101 to 'table'
python pg_partition.py add table day --num 10 --date 20180101
```
Utility to partition new/existing PostgreSql database tables. Data can be migrated. Only date range partition type is supported.
Required environment variables:
```
DATABASE_HOST : hostname/ip of the PostgreSql server
DATABASE_NAME : database to operate on
DATABASE_USER : PostgreSql login
DATABASE_PASSWORD : PostgreSql password
```
#### Install ####
```
pip install -r requirements.txt
```
#### Usage ####
```
usage: pg_partition.py [-h] {create,add} ...
positional arguments:
{create,add}
optional arguments:
-h, --help show this help message and exit
```
#### Create Usage ####
```
usage: pg_partition.py create [-h] [--type {day,week,month}] table column
positional arguments:
table table to be partitioned
column column to be used for range
optional arguments:
-h, --help show this help message and exit
--type {day,week,month}
```
#### Add Usage ####
```
usage: pg_partition.py add [-h] [--num NUM] [--date DATE]
table {day,week,month}
positional arguments:
table table to be partitioned
{day,week,month}
optional arguments:
-h, --help show this help message and exit
--num NUM partitions to create
--date DATE start date (yyyymmdd)
```
#### Creating partitions ####
```
# Convert 'table' to a range partitioned table by 'column'
# No data is migrated
python pg_partition.py create table column
# Convert 'table' to a range partitioned table by 'column'
# Data is migrated in week partitions
python pg_partition.py create table column --type week
```
#### Adding partitions ####
```
# Adds 10 day partitions starting from 20180101 to 'table'
python pg_partition.py add table day --num 10 --date 20180101
```
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for datapunt-pg-partitioning-2019.2.27.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7e0c5e2ea58768e06a95485153544b94f1d1c4c380d840b327873789f7db788d |
|
MD5 | 608ceccfe9afcae699e06c4fbd714729 |
|
BLAKE2b-256 | 050c9cd7cd4f491850e0bc448a5664eba440d05fa94c3793782ac9f943378f9e |
Close
Hashes for datapunt_pg_partitioning-2019.2.27.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0db846da5ea39163c888e8dda4c59cc234545fd1cc0e817bc50fb91d8399a6c6 |
|
MD5 | 5fe1fe8e3c286ca7612b5d5d844f06ab |
|
BLAKE2b-256 | 9d60706a64de884a5cba0e60572feac1b2e91480eccb144f31afa66bcd04bc39 |