BSD Portsdatabases/pg_partman 5.2.2 FreeBSD
PostgreSQL Partition Manager
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- PostgreSQL
- Categories
- databases
- Package size
- 190.2 KiB, 7413.3 KiB installed
Description
pg_partman is an extension to create and manage both time-based and number-based table partition sets. As of version 5.0.1, only built-in, declarative partitioning is supported and the older trigger-based methods have been deprecated.
The declarative partitioning built into PostgreSQL provides the commands to create a partitioned table and its children. pg_partman uses the built-in declarative features that PostgreSQL provides and builds upon those with additional features and enhancements to make managing partitions easier. One key way that pg_partman extends partitioning in Postgres is by providing a means to automate the child table maintenance over time (Ex. adding new children, dropping old ones based on a retention policy). pg_partman also has features to turn an existing table into a partitioned table or vice versa.
A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/pg_partman | 5.2.2 |
| DragonFly | databases/pg_partman | 5.2.2 |
Install
Binary package:
pkg install pg_partmanFrom the ports tree:
cd /usr/ports/databases/pg_partman/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= pg_partman>0:databases/pg_partmanPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 5.2.2 | 5.2.2 | 4.6.0 | 5.2.2 | 5.2.2 |
| FreeBSD:14:quarterly | 5.2.2 | 5.2.2 | n/a | 5.2.2 | 5.2.2 |
| FreeBSD:15:latest | 5.2.2 | 5.2.2 | n/a | 5.2.2 | 5.2.2 |
| FreeBSD:15:quarterly | 5.2.2 | 5.2.2 | n/a | n/a | n/a |
| FreeBSD:16:latest | 5.2.2 | 5.2.2 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Runtime 1
${PYTHON_SITELIBDIR}/psycopg2/__init__.py: databases/py-psycopg2
The full lists below include those, and their dependencies in turn.
Build dependencies 16
Run dependencies 15
No port depends on this one.
Configuration
Options name: databases_pg_partman
| Option | Default | Description |
|---|---|---|
| DOCS | off | Build and/or install documentation |
- USES
- cpe gmake pgsql:14+ python uidfix shebangfix
- Service scripts
- none
Files
pkg-plist 103
- bin/check_unique_constraint.py
- bin/dump_partition.py
- bin/vacuum_maintenance.py
- lib/postgresql/pg_partman_bgw.so
- share/doc/pg_partman/fix_missing_procedures.md
- share/doc/pg_partman/migrate_to_declarative.md
- share/doc/pg_partman/migrate_to_partman.md
- share/doc/pg_partman/pg_partman.md
- share/doc/pg_partman/pg_partman_5.0.1_upgrade.md
- share/doc/pg_partman/pg_partman_howto.md
- share/postgresql/extension/pg_partman--0.1.0--0.1.1.sql
- share/postgresql/extension/pg_partman--0.1.1--0.1.2.sql
- share/postgresql/extension/pg_partman--0.1.2--0.2.0.sql
- share/postgresql/extension/pg_partman--0.2.0--0.3.0.sql
- share/postgresql/extension/pg_partman--0.3.0--0.3.1.sql
- share/postgresql/extension/pg_partman--0.3.1--0.3.2.sql
- share/postgresql/extension/pg_partman--0.3.2--0.4.0.sql
- share/postgresql/extension/pg_partman--0.4.0--0.4.1.sql
- share/postgresql/extension/pg_partman--0.4.1--0.4.2.sql
- share/postgresql/extension/pg_partman--0.4.2--1.0.0.sql
- share/postgresql/extension/pg_partman--1.0.0--1.1.0.sql
- share/postgresql/extension/pg_partman--1.1.0--1.2.0.sql
- share/postgresql/extension/pg_partman--1.2.0--1.3.0.sql
- share/postgresql/extension/pg_partman--1.3.0--1.4.0.sql
- share/postgresql/extension/pg_partman--1.4.0--1.4.1.sql
- share/postgresql/extension/pg_partman--1.4.1--1.4.2.sql
- share/postgresql/extension/pg_partman--1.4.2--1.4.3.sql
- share/postgresql/extension/pg_partman--1.4.3--1.4.4.sql
- share/postgresql/extension/pg_partman--1.4.4--1.4.5.sql
- share/postgresql/extension/pg_partman--1.4.5--1.5.0.sql
- share/postgresql/extension/pg_partman--1.5.0--1.5.1.sql
- share/postgresql/extension/pg_partman--1.5.1--1.6.0.sql
- share/postgresql/extension/pg_partman--1.6.0--1.6.1.sql
- share/postgresql/extension/pg_partman--1.6.1--1.7.0.sql
- share/postgresql/extension/pg_partman--1.7.0--1.7.1.sql
- share/postgresql/extension/pg_partman--1.7.1--1.7.2.sql
- share/postgresql/extension/pg_partman--1.7.2--1.8.0.sql
- share/postgresql/extension/pg_partman--1.8.0--1.8.1.sql
- share/postgresql/extension/pg_partman--1.8.1--1.8.2.sql
- share/postgresql/extension/pg_partman--1.8.2--1.8.3.sql
- share/postgresql/extension/pg_partman--1.8.3--1.8.4.sql
- share/postgresql/extension/pg_partman--1.8.4--1.8.5.sql
- share/postgresql/extension/pg_partman--1.8.5--1.8.6.sql
- share/postgresql/extension/pg_partman--1.8.6--1.8.7.sql
- share/postgresql/extension/pg_partman--1.8.7--1.8.8.sql
- share/postgresql/extension/pg_partman--1.8.7--2.0.0.sql
- share/postgresql/extension/pg_partman--1.8.8--2.0.0.sql
- share/postgresql/extension/pg_partman--2.0.0--2.1.0.sql
- share/postgresql/extension/pg_partman--2.1.0--2.2.0.sql
- share/postgresql/extension/pg_partman--2.2.0--2.2.1.sql
- share/postgresql/extension/pg_partman--2.2.1--2.2.2.sql
- share/postgresql/extension/pg_partman--2.2.2--2.2.3.sql
- share/postgresql/extension/pg_partman--2.2.3--2.3.0.sql
- share/postgresql/extension/pg_partman--2.3.0--2.3.1.sql
- share/postgresql/extension/pg_partman--2.3.1--2.3.2.sql
- share/postgresql/extension/pg_partman--2.3.2--2.3.3.sql
- share/postgresql/extension/pg_partman--2.3.3--2.3.4.sql
- share/postgresql/extension/pg_partman--2.3.4--2.4.0.sql
- share/postgresql/extension/pg_partman--2.4.0--2.4.1.sql
- share/postgresql/extension/pg_partman--2.4.1--2.5.0.sql
- share/postgresql/extension/pg_partman--2.5.0--2.5.1.sql
- share/postgresql/extension/pg_partman--2.5.1--2.6.0.sql
- share/postgresql/extension/pg_partman--2.6.0--2.6.1.sql
- share/postgresql/extension/pg_partman--2.6.1--2.6.2.sql
- share/postgresql/extension/pg_partman--2.6.2--2.6.3.sql
- share/postgresql/extension/pg_partman--2.6.3--2.6.4.sql
- share/postgresql/extension/pg_partman--2.6.4--3.0.0.sql
- share/postgresql/extension/pg_partman--3.0.0--3.0.1.sql
- share/postgresql/extension/pg_partman--3.0.1--3.0.2.sql
- share/postgresql/extension/pg_partman--3.0.2--3.1.0.sql
- share/postgresql/extension/pg_partman--3.1.0--3.1.1.sql
- share/postgresql/extension/pg_partman--3.1.1--3.1.2.sql
- share/postgresql/extension/pg_partman--3.1.2--3.1.3.sql
- share/postgresql/extension/pg_partman--3.1.3--3.2.0.sql
- share/postgresql/extension/pg_partman--3.2.0--3.2.1.sql
- share/postgresql/extension/pg_partman--3.2.1--4.0.0.sql
- share/postgresql/extension/pg_partman--4.0.0--4.1.0.sql
- share/postgresql/extension/pg_partman--4.1.0--4.2.0.sql
- share/postgresql/extension/pg_partman--4.2.0--4.2.1.sql
- share/postgresql/extension/pg_partman--4.2.1--4.2.2.sql
- share/postgresql/extension/pg_partman--4.2.2--4.3.0.sql
- share/postgresql/extension/pg_partman--4.3.0--4.3.1.sql
- share/postgresql/extension/pg_partman--4.3.1--4.4.0.sql
- share/postgresql/extension/pg_partman--4.4.0--4.5.0.sql
- share/postgresql/extension/pg_partman--4.4.1--4.5.0.sql
- share/postgresql/extension/pg_partman--4.5.0--4.5.1.sql
- share/postgresql/extension/pg_partman--4.5.1--4.6.0.sql
- share/postgresql/extension/pg_partman--4.6.0--4.6.1.sql
- share/postgresql/extension/pg_partman--4.6.1--4.6.2.sql
- share/postgresql/extension/pg_partman--4.6.2--4.7.0.sql
- share/postgresql/extension/pg_partman--4.7.0--4.7.1.sql
- share/postgresql/extension/pg_partman--4.7.1--4.7.2.sql
- share/postgresql/extension/pg_partman--4.7.2--4.7.3.sql
- share/postgresql/extension/pg_partman--4.7.3--4.7.4.sql
- share/postgresql/extension/pg_partman--4.7.4--4.8.0.sql
- share/postgresql/extension/pg_partman--4.8.0--5.0.0.sql
- share/postgresql/extension/pg_partman--5.0.0--5.0.1.sql
- share/postgresql/extension/pg_partman--5.0.1--5.1.0.sql
- share/postgresql/extension/pg_partman--5.1.0--5.2.0.sql
- share/postgresql/extension/pg_partman--5.2.0--5.2.1.sql
The first 100 are listed.
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| pgpartman-pg_partman-v5.2.2_GH0.tar.gz | 1.247509e+06 | c67898c7b131d66b835b44d92013e9e07f0834b253505ef2808de6826e3e558d |
Commit history 0
No commits in the history this site was built from.