FreshPorts -- databases/postgresql-repmgr: PostgreSQL replication manager

Port details

postgresql-repmgr PostgreSQL replication manager

5.4.1 databases =6 5.4.1Version of this port present on the latest quarterly branch.

Maintainer: bofh@FreeBSD.org

Port Added: 2011-01-18 13:10:49

Last Update: 2023-07-15 15:43:33

Commit Hash: 47f5ec9

People watching this port, also watch:: openvpn, pgmetrics, smartmontools, haproxy-devel, check_ssl_cert

License: GPLv3

WWW:

https://repmgr.org/

Description:

repmgr allows you to monitor and manage your replicated PostgreSQL databases as a single cluster.

¦ ¦ ¦ ¦

Manual pages:

FreshPorts has no man page information for this port.

pkg-plist: as obtained via: make generate-plist

Expand this list (34 items)

Collapse this list.

/usr/local/share/licenses/postgresql-repmgr-5.4.1/catalog.mk
/usr/local/share/licenses/postgresql-repmgr-5.4.1/LICENSE
/usr/local/share/licenses/postgresql-repmgr-5.4.1/GPLv3
bin/repmgr
bin/repmgrd
lib/postgresql/repmgr.so
share/postgresql/extension/repmgr--4.0.sql
share/postgresql/extension/repmgr--4.0--4.1.sql
share/postgresql/extension/repmgr--4.1.sql
share/postgresql/extension/repmgr--4.1--4.2.sql
share/postgresql/extension/repmgr--4.2--4.3.sql
share/postgresql/extension/repmgr--4.2.sql
share/postgresql/extension/repmgr--4.3.sql
share/postgresql/extension/repmgr--4.3--4.4.sql
share/postgresql/extension/repmgr--4.4.sql
share/postgresql/extension/repmgr--4.4--5.0.sql
share/postgresql/extension/repmgr--5.0.sql
share/postgresql/extension/repmgr--5.0--5.1.sql
share/postgresql/extension/repmgr--5.1.sql
share/postgresql/extension/repmgr--5.1--5.2.sql
share/postgresql/extension/repmgr--5.2.sql
share/postgresql/extension/repmgr--5.2--5.3.sql
share/postgresql/extension/repmgr--5.3.sql
share/postgresql/extension/repmgr--5.3--5.4.sql
share/postgresql/extension/repmgr--5.4.sql
share/postgresql/extension/repmgr--unpackaged--4.0.sql
share/postgresql/extension/repmgr--unpackaged--5.1.sql
share/postgresql/extension/repmgr--unpackaged--5.2.sql
share/postgresql/extension/repmgr--unpackaged--5.3.sql
share/postgresql/extension/repmgr.control
@sample etc/repmgr.conf.sample
@owner
@group
@mode

Collapse this list.

Dependency lines:

postgresql-repmgr>0:databases/postgresql-repmgr

To install the port:

cd /usr/ports/databases/postgresql-repmgr/ && make install clean

To add the package, run one of these commands:

pkg install databases/postgresql-repmgr
pkg install postgresql-repmgr

NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.

PKGNAME: postgresql-repmgr

Flavors: there is no flavor information for this port.

distinfo:

TIMESTAMP = 1689430269 SHA256 (repmgr-5.4.1.tar.gz) = a18d61a99df5d266bf29854ce10e6976661788ba09605d3263d6385ad4423b10 SIZE (repmgr-5.4.1.tar.gz) = 461670

Packages (timestamps in pop-ups are UTC):

postgresql-repmgr
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	5.4.1	5.4.1	5.2.0	5.4.1	5.4.1	-	5.2.0	-
FreeBSD:13:quarterly	5.4.1	5.4.1	5.4.0	5.4.1	5.4.1	5.4.1	5.4.1	5.4.1
FreeBSD:14:latest	5.4.1	5.4.1	5.3.3	5.4.1	5.4.1	5.3.3	-	5.3.3
FreeBSD:14:quarterly	5.4.1	5.4.1	-	5.4.1	5.4.1	5.4.1	5.4.1	5.4.1
FreeBSD:15:latest	5.4.1	5.4.1	n/a	5.4.1	n/a	5.4.1	5.4.1	5.4.1
FreeBSD:15:quarterly	-	-	n/a	-	n/a	-	-	-

