notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
pg_partman PostgreSQL Partition Manager
4.6.0 databases on this many watch lists=1 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 4.6.0Version of this port present on the latest quarterly branch.
Maintainer: lacey.leanne@gmail.com search for ports maintained by this maintainer
Port Added: 2017-08-11 09:26:38
Last Update: 2023-04-29 22:51:59
Commit Hash: 91f22aa
People watching this port, also watch:: policyd2, rc, py39-cjkwrap, py39-darts.util.lru, monit
License: PostgreSQL
WWW:
https://github.com/keithf4/pg_partman
Description:
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.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (95 items)
Collapse this list.
  1. /usr/local/share/licenses/pg_partman-4.6.0/catalog.mk
  2. /usr/local/share/licenses/pg_partman-4.6.0/LICENSE
  3. /usr/local/share/licenses/pg_partman-4.6.0/PostgreSQL
  4. bin/check_unique_constraint.py
  5. bin/dump_partition.py
  6. bin/reapply_indexes.py
  7. bin/vacuum_maintenance.py
  8. lib/postgresql/pg_partman_bgw.so
  9. share/doc/pg_partman/migrate_to_native.md
  10. share/doc/pg_partman/migration_to_partman.md
  11. share/doc/pg_partman/pg_partman.md
  12. share/doc/pg_partman/pg_partman_howto_native.md
  13. share/doc/pg_partman/pg_partman_howto_triggerbased.md
  14. share/postgresql/extension/pg_partman--0.1.0--0.1.1.sql
  15. share/postgresql/extension/pg_partman--0.1.1--0.1.2.sql
  16. share/postgresql/extension/pg_partman--0.1.2--0.2.0.sql
  17. share/postgresql/extension/pg_partman--0.2.0--0.3.0.sql
  18. share/postgresql/extension/pg_partman--0.3.0--0.3.1.sql
  19. share/postgresql/extension/pg_partman--0.3.1--0.3.2.sql
  20. share/postgresql/extension/pg_partman--0.3.2--0.4.0.sql
  21. share/postgresql/extension/pg_partman--0.4.0--0.4.1.sql
  22. share/postgresql/extension/pg_partman--0.4.1--0.4.2.sql
  23. share/postgresql/extension/pg_partman--0.4.2--1.0.0.sql
  24. share/postgresql/extension/pg_partman--1.0.0--1.1.0.sql
  25. share/postgresql/extension/pg_partman--1.1.0--1.2.0.sql
  26. share/postgresql/extension/pg_partman--1.2.0--1.3.0.sql
  27. share/postgresql/extension/pg_partman--1.3.0--1.4.0.sql
  28. share/postgresql/extension/pg_partman--1.4.0--1.4.1.sql
  29. share/postgresql/extension/pg_partman--1.4.1--1.4.2.sql
  30. share/postgresql/extension/pg_partman--1.4.2--1.4.3.sql
  31. share/postgresql/extension/pg_partman--1.4.3--1.4.4.sql
  32. share/postgresql/extension/pg_partman--1.4.4--1.4.5.sql
  33. share/postgresql/extension/pg_partman--1.4.5--1.5.0.sql
  34. share/postgresql/extension/pg_partman--1.5.0--1.5.1.sql
  35. share/postgresql/extension/pg_partman--1.5.1--1.6.0.sql
  36. share/postgresql/extension/pg_partman--1.6.0--1.6.1.sql
  37. share/postgresql/extension/pg_partman--1.6.1--1.7.0.sql
  38. share/postgresql/extension/pg_partman--1.7.0--1.7.1.sql
  39. share/postgresql/extension/pg_partman--1.7.1--1.7.2.sql
  40. share/postgresql/extension/pg_partman--1.7.2--1.8.0.sql
  41. share/postgresql/extension/pg_partman--1.8.0--1.8.1.sql
  42. share/postgresql/extension/pg_partman--1.8.1--1.8.2.sql
  43. share/postgresql/extension/pg_partman--1.8.2--1.8.3.sql
  44. share/postgresql/extension/pg_partman--1.8.3--1.8.4.sql
  45. share/postgresql/extension/pg_partman--1.8.4--1.8.5.sql
  46. share/postgresql/extension/pg_partman--1.8.5--1.8.6.sql
  47. share/postgresql/extension/pg_partman--1.8.6--1.8.7.sql
  48. share/postgresql/extension/pg_partman--1.8.7--1.8.8.sql
  49. share/postgresql/extension/pg_partman--1.8.7--2.0.0.sql
  50. share/postgresql/extension/pg_partman--1.8.8--2.0.0.sql
  51. share/postgresql/extension/pg_partman--2.0.0--2.1.0.sql
  52. share/postgresql/extension/pg_partman--2.1.0--2.2.0.sql
  53. share/postgresql/extension/pg_partman--2.2.0--2.2.1.sql
  54. share/postgresql/extension/pg_partman--2.2.1--2.2.2.sql
  55. share/postgresql/extension/pg_partman--2.2.2--2.2.3.sql
  56. share/postgresql/extension/pg_partman--2.2.3--2.3.0.sql
  57. share/postgresql/extension/pg_partman--2.3.0--2.3.1.sql
  58. share/postgresql/extension/pg_partman--2.3.1--2.3.2.sql
  59. share/postgresql/extension/pg_partman--2.3.2--2.3.3.sql
  60. share/postgresql/extension/pg_partman--2.3.3--2.3.4.sql
  61. share/postgresql/extension/pg_partman--2.3.4--2.4.0.sql
  62. share/postgresql/extension/pg_partman--2.4.0--2.4.1.sql
  63. share/postgresql/extension/pg_partman--2.4.1--2.5.0.sql
  64. share/postgresql/extension/pg_partman--2.5.0--2.5.1.sql
  65. share/postgresql/extension/pg_partman--2.5.1--2.6.0.sql
  66. share/postgresql/extension/pg_partman--2.6.0--2.6.1.sql
  67. share/postgresql/extension/pg_partman--2.6.1--2.6.2.sql
  68. share/postgresql/extension/pg_partman--2.6.2--2.6.3.sql
  69. share/postgresql/extension/pg_partman--2.6.3--2.6.4.sql
  70. share/postgresql/extension/pg_partman--2.6.4--3.0.0.sql
  71. share/postgresql/extension/pg_partman--3.0.0--3.0.1.sql
  72. share/postgresql/extension/pg_partman--3.0.1--3.0.2.sql
  73. share/postgresql/extension/pg_partman--3.0.2--3.1.0.sql
  74. share/postgresql/extension/pg_partman--3.1.0--3.1.1.sql
  75. share/postgresql/extension/pg_partman--3.1.1--3.1.2.sql
  76. share/postgresql/extension/pg_partman--3.1.2--3.1.3.sql
  77. share/postgresql/extension/pg_partman--3.1.3--3.2.0.sql
  78. share/postgresql/extension/pg_partman--3.2.0--3.2.1.sql
  79. share/postgresql/extension/pg_partman--3.2.1--4.0.0.sql
  80. share/postgresql/extension/pg_partman--4.0.0--4.1.0.sql
  81. share/postgresql/extension/pg_partman--4.1.0--4.2.0.sql
  82. share/postgresql/extension/pg_partman--4.2.0--4.2.1.sql
  83. share/postgresql/extension/pg_partman--4.2.1--4.2.2.sql
  84. share/postgresql/extension/pg_partman--4.2.2--4.3.0.sql
  85. share/postgresql/extension/pg_partman--4.3.0--4.3.1.sql
  86. share/postgresql/extension/pg_partman--4.3.1--4.4.0.sql
  87. share/postgresql/extension/pg_partman--4.4.0--4.5.0.sql
  88. share/postgresql/extension/pg_partman--4.4.1--4.5.0.sql
  89. share/postgresql/extension/pg_partman--4.5.0--4.5.1.sql
  90. share/postgresql/extension/pg_partman--4.5.1--4.6.0.sql
  91. share/postgresql/extension/pg_partman--4.6.0.sql
  92. share/postgresql/extension/pg_partman.control
  93. @owner
  94. @group
  95. @mode
