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.
===> The following configuration options are available for pg_partman-5.2.2:
DOCS=on: Build and/or install documentation
===> Use 'make config' to modify these settings
databases/pg_partman: Fix build and pkg-plist
PLIST_SUB logic was inverted accidentally - python utilities was for pg
< 10, but now they try to install.
PR: 271084
Reported by: bsd@abinet.ru
Approved by: portmgr (blanket)
Fixes: a40c0e7 Remove pointers to EOLed pgsql versions
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner)
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above )
databases/pg_partman: Unbreak build with PostgreSQL 11+
=======================<phase: package >============================
===> Building package for pg_partman-4.0.0_1
pkg-static: Unable to access file
/wrkdirs/usr/ports/databases/pg_partman/work/stage/usr/local/bin/partition_data.py:No
such file or directory
pkg-static: Unable to access file
/wrkdirs/usr/ports/databases/pg_partman/work/stage/usr/local/bin/reapply_constraints.py:No
such file or directory
pkg-static: Unable to access file
/wrkdirs/usr/ports/databases/pg_partman/work/stage/usr/local/bin/reapply_foreign_keys.py:No
such file or directory
pkg-static: Unable to access file
/wrkdirs/usr/ports/databases/pg_partman/work/stage/usr/local/bin/undo_partition.py:No
such file or directory
*** Error code 1
http://package18.nyi.freebsd.org/data/120amd64-default-PR239514/2019-07-29_20h41m52s/logs/pg_partman-4.0.0_1.log
With PostgreSQL 11+ some scripts are only installed when they are
common to all PG versions per the Makefile. Exclude them from the
plist in case we are building with PG11+.
PR: 239609
Approved by: lacey.leanne@gmail.com (maintainer timeout, 2 weeks)
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.
This includes ports
- with USE_GCC=yes or USE_GCC=any,
- with USES=fortran,
- using Mk/bsd.octave.mk which in turn features USES=fortran, and
- with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.
PR: 238330
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.
This includes ports
- with USE_GCC=yes or USE_GCC=any,
- with USES=fortran,
- using Mk/bsd.octave.mk which in turn features USES=fortran, and
- with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.
PR: 231590
Workaround the following problem on aarch64 by setting LLD_UNSAFE=yes:
cc: error: invalid linker name in argument '-fuse-ld=bfd'
Neither emaste nor I can figure out exactly where the offending stanza is
coming in. It will take someone with more knowledge of gmake debug flags,
and possibly the src build infrastructure, to figure it out.
While here, pet portlint.
Approved by: portmgr (tier-2 blanket)
databases/pg_partman: Update to 3.1.1
While here:
- Add LICENSE_FILE.
- Remove GH_TUPLE because it's been used for the default distribution file.
- Strip pg_partman_bgw.so (Q/A warning).
- Switch to options helper (DOCS).
Changes: https://github.com/keithf4/pg_partman/blob/v3.1.1/CHANGELOG.txt
PR: 225041
Submitted by: Lacey Powers <lacey.leanne@gmail.com> (maintainer)
New port: databases/pg_partman
pg_partman is an extension to create and manage both time-based and
serial-based table partition sets. Sub-partitoning 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.
WWW: https://github.com/keithf4/pg_partman
PR: 214417
Submitted by: Lacey Powers <lacey.leanne@gmail.com>
Reviewed by: ler
