notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

/commits.php is going away

I'm proposing to take /commits.php away - it mainly duplicates the home page. Details in this GitHub issue.
Port details
pglogical Logical replication system as a PostgreSQL extension
2.4.0 databases on this many watch lists=3 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 2.4.0Version of this port present on the latest quarterly branch.
Maintainer: matthew@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-06-08 23:27:31
Last Update: 2021-10-14 21:30:05
Commit Hash: 1bd5c7e
People watching this port, also watch:: apg, netdata, openjdk8
License: PostgreSQL
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (44 items)
Collapse this list.
  1. /usr/local/share/licenses/pglogical-2.4.0/catalog.mk
  2. /usr/local/share/licenses/pglogical-2.4.0/LICENSE
  3. /usr/local/share/licenses/pglogical-2.4.0/PostgreSQL
  4. bin/pglogical_create_subscriber
  5. lib/postgresql/pglogical.so
  6. lib/postgresql/pglogical_output.so
  7. share/postgresql/extension/pglogical--1.0.0--1.0.1.sql
  8. share/postgresql/extension/pglogical--1.0.0.sql
  9. share/postgresql/extension/pglogical--1.0.1--1.1.0.sql
  10. share/postgresql/extension/pglogical--1.1.0--1.1.1.sql
  11. share/postgresql/extension/pglogical--1.1.1--1.1.2.sql
  12. share/postgresql/extension/pglogical--1.1.2--1.2.0.sql
  13. share/postgresql/extension/pglogical--1.2.0--1.2.1.sql
  14. share/postgresql/extension/pglogical--1.2.1--1.2.2.sql
  15. share/postgresql/extension/pglogical--1.2.2--2.0.0.sql
  16. share/postgresql/extension/pglogical--2.0.0--2.0.1.sql
  17. share/postgresql/extension/pglogical--2.0.0--2.1.0.sql
  18. share/postgresql/extension/pglogical--2.0.1--2.1.0.sql
  19. share/postgresql/extension/pglogical--2.1.0--2.1.1.sql
  20. share/postgresql/extension/pglogical--2.1.1--2.2.0.sql
  21. share/postgresql/extension/pglogical--2.2.0--2.2.1.sql
  22. share/postgresql/extension/pglogical--2.2.0.sql
  23. share/postgresql/extension/pglogical--2.2.1--2.2.2.sql
  24. share/postgresql/extension/pglogical--2.2.1.sql
  25. share/postgresql/extension/pglogical--2.2.2--2.3.0.sql
  26. share/postgresql/extension/pglogical--2.2.2--2.3.1.sql
  27. share/postgresql/extension/pglogical--2.2.2.sql
  28. share/postgresql/extension/pglogical--2.3.0--2.3.1.sql
  29. share/postgresql/extension/pglogical--2.3.0.sql
  30. share/postgresql/extension/pglogical--2.3.1--2.3.2.sql
  31. share/postgresql/extension/pglogical--2.3.1.sql
  32. share/postgresql/extension/pglogical--2.3.2--2.3.3.sql
  33. share/postgresql/extension/pglogical--2.3.2.sql
  34. share/postgresql/extension/pglogical--2.3.3--2.3.4.sql
  35. share/postgresql/extension/pglogical--2.3.3.sql
  36. share/postgresql/extension/pglogical--2.3.4--2.4.0.sql
  37. share/postgresql/extension/pglogical--2.3.4.sql
  38. share/postgresql/extension/pglogical--2.4.0.sql
  39. share/postgresql/extension/pglogical.control
  40. share/postgresql/extension/pglogical_origin--1.0.0.sql
  41. share/postgresql/extension/pglogical_origin.control
  42. @owner
  43. @group
  44. @mode
Collapse this list.
Dependency lines:
  • pglogical>0:databases/pglogical
To install the port: cd /usr/ports/databases/pglogical/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pglogical
  • pkg install pglogical
PKGNAME: pglogical
Flavors: there is no flavor information for this port.
distinfo:
Packages (timestamps in pop-ups are UTC):
pglogical
ABIlatestquarterly
FreeBSD:11:aarch642.2.02.3.1_1
FreeBSD:11:amd642.4.02.3.4
FreeBSD:11:armv61.1.22.3.1_1
FreeBSD:11:i3862.4.02.3.4
FreeBSD:11:mips--
FreeBSD:11:mips641.1.2-
FreeBSD:12:aarch642.2.02.4.0
FreeBSD:12:amd642.4.02.4.0
FreeBSD:12:armv62.2.02.3.2
FreeBSD:12:armv72.2.02.3.2
FreeBSD:12:i3862.4.02.4.0
FreeBSD:12:mips--
FreeBSD:12:mips642.2.0-
FreeBSD:12:powerpc64-2.3.3
FreeBSD:13:aarch642.3.32.4.0
FreeBSD:13:amd642.4.02.4.0
FreeBSD:13:armv62.3.32.3.4
FreeBSD:13:armv72.3.32.3.3
FreeBSD:13:i3862.4.02.4.0
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc642.3.32.3.4
FreeBSD:14:aarch642.4.0-
FreeBSD:14:amd642.4.0-
FreeBSD:14:armv62.3.3-
FreeBSD:14:armv72.3.3-
FreeBSD:14:i3862.4.0-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc642.3.3-
 

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. psql : databases/postgresql12-client
  3. postgres : databases/postgresql12-server
  4. as : devel/binutils