Dependencies

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:

msgfmt : devel/gettext-tools
gmake>=4.3 : devel/gmake
postgres : databases/postgresql13-server
as : devel/binutils

Runtime dependencies:

rsync : net/rsync
postgres : databases/postgresql13-server

Library dependencies:

libcurl.so : ftp/curl
libjson-c.so : devel/json-c
libintl.so : devel/gettext-runtime

There are no ports dependent upon this port

Configuration Options:

===> The following configuration options are available for postgresql-repmgr-5.4.1: DOCS=on: Build and/or install documentation ===> Use 'make config' to modify these settings

Options name:

databases_postgresql-repmgr

USES:

gettext gmake pgsql

FreshPorts was unable to extract/find any pkg message

Master Sites:

Expand this list (1 items)

Collapse this list.

http://www.repmgr.org/download/

Collapse this list.

Notes from UPDATING

These upgrade notes are taken from /usr/ports/UPDATING

2023-09-08

Affects: users of databases/postgresql* and other software using PostgreSQL to run

Author: kbowling@FreeBSD.org

Reason: 
  The default version of PostgreSQL has been switched from 13 to 15.
  The upgrade procedure can use up twice the space the databases
  currently needs. If you have a big amount of stored data take a
  closer look at the manpage of pg_upgrade for avoidance and/or
  speedup of the upgrade.

  The upgrade instructions consider a basic usage and do not match
  complex scenarios like replication, sharding, or similar.

  Upgrade instructions:

  First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
  If you have another Version of PostgreSQL installed, for example 13, your
  files are named according to this.

  # service postgresql stop
  # pkg create postgresql13-server postgresql13-contrib
  # mkdir /tmp/pg-upgrade
  # tar xf postgresql13-server-13.12.pkg -C /tmp/pg-upgrade
  # tar xf postgresql13-contrib-13.12.pkg -C /tmp/pg-upgrade
  # pkg delete -f databases/postgresql13-server databases/postgresql13-contrib databases/postgresql13-client

  Now update PostgreSQL:

    pkg user:
    # pkg install databases/postgresql15-server databases/postgresql15-contrib
    # pkg upgrade

    Portmaster users:
    # portmaster databases/postgresql15-server databases/postgresql15-contrib
    # portmaster -a

    Portupgrade users:
    # portinstall databases/postgresql15-server databases/postgresql15-contrib
    # portupgrade -a

  After installing the new PostgreSQL version you need to convert
  all your databases to new version:

  # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data15 -U postgres"
  # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data13/ -B /usr/local/bin/ -D /var/db/postgres/data15/ -U postgres "

  Now the migration is finished. You can start PostgreSQL again with:

  # service postgresql start

  ATTENTION:
  1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume
     the "postgres" database user and FreeBSD user.
  2) See the updating entry 20190829 if you are updating from a release prior to 11.
  3) If you use non-default initdb options, you have to adjust the initdb-command accordingly

Expand this list (1 items)

2021-10-24

Affects: users of databases/postgresql* and other software using PostgreSQL to run

Author: kbowling@FreeBSD.org