Collapse this list.
Dependency lines:
  • pg_partman>0:databases/pg_partman
To install the port:
cd /usr/ports/databases/pg_partman/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pg_partman
  • pkg install pg_partman
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pg_partman
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1634246278 SHA256 (keithf4-pg_partman-v4.6.0_GH0.tar.gz) = 6328ea55e20a4f090037035751a02ebb7965d9e305e3839ffceb4c06bbbfa42f SIZE (keithf4-pg_partman-v4.6.0_GH0.tar.gz) = 1200867

Packages (timestamps in pop-ups are UTC):
pg_partman
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.6.04.6.04.4.04.6.04.6.0-4.4.0-
FreeBSD:13:quarterly4.6.04.6.04.6.04.6.04.6.04.6.04.6.04.6.0
FreeBSD:14:latest4.6.04.6.04.6.04.6.04.6.04.6.0-4.6.0
FreeBSD:14:quarterly4.6.04.6.0-4.6.04.6.04.6.04.6.04.6.0
FreeBSD:15:latest4.6.04.6.0n/a4.6.0n/a4.6.04.6.04.6.0
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.3 : devel/gmake
  2. postgres : databases/postgresql13-server
  3. python3.9 : lang/python39
  4. as : devel/binutils
Test dependencies:
  1. python3.9 : lang/python39
