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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details
pg_reorg PostgreSQL utility to reorganize tables
1.1.11_3 databases Deleted on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 1.1.11_3Version of this port present on the latest quarterly branch.
Maintainer: portmaster@BSDforge.com search for ports maintained by this maintainer
Port Added: 2011-12-26 20:00:46
Last Update: 2021-06-13 10:50:22
Commit Hash: a3da90c
License: BSD3CLAUSE
WWW:
https://BSDforge.com/projects/databases/pg_reorg/
Description:
pg_reorg can reorganize tables of a PostgreSQL database without any locks, so that you can retrieve or update rows in tables being reorganized. The module is developed to be a better alternative to CLUSTER and VACUUM FULL. WWW: https://BSDforge.com/projects/databases/pg_reorg/
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (12 items)
Collapse this list.
  1. /usr/local/share/licenses/pg_reorg-1.1.11_3/catalog.mk
  2. /usr/local/share/licenses/pg_reorg-1.1.11_3/LICENSE
  3. /usr/local/share/licenses/pg_reorg-1.1.11_3/BSD3CLAUSE
  4. bin/pg_reorg
  5. lib/postgresql/pg_reorg.so
  6. share/postgresql/extension/pg_reorg--1.1.11.sql
  7. share/postgresql/extension/pg_reorg.control
  8. share/postgresql/extension/pg_reorg.sql
  9. share/postgresql/extension/uninstall_pg_reorg.sql
  10. @owner
  11. @group
  12. @mode
Collapse this list.
Dependency lines:
  • pg_reorg>0:databases/pg_reorg
No installation instructions:
This port has been deleted.
PKGNAME: pg_reorg
Flavors: there is no flavor information for this port.
distinfo:
SHA256 (pg_reorg-1.1.11.tar.gz) = 595641e0e6745f99897ffc4c229b084ca0f8b52002469e22a0cf7c0ba676ec33 SIZE (pg_reorg-1.1.11.tar.gz) = 74228

Packages (timestamps in pop-ups are UTC):
pg_reorg
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--1.1.11_3---1.1.11_3-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
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:
  1. gmake>=4.3 : devel/gmake
  2. postgres : databases/postgresql95-server
  3. as : devel/binutils
Runtime dependencies:
  1. postgres : databases/postgresql95-server
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pg_reorg-1.1.11_3: DOCS=on: Build and/or install documentation ===> Use 'make config' to modify these settings
Options name:
databases_pg_reorg
USES:
gmake pgsql:9.5 uidfix
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. http://pgfoundry.org/frs/download.php/3821/
  2. https://BSDforge.com/projects/source/databases/pg_reorg/
Collapse this list.
Port Moves
  • port deleted on 2021-06-13
    REASON: Removed, abandonware only for PostgreSQL 9.5