Runtime dependencies:
  1. psql : databases/postgresql12-client
  2. postgres : databases/postgresql12-server
Library dependencies:
  1. libintl.so : devel/gettext-runtime
There are no ports dependent upon this port

Configuration Options:
Options name:

USES:

FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/2ndQuadrant/pglogical/tar.gz/REL2_4_0?dummy=/
Collapse this list.
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2016-09-22
    Affects: users of databases/pglogical, databases/pglogical-output
    Author: matthew@FreeBSD.org
    Reason: 
      As of version 1.2.0, databases/pglogical-output has been merged into
      databases/pglogical.  portmaster or portupgrade users should delete
      pglogical-output manually before upgrading.
    
    
Port Moves
  • port moved here from databases/pglogical-output on 2016-09-22
    REASON: databases/pglogical-output merged into databases/pglogical

Number of commits found: 32

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
14 Oct 2021 21:30:05
 files touched by this commit commit hash:1bd5c7ef3386767317983ee74ae5bb41602724b1  2.4.0
se search for other commits by this committer
databases/pglogical: Add CPE information

Approved by:	portmgr (blanket)
18 Aug 2021 09:05:36
 files touched by this commit commit hash:0a87b14e6487d8480edfb42c9d1999e55aa51485  2.4.0
matthew search for other commits by this committer
databases/pglogical: update to 2.4.0

ChangeLog:	https://github.com/2ndQuadrant/pglogical/releases
06 Jun 2021 20:31:50
 files touched by this commit commit hash:fc84d439be373776eab7305ebd680345106d0ddb  2.3.4
matthew search for other commits by this committer
databases/pglogical: Security update to 2.3.4

ChangeLog:	https://github.com/2ndQuadrant/pglogical/releases/tag/REL2_3_4
MFH:		2021Q2
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  2.3.3 This port version is marked as vulnerable.
mat search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
10 Oct 2020 22:55:22
Original commit files touched by this commit Revision:552022  2.3.3 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.3.3

Release notes: https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
12 Sep 2020 11:39:35
Original commit files touched by this commit Revision:548308  2.3.2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Actually delete the patch file which we are no longer applying.
12 Sep 2020 11:35:47
Original commit files touched by this commit Revision:548307  2.3.2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.3.2

Delete support for postgresql-9.4

Delete patch fixed upstream

ChangeLog:   https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
27 May 2020 19:11:37
Original commit files touched by this commit Revision:536710  2.3.1_1 This port version is marked as vulnerable.
pkubaj search for other commits by this committer
databases/pglogical: fix build on GCC architectures

Use C11 compiler:
pglogical_dependency.c:235: error: static declaration of 'AcquireDeletionLock'
follows non-static declaration
/usr/local/include/postgresql/server/catalog/dependency.h:198: error: previous
declaration of 'AcquireDeletionLock' was here
23 May 2020 14:01:39
Original commit files touched by this commit Revision:536298  2.3.1_1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Fix build after upstream changes in postgres 9.5 -- 12 made functions
AcquireDeletionLock() and ReleaseDeletionLock() extern rather than
static in:

  
https://github.com/postgres/postgres/commit/5be594caf818e0b5e33f8dec191f2707394a6d95

The function definitions in the postgresql sources are identical to
those in the pglogical sources, so let's just link against the
postgresql versions.

postgresql-9.4 is EoL, so didn't receive the same changes in the
latest round of postgresql updates.

While here, fix another of the patches which should no be applied when
compiling against all versions of postgresql.  Plus fix the pkg-plist
-- how did this port ever package previously?
27 Apr 2020 06:10:44
Original commit files touched by this commit Revision:533104  2.3.1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Upgrade to 2.3.1

Release Notes: https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
22 Feb 2020 12:28:12
Original commit files touched by this commit Revision:526763  2.3.0 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.3.0

Relese Notes:	https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
29 Jul 2019 18:08:25
Original commit files touched by this commit Revision:507581  2.2.2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.2.2

ChangeLog:	https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
26 Jul 2019 20:46:57
Original commit files touched by this commit Revision:507372  2.2.1_3 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
06 Mar 2019 06:53:54
Original commit files touched by this commit Revision:494778  2.2.1_2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Fix compilation with postgresql11.  With previous versions of
postgresql, <arpa/inet.h> was included automatically as part of the
postgres module building environment.  But it needs to be included
explicitly for the most recent postgres.