Runtime dependencies:
  1. __init__.py : databases/py-psycopg2
  2. postgres : databases/postgresql13-server
  3. python3.9 : lang/python39
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pg_partman-4.6.0: DOCS=on: Build and/or install documentation ===> Use 'make config' to modify these settings
Options name:
databases_pg_partman
USES:
cpe gmake pgsql:11+ python uidfix shebangfix
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/keithf4/pg_partman/tar.gz/v4.6.0?dummy=/
Collapse this list.

Number of commits found: 23

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.6.0
29 Apr 2023 22:51:59
commit hash: 91f22aab17707a3edc61f6743ee14c7f83198036commit hash: 91f22aab17707a3edc61f6743ee14c7f83198036commit hash: 91f22aab17707a3edc61f6743ee14c7f83198036commit hash: 91f22aab17707a3edc61f6743ee14c7f83198036 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
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
4.6.0
15 Apr 2023 13:14:58
commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
*/*: Remove pointers to EOLed pgsql versions

- Remove dotted pgsql versions

Approved by:	portmgr
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
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)
4.6.0
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
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 View all of this commit message)
4.6.0
27 Feb 2022 17:57:13
commit hash: dd103c6091d7725a402dc614be39bdc2b3173422commit hash: dd103c6091d7725a402dc614be39bdc2b3173422commit hash: dd103c6091d7725a402dc614be39bdc2b3173422commit hash: dd103c6091d7725a402dc614be39bdc2b3173422 files touched by this commit
Fernando Apesteguía (fernape) search for other commits by this committer
Author: Lacey Powers
databases/pg_partman: update to 4.6.0

https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt

PR:	262096
Reported by:	lacey.leanne@gmail.com (maintainer)
4.5.1
14 Oct 2021 21:30:04
commit hash: cb6a778334aeb1e57f7c1781d036190ad4e8daa5commit hash: cb6a778334aeb1e57f7c1781d036190ad4e8daa5commit hash: cb6a778334aeb1e57f7c1781d036190ad4e8daa5commit hash: cb6a778334aeb1e57f7c1781d036190ad4e8daa5 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
databases/pg_partman: Add CPE information

Approved by:	portmgr (blanket)
4.5.1
24 May 2021 15:55:35
commit hash: 370c7631a13560605f62525b3b6fb7181727e38acommit hash: 370c7631a13560605f62525b3b6fb7181727e38acommit hash: 370c7631a13560605f62525b3b6fb7181727e38acommit hash: 370c7631a13560605f62525b3b6fb7181727e38a files touched by this commit
Palle Girgensohn (girgen) search for other commits by this committer
databases/pg_partman: Update to 4.5.1

Security:	5fa90ee6-bc9e-11eb-a287-e0d55e2a8bf9
4.4.0
07 Apr 2021 08:09:01
commit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455c files touched by this commit This port version is marked as vulnerable.
Mathieu Arnold (mat) search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
4.4.0
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit This port version is marked as vulnerable.
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
4.4.0
27 Jun 2020 14:58:10
Revision:540613Original commit files touched by this commit This port version is marked as vulnerable.
pi search for other commits by this committer
databases/pg_partman: update 4.0.0 -> 4.4.0

PR:		247511
Submitted by:	Lacey Powers <lacey.leanne@gmail.com> (maintainer)
Relnotes:	https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt
4.0.0_1
17 Aug 2019 19:43:08
Revision:509164Original commit files touched by this commit This port version is marked as vulnerable.
tobik search for other commits by this committer
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)
4.0.0_1
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit This port version is marked as vulnerable.
gerald search for other commits by this committer
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
4.0.0
25 Apr 2019 16:00:22
Revision:500024Original commit files touched by this commit This port version is marked as vulnerable.
kai search for other commits by this committer
databases/pg_partman: Update to 4.0.0

* Fix whitespace in pkg-descr

Changelog:

https://github.com/pgpartman/pg_partman/blob/v4.0.0/CHANGELOG.txt

PR:		237001
Submitted by:	Lacey Powers <lacey.leanne@gmail.com> (maintainer)
Approved by:	mentors (implicit)
3.2.1_1
06 Jan 2019 12:26:02
Revision:489481Original commit files touched by this commit This port version is marked as vulnerable.
tobik search for other commits by this committer
Do not set OPTIONS_DEFINE twice
3.2.1_1
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit This port version is marked as vulnerable.
gerald search for other commits by this committer
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
3.2.1
21 Sep 2018 18:11:00
Revision:480299Original commit files touched by this commit This port version is marked as vulnerable.
swills search for other commits by this committer
databases/pg_partman: Update to 3.2.1

PR:		231529
Submitted by:	Lacey Powers <lacey.leanne@gmail.com> (maintainer)
3.1.3
10 Sep 2018 13:14:52
Revision:479406Original commit files touched by this commit This port version is marked as vulnerable.
mat search for other commits by this committer
Add DOCS options to ports that should have one.

Also various fixes related to said option.

PR:		230864
Submitted by:	mat
exp-runs by:	antoine
3.1.3
24 Jun 2018 00:54:27
Revision:473169Original commit files touched by this commit This port version is marked as vulnerable.
linimon search for other commits by this committer
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)
3.1.3
09 May 2018 02:35:36
Revision:469424Original commit files touched by this commit This port version is marked as vulnerable.
swills search for other commits by this committer
databases/pg_partman: Update to 3.1.3

PR:		228083
Submitted by:	Lacey Powers <lacey.leanne@gmail.com> (maintainer)
3.1.2
21 Feb 2018 11:28:03
Revision:462492Original commit files touched by this commit This port version is marked as vulnerable.
wen search for other commits by this committer
- Update to 3.1.2

PR:		226082
Submitted by:	lacey.leanne@gmail.com(maintainer)
3.1.1
17 Jan 2018 01:28:36
Revision:459216Original commit files touched by this commit This port version is marked as vulnerable.
dbaio search for other commits by this committer
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)
3.1.0
17 Nov 2017 21:34:18
Revision:454387Original commit files touched by this commit This port version is marked as vulnerable.
tcberner search for other commits by this committer
Update databases/pg_partman to 3.1.0

PR:		223723
Submitted by:	Lacey Powers <lacey.leanne@gmail.com> (maintainer)
3.0.2
11 Aug 2017 09:26:25
Revision:447749Original commit files touched by this commit This port version is marked as vulnerable.
pi search for other commits by this committer
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

Number of commits found: 23