Reason: 
  The default version of PostgreSQL has been switched from 12 to 13.
  The upgrade procedure can use up twice the space the databases
  currently needs. If you have a big amount of stored data take a
  closer look at the manpage of pg_upgrade for avoidance and/or
  speedup of the upgrade.

  The upgrade instructions consider a basic usage and do not match
  complex scenarios like replication, sharding, or similar.

  Upgrade instructions:

  First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
  If you have another Version of PostgreSQL installed, for example 12.8, your
  files are named according to this.

  # service postgresql stop
  # pkg create postgresql12-server postgresql12-contrib
  # mkdir /tmp/pg-upgrade
  # tar xf postgresql12-server-12.8.pkg -C /tmp/pg-upgrade
  # tar xf postgresql12-contrib-12.8.pkg -C /tmp/pg-upgrade
  # pkg delete -f databases/postgresql12-server databases/postgresql12-contrib databases/postgresql12-client

  Now update PostgreSQL:

    pkg user:
    # pkg install databases/postgresql13-server databases/postgresql13-contrib
    # pkg upgrade

    Portmaster users:
    # portmaster databases/postgresql13-server databases/postgresql13-contrib
    # portmaster -a

    Portupgrade users:
    # portinstall databases/postgresql13-server databases/postgresql13-contrib
    # portupgrade -a

  After installing the new PostgreSQL version you need to convert
  all your databases to new version:

  # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data13 -U postgres"
  # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data12/ -B /usr/local/bin/ -D /var/db/postgres/data13/ -U postgres "

  Now the migration is finished. You can start PostgreSQL again with:

  # service postgresql start

  ATTENTION:
  1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume
     the "postgres" database user and FreeBSD user.
  2) See the updating entry 20190829 if you are updating from a release prior to 11.
  3) If you use non-default initdb options, you have to adjust the initdb-command accordingly

Collapse this list.

Number of commits found: 46

Commit	Credits	Log message
Commit History - (may be incomplete: for full details, see links to repositories near top of page)
5.4.1 15 Jul 2023 15:43:33	Muhammad Moinur Rahman (bofh)	databases/postgresql-repmgr: Update version 5.4.0=>5.4.1 Changelog: https://www.repmgr.org/docs/current/release-5.4.1.html
5.4.0 29 Jun 2023 22:33:24	Muhammad Moinur Rahman (bofh)	databases/postgresql-repmgr: Update version 5.3.3=>5.4.0 Changelog: https://www.repmgr.org/docs/current/release-5.4.0.html
5.3.3 16 Nov 2022 22:14:44	Muhammad Moinur Rahman (bofh)	databases/postgresql-repmgr: Update version 5.3.2=>5.3.3 Relnotes: https://repmgr.org/docs/current/release-5.3.3.html
07 Sep 2022 21:58:51	Stefan Eßer (se)	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)
5.3.2_1 07 Sep 2022 21:10:59	Stefan Eßer (se)	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 )
5.3.2_1 13 Aug 2022 18:51:14	Matthias Andree (mandree)	*: bump PORTREVISION of all devel/xxhash users... ...except archivers/py-borgbackup, which requires a more complete fix.
5.3.2 20 Jul 2022 14:21:07	Tobias C. Berner (tcberner)	databases: remove 'Created by' lines A big Thank You to the original contributors of these ports: * "Choe, Cheng-Dae" whitekid * "Mahdi Mokhtari <mokhi64@gmail.com>" * "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de> * <hvo.pm@xs4all.nl> * <jsmith@resonatingmedia.com> * <ports@c0decafe.net> * Aaron Dalton <aaron@FreeBSD.org> * Adam Weinberger <adamw@FreeBSD.org> * Ade Lovett <ade@FreeBSD.org> * Akinori MUSHA aka knu <knu@idaemons.org> * Alan Snelson <Alan@Wave2.org> (Only the first 15 lines of the commit message are shown above )
5.3.2 27 May 2022 19:16:03	Muhammad Moinur Rahman (bofh)	databases/postgresql-repmgr: Update version 5.2.0=>5.3.2 - Fix build with NLS. See the following: https://github.com/EnterpriseDB/repmgr/issues/755 - Update WWW - Pet portclippy/portfmt Reported by: mike.jakubik@swiftsmsgateway.com
5.2.0 06 Apr 2021 14:31:13	Mathieu Arnold (mat)	all: Remove all other $FreeBSD keywords.
5.2.0 06 Apr 2021 14:31:07	Mathieu Arnold (mat)	Remove # $FreeBSD$ from Makefiles.
5.2.0 24 Oct 2020 23:52:38	bofh	databases/postgresql-repmgr: Update version 5.1.0=>5.2.0 - Fix service start if pid file doesn't exist [1] PR: 250012 [1] Submitted by: ole@free.de [1] Relnotes: https://repmgr.org/docs/current/release-5.2.0.html
5.1.0 22 Apr 2020 21:44:48	bofh	databases/postgresql-repmgr: Update version 5.0.0=>5.1.0 Reported by: waldemar.dick@wdick.de MFH: 2020Q2 (bug fix) Relnotes: https://repmgr.org/docs/current/release-5.1.0.html
5.0.0 31 Oct 2019 21:40:48	bofh	databases/postgresql-repmgr: Update version 4.4.0=>5.0.0
4.4.0_1 26 Jul 2019 20:46:57	gerald	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.4.0 03 Jul 2019 07:45:31	bofh	databases/postgresql-repmgr: Update version 4.3.0=>4.4.0
4.3.0 04 Apr 2019 11:46:42	bofh	databases/postgresql-repmgr: Update version 4.2.0=>4.3.0
4.2.0 16 Dec 2018 18:15:56	bofh	databases/postgresql-repmgr: Update version 4.1.0=>4.2.0 - Pet portlint PR: 233857 Submitted by: ard_1@mail.ru
4.1.0_1 12 Dec 2018 01:35:36	gerald	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
4.1.0 02 Aug 2018 05:03:11	bofh	databases/postgresql-repmgr: Update version 4.0.6=>4.1.0 Relnotes: https://repmgr.org/docs/4.1/release-4.1.0.html
4.0.6 23 Jul 2018 21:52:48	bofh	databases/postgresql-repmgr: Update version 4.0.4=>4.0.6 Relnotes: https://repmgr.org/docs/4.0/release-4.0.6.html
4.0.4 24 Jun 2018 00:54:27	linimon	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)
4.0.4 24 Apr 2018 23:28:44	bofh	databases/postgresql-repmgr: Update version 4.0.1=>4.0.4 Relnotes: https://repmgr.org/docs/4.0/release-4.0.4.html
4.0.1 08 Jan 2018 12:55:59	bofh	databases/postgresql-repmgr: Update version 3.3.1=>4.0.1 Relnotes: https://repmgr.org/docs/4.0/release-4.0.1.html
3.3.1 09 Apr 2017 08:53:17	bofh	databases/postgresql-repmgr: Update version 3.3=>3.3.1
3.3 05 Mar 2017 10:40:45	bofh	databases/postgresql-repmgr: Update version 3.1.5=>3.3 - Daemon would better run as pgsql user, and for safety by default in monitor only mode [1] PR: 212490 [1] Submitted by: marck [1]
3.1.5 16 Aug 2016 23:05:25	bofh	databases/postgresql-repmgr: Update version 3.1.4=>3.1.5 PR: 211863 Submitted by: olgeni
3.1.4 25 Jul 2016 18:38:11	bofh	databases/postgresql-repmgr: Update version 3.1.3=>3.1.4 PR: 211191 Submitted by: olgeni
3.1.3 09 Jun 2016 20:43:55	bofh	databases/postgresql-repmgr: Update version 2.0.2=>3.1.3
2.0.2 01 Apr 2016 14:00:57	mat	Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g. With hat: portmgr Sponsored by: Absolight
2.0.2 08 Mar 2015 11:48:26	bofh	databases/postgresql-repmgr: Update version 2.0=>2.0.2 Approved by: bapt marino (implicit)
2.0_3 24 Dec 2014 00:14:13	bofh	Change my non-FreeBSD MAINTAINER mail to bofh@ Approved by: bapt
2.0_3 14 Dec 2014 17:59:54	matthew	Include postgresql loadable module and related sample SQL files into plist. PR: 195718 Submitted by: maintainer (5u623l20@gmail.com)
2.0_2 18 Nov 2014 15:47:35	matthew	* Drop the patches replacing strnlen() -- this function is available in libc for all currently supported versions of FreeBSD. * Install the default config file into ${PREFIX}/etc/repmgr.conf.sample and uses the standard @sample plist functionality. This is where hier(7) expects config files to be installed. * Add an rc.d script to start up repmgrd automatically on system boot, which relies on the config file being in ${PREFIX}/etc/. PR: 195106 Submitted by: matthew Approved by: 5u623l20@gmail.com (maintainer)
2.0_1 20 Oct 2014 10:41:13	bapt	Cleanup plist
2.0_1 25 Aug 2014 17:53:27	crees	Convert pgsql ports to use USES+=pgsql Reviewed by: bapt
2.0_1 18 Aug 2014 21:36:35	antoine	Remove a few remaining %%PORTDATA%% With hat: portmgr
2.0_1 30 May 2014 05:31:16	sunpoet	- Fix dependency: this port requires libpgcommon.a from postgresqlXX-server - Bump PORTREVISION for dependency change PR: ports/189773 Submitted by: marck Approved by: Muhammad Moinur Rahman <5u623l20@gmail.com> (maintainer)
2.0 24 May 2014 14:11:50	sunpoet	- Update to 2.0 - Pass maintainership to submitter Changes: http://www.repmgr.org/release-notes-2.0.html PR: ports/189775 Submitted by: Muhammad Moinur Rahman <5u623l20@gmail.com>
1.2.0 13 May 2014 16:48:51	antoine	Maintainer no longer wishes to maintain those 2 ports
1.2.0 22 Oct 2013 03:19:13	danilo	- Convert {BUILD,RUN}_DEPENDS to USE_PGSQL [1] - Add LICENSE - Convert USE_GMAKE to USES - Add DOCS option - Add stage support PR: ports/183166 Submitted by: Alexander Pyhalov <alp@sfedu.ru> (maintainer) [1]
1.2.0 20 Sep 2013 16:13:49	bapt	Add NO_STAGE all over the place in preparation for the staging support (cat: databases)
1.2.0 10 Dec 2012 02:27:32	swills	- Update to 1.2.0 - Update MASTER_SITES - Assign with expansion for RUN_DEPENDS -> BUILD_DEPENDS - Remove patch-strnlen after refactoring changes into new patches - Add patch to fix compilation by cherrypicking a commit in 2.x - Trim Makefile header PR: ports/174216 Submitted by: Kubilay Kocak <koobs.freebsd@gmail.com> (maintainer) Approved by: Alexander Pyhalov <alp@rsu.ru> (maintainer)
1.1.0 30 Sep 2011 18:52:32	pav	- Unbreak on FreeBSD 7 Submitted by: Alexander Pyhalov <alp@rsu.ru> (maintainer)
1.1.0 25 Aug 2011 15:04:16	sunpoet	- Fix RUN_DEPENDS - Space/tab twiddle PR: ports/160008 Submitted by: Phil Phillips <pphillips@experts-exchange.com> Approved by: maintainer
1.1.0 24 Apr 2011 11:05:17	culot	- Update to 1.1.0 [1] - Fix typo in RUN_DEPENDS PR: ports/156479 [1] Submitted by: Alexander Pyhalov <alp@sfedu.ru> (maintainer)
1.0.0 18 Jan 2011 13:10:35	wen	repmgr allows you to monitor and manage your replicated PostgreSQL databases as a single cluster. WWW: http://projects.2ndquadrant.com/repmgr PR: ports/154074 Submitted by: Alexander Pyhalov <alp@sfedu.ru> Feature safe: yes

Number of commits found: 46

Login
User Login Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts? About the authors Issues FAQ How big is it? Security Policy Privacy Blog Contact

Search
Enter Keywords: more...

Latest Vulnerabilities

filezilla	Apr 16
putty	Apr 16
putty-nogtk	Apr 16
go121	Apr 15
go122	Apr 15
chromium	Apr 12
ungoogled-chromium	Apr 12
electron27	Apr 11
electron28	Apr 11
forgejo	Apr 11
gitlab-ce	Apr 11
jose	Apr 11
openssl	Apr 11
openssl-quictls	Apr 11
openssl31	Apr 11

14 vulnerabilities affecting 305 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last processed:
2024-04-16 06:42:40 UTC

Ports
Home Categories Deleted ports Sanity Test Failures Newsfeeds

Statistics

Graphs
NEW Graphs (Javascript)

Calculated hourly:

Port count	32211
Broken	87
Deprecated	183
Ignore	220
Forbidden	2
Restricted	2
No CDROM	1
Vulnerable	41
Expired	8
Set to expire	157
Interactive	0
new 24 hours	2
new 48 hours	3
new 7 days	9
new fortnight	63
new month	183

Get notified when packages are built