Number of commits found: 17

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.1.11_3
13 Jun 2021 10:50:22
commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1 files touched by this commit
Rene Ladan (rene) search for other commits by this committer
*/*: Remove expired ports:

2021-06-13 databases/postgresql95-client: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-contrib: PostgreSQL-9.5 has reached
end-of-life
2021-06-13 databases/postgresql95-docs: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-pgtcl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-plperl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-plpython: PostgreSQL-9.5 has reached
end-of-life
2021-06-13 databases/postgresql95-pltcl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-server: PostgreSQL-9.5 has reached end-of-life
databases/pg_reorg: abandonware only for PostgreSQL 9.5
databases/pgespresso: functionality part of PostgreSQL 9.6 and later
1.1.11_3
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
1.1.11_3
24 Jul 2020 16:48:41
Revision:543260Original commit files touched by this commit
rene search for other commits by this committer
databases/pg_reorg: limit to PostgreSQL 9.5, bump PORTREVISION
1.1.11_2
19 Oct 2019 12:21:22
Revision:514793Original commit files touched by this commit
rakuco search for other commits by this committer
Switch MASTER_SITES and WWW to https in Chris' ports.

PR:		241272
Submitted by:	Chris Hutchinson <portmaster@bsdforge.com> (maintainer)
1.1.11_2
03 Aug 2019 10:49:00
Revision:507946Original commit files touched by this commit
tobik search for other commits by this committer
databases/pg_reorg: Fixup r507940 and declare compatible PostgreSQL versions
correctly
1.1.11_2
03 Aug 2019 09:02:38
Revision:507940Original commit files touched by this commit
tobik search for other commits by this committer
databases/pg_reorg: Do not build on newer PostgreSQL versions

It fails to build with PostgreSQL 11:

pgut/pgut.c:389:47: error: too few arguments to function call, expected 4, have
3
        return simple_prompt("Password: ", 100, false);
               ~~~~~~~~~~~~~                         ^
/usr/local/include/postgresql/server/port.h:193:1: note: 'simple_prompt'
declared here
extern void simple_prompt(const char *prompt, char *destination, size_t destlen,
^
1 error generated.

http://package18.nyi.freebsd.org/data/120amd64-default-PR239514/2019-07-29_20h41m52s/logs/pg_reorg-1.1.11_2.log

And after fixing that one:
(Only the first 15 lines of the commit message are shown above View all of this commit message)
1.1.11_2
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit
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
1.1.11_1
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit
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
1.1.11
24 Jun 2018 00:54:27
Revision:473169Original commit files touched by this commit
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)
1.1.11
14 Apr 2015 06:56:15
Revision:383980Original commit files touched by this commit
danfe search for other commits by this committer
- Provide another master site, as it appears that pgfoundry may be fading
- Point WWW line to a working page in the port description, reformat it
- Unmute installation command while I'm here

PR		199424
Submitted by:	maintainer
1.1.11
24 Feb 2015 17:44:03
Revision:379831Original commit files touched by this commit
jbeich search for other commits by this committer
- Update to 1.1.11
- Require PostgreSQL 9.1+
- Strip binaries
- Sync pkg-descr
- Pass maintainership

PR:		197586
Submitted by:	Chris Hutchinson <portmaster@bsdforge.com>

ChangeLog:
- Supports PostgreSQL 9.4
- Change not to wait for transactions in different databases.
- Support for DESC, NULLS FIRST/LAST, COLLATE to index keys.
1.1.10
29 May 2014 20:21:45
Revision:355744Original commit files touched by this commit
mat search for other commits by this committer
- Fix build
- Fix plist with pgsql > 9.0
- Update to 1.1.10 to fix with pgsql >= 9.3

Sponsored by:	Absolight
1.1.8
13 May 2014 16:48:51
Revision:353971Original commit files touched by this commit
antoine search for other commits by this committer
Maintainer no longer wishes to maintain those 2 ports
1.1.8
05 May 2014 13:48:25
Revision:353002Original commit files touched by this commit
bapt search for other commits by this committer
Convert to USES=pgsql

While here:
databases/pg_reorg
- stagify

databases/iplike
- convert to USES=libtool
- strip binarie

databases/ip4r
- strip binaries

databases/postgresql-libpgeasy
- convert to USES=libtool
- strip binaries
- stagify

databases/postgresql-libpqxx
- convert to USES=libtool
- strip binaries

databases/postgresql-libpqxx3
- convert to USES=libtool
- strip binaries
1.1.8
20 Sep 2013 16:13:49
Revision:327717Original commit files touched by this commit
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
1.1.8
21 Jul 2013 17:16:14
Revision:323404Original commit files touched by this commit
marino search for other commits by this committer
databases/pg_reorg: Upgrade to v1.1.8, use DESTDIR

This version upgrade is required for PostgreSQL 9.2 support and was
proposed by the maintainer.  Additional changes were added by myself:
  1) Header trimmed
  2) USE_GMAKE changed to USES+=gmake
  3) NOPORTSDOCS changed to options/DOCS
  4) Proposed logic for alternative PLIST was replaced with DESTDIR support

The package list changes directory structure depending if postgresql 91
or higher client is used.  This could have been handled with PLIST_SUB
(rather than an alternate pkg-plist) but PGSQL_VER variable isn't
evaluated until much later.  Using an intermediate DESTDIR scheme not
only makes the DOCS option handling cleaner, it makes the pkg-plist creation
bulletproof.  It also gives this port a head start for future "Stage" support.

PR:		ports/179954
Submitted by:	marino
Approved by:	bapt (mentor), maintainer
1.1.7
26 Dec 2011 20:00:32
Original commit files touched by this commit
pawel search for other commits by this committer
pg_reorg allows you to reorganize your tables online,
for example, do online vacuum full or cluster.

WWW: http://pgfoundry.org/projects/reorg/

PR:             ports/160313
Submitted by:   alp@sfedu.ru, improvements by rm@

Number of commits found: 17