Submitted by:	andriy@irbisnet.com
07 Feb 2019 06:44:46
Original commit files touched by this commit Revision:492346  2.2.1_2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Really update to version 2.2.1

Just updating PORTVERSION won't achieve anything if you don't also
make the corresponding change to GH_TAGNAME.  To avoid this sort of
embarrassment in future, drop PORTVERSION and GH_TAGNAME for the main
distfile in favour of DISTVERSION and DISTVERSIONPREFIX.

Reorder some items in the Makefile to mollify portlint.

Reported by:	mat
12 Dec 2018 01:35:36
Original commit files touched by this commit Revision:487272  2.2.1_1 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
27 Oct 2018 14:49:17
Original commit files touched by this commit Revision:483142  2.2.1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.2.1
10 Sep 2018 13:11:24
Original commit files touched by this commit Revision:479405  2.2.0 This port version is marked as vulnerable.
mat search for other commits by this committer
After an include, PLIST_SUB must be appended to, not overwritten.

If it is overwritten, many values will be clobbered, and
pain will ensue.

PR:		230864
Submitted by:	mat
exp-runs by:	antoine
24 Jun 2018 00:54:27
Original commit files touched by this commit Revision:473169  2.2.0 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)
31 Mar 2018 11:26:32
Original commit files touched by this commit Revision:466040  2.2.0 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.2.0

ChangeLog: https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
11 Jan 2018 22:57:32
Original commit files touched by this commit Revision:458801  2.1.1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.1.1

Release Notes:	https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
10 Oct 2017 06:25:11
Original commit files touched by this commit Revision:451656  2.1.0 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.1.0

ChangeLog: https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
10 Jun 2017 21:59:45
Original commit files touched by this commit Revision:443124  2.0.1_1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Fix build with postgresql9.4

Switch to downloading sources from GitHub, and add the pglogical_dump
submodule.  This was omitted from the tarball provided by 2nd Quadrant
in the latest version.  The pglogical_dump code is only compiled with
postgresql9.4 which failed to build -- using other postgresql versions
worked fine.

Reported by:	pkg-fallout
09 Jun 2017 13:31:23
Original commit files touched by this commit Revision:442983  2.0.1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.0.1

Release notes: https://www.2ndquadrant.com/en/resources/pglogical/release-notes/
06 May 2017 15:54:54
Original commit files touched by this commit Revision:440280  2.0.0 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 2.0.0

ChangeLog:	https://2ndquadrant.com/en/resources/pglogical/release-notes/
06 Jan 2017 14:31:49
Original commit files touched by this commit Revision:430709  1.2.2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 1.2.2

ChangeLog:	https://2ndquadrant.com/en/resources/pglogical/release-notes/
16 Oct 2016 18:17:42
Original commit files touched by this commit Revision:424075  1.2.1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 1.2.1

Changes:  https://github.com/2ndQuadrant/pglogical/compare/REL1_2_1...master
22 Sep 2016 15:38:53
Original commit files touched by this commit Revision:422631  1.2.0 This port version is marked as vulnerable.
matthew search for other commits by this committer
Remove the now pointless pkg-message, forgotten in previous commit.
22 Sep 2016 15:37:51
Original commit files touched by this commit Revision:422630  1.2.0 This port version is marked as vulnerable.
matthew search for other commits by this committer
pglogical: update to 1.2.0
pglogical-output: delete; merged into databases/pglogical

The databases/pglogical	  and databases/pglogical-output ports have been
merged into one codebase upstream, and database/pglogical now installs
the pglogical-output.so module.

pkg(8) should handle the merger	correctly; portmaster(1),
portupgrade(1) users are advised to manually delete pglogical-output
before upgrading.
19 Aug 2016 10:11:37
Original commit files touched by this commit Revision:420454  1.1.2_1 This port version is marked as vulnerable.
matthew search for other commits by this committer
Install the .sql files for release 1.1.2 -- this is missing from the
release tarball, but has been fixed in upstream's Github.

Add pglogical_dump, pglogical_origin--1.0.0.sql and
pglogical_origin.control conditionally on the postgresql version --
these are only compiled and installed with postgresql-9.4.x

Submitted by:	Anderson Neves <anderson.ufal@gmail.com>
10 Jun 2016 12:30:35
Original commit files touched by this commit Revision:416674  1.1.2 This port version is marked as vulnerable.
matthew search for other commits by this committer
Update to 1.1.2

This fixes an important regression with replication of TOASTed values.

ChangeLog: http://2ndquadrant.com/en/resources/pglogical/release-notes/
08 Jun 2016 23:27:22
Original commit files touched by this commit Revision:416571  1.1.1 This port version is marked as vulnerable.
matthew search for other commits by this committer
pglogical is a logical replication system implemented entirely as a
PostgreSQL extension. Fully integrated, it requires no triggers or
external programs. This alternative to physical replication is a
highly efficient method of replicating data using a publish/subscribe
model for selective replication.

WWW: http://2ndquadrant.com/en/resources/pglogical/

Number of commits found: 32