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/
===> 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
*/*: 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
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 )
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)
- 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
- 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.
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
