notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
pg_dirtyread Read dead but unvacuumed tuples from a PostgreSQL relation
2.4 databases 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 2.3Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-07-27 09:19:09
Last Update: 2021-12-21 18:46:16
Commit Hash: a3e31ec
License: BSD3CLAUSE
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (8 items)
Collapse this list.
  1. lib/postgresql/pg_dirtyread.so
  2. share/postgresql/extension/pg_dirtyread--1.0.sql
  3. share/postgresql/extension/pg_dirtyread--1.0--2.sql
  4. share/postgresql/extension/pg_dirtyread--2.sql
  5. share/postgresql/extension/pg_dirtyread.control
  6. /usr/local/share/licenses/postgresql13-pg_dirtyread-2.4/catalog.mk
  7. /usr/local/share/licenses/postgresql13-pg_dirtyread-2.4/LICENSE
  8. /usr/local/share/licenses/postgresql13-pg_dirtyread-2.4/BSD3CLAUSE
Collapse this list.
Dependency lines:
  • postgresql13-pg_dirtyread>0:databases/pg_dirtyread
To install the port:
cd /usr/ports/databases/pg_dirtyread/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pg_dirtyread
  • pkg install postgresql13-pg_dirtyread
PKGNAME: postgresql13-pg_dirtyread
Flavors: there is no flavor information for this port.
distinfo:
Packages (timestamps in pop-ups are UTC):
postgresql11-pg_dirtyread
ABIlatestquarterly
FreeBSD:11:aarch64-2.2
FreeBSD:11:amd64--
FreeBSD:11:armv6-2.2
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
postgresql12-pg_dirtyread
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd642.32.3
FreeBSD:11:armv6--
FreeBSD:11:i3862.32.3
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6-2.2
FreeBSD:12:armv7-2.2
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64-2.3
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv62.32.3
FreeBSD:13:armv72.3-
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc642.32.3
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv62.3-
FreeBSD:14:armv72.3-
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc642.3-
 
postgresql13-pg_dirtyread
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64-2.4
FreeBSD:12:amd642.42.4
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i3862.42.4
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch642.42.4
FreeBSD:13:amd642.42.4
FreeBSD:13:armv6--
FreeBSD:13:armv7-2.4
FreeBSD:13:i3862.42.4
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch642.4-
FreeBSD:14:amd642.4-
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i3862.4-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
postgresql95-pg_dirtyread
ABIlatestquarterly
FreeBSD:11:aarch642.0-
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch642.0-
FreeBSD:12:amd64--
FreeBSD:12:armv62.0-
FreeBSD:12:armv72.0-
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips642.0-
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 

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. as : devel/binutils
Runtime dependencies:
  1. postgres : databases/postgresql13-server
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/df7cb/pg_dirtyread/tar.gz/2.4?dummy=/
Collapse this list.

Number of commits found: 14

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
21 Dec 2021 18:46:16
 files touched by this commit commit hash:a3e31ec75216aea3ff864e4113a9d5796a7509f7  2.4
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/pg_dirtyread: Update to 2.4

Changes:	https://github.com/df7cb/pg_dirtyread/releases
		https://github.com/df7cb/pg_dirtyread/commits/master
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  2.3
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
19 Dec 2020 20:06:05
Original commit files touched by this commit Revision:558493  2.3
sunpoet search for other commits by this committer
Update to 2.3

Changes:	https://github.com/df7cb/pg_dirtyread/releases
		https://github.com/df7cb/pg_dirtyread/commits/master
26 Oct 2019 14:30:07
Original commit files touched by this commit Revision:515691  2.2
sunpoet search for other commits by this committer
Update to 2.2

Changes:	https://github.com/df7cb/pg_dirtyread/releases
27 Jul 2019 11:54:14
Original commit files touched by this commit Revision:507402  2.1_1
sunpoet search for other commits by this committer
Use PGSQL_VER_NODOT
26 Jul 2019 20:46:57
Original commit files touched by this commit Revision:507372  2.1_1
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
15 Jun 2019 19:21:02
Original commit files touched by this commit Revision:504252  2.1
sunpoet search for other commits by this committer
Update to 2.1

- Add LICENSE_FILE
- Update WWW
- Take maintainership

Changes:	https://github.com/df7cb/pg_dirtyread/releases
12 Dec 2018 01:35:36
Original commit files touched by this commit Revision:487272  2.0_1
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
30 Jul 2018 06:11:54
Original commit files touched by this commit Revision:475862  2.0
joneum search for other commits by this committer
databases/pg_dirtyread: Update to 2.0

Changelog: https://github.com/ChristophBerg/pg_dirtyread/releases

PR:		230157
Submitted by:	Dmitri Goutnik <dg@syrec.org>
24 Jun 2018 00:54:27
Original commit files touched by this commit Revision:473169  1.2
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)
22 Jun 2018 08:28:00
Original commit files touched by this commit Revision:473023  1.2
yuri search for other commits by this committer
Correction to r473019: Revert the unintended change to the 'Created by' headers.
22 Jun 2018 08:04:39
Original commit files touched by this commit Revision:473019  1.2
yuri search for other commits by this committer
Reset MAINTAINER on ports maintained by amutu@amutu.com

Based on the new policy of all maintained ports reset
when maintaner is absent for 3 months.

Bug#226400 for science/py-tensorflow is ignored since 2018-03-06 (3+ months).
portscout database indicates that 48.94% of his ports aren't updated.
07 Aug 2017 13:42:45
Original commit files touched by this commit Revision:447492  1.2
krion search for other commits by this committer
Update to version 1.2

PR:		221304
Submitted by:	maintainer
Approved by:	mat (mentor)
Differential Revision:	https://reviews.freebsd.org/D11910
27 Jul 2017 09:19:00
Original commit files touched by this commit Revision:446726  1.1
tz search for other commits by this committer
New port: databases/pg_dirtyread

The pg_dirtyread extension provides the ability to read dead but unvacuumed
rows from a relation.

WWW: https://github.com/ChristophBerg/pg_dirtyread

PR:           220537
Submitted by: Jov <amutu@amutu.com>

Number of commits found: 14