postgresql-9.6-dirtyread - Read dead but unvacuumed tuples from a PostgreSQL relation

Property Value
Distribution Ubuntu 17.10 (Artful Aardvark)
Repository Ubuntu Universe i386
Package name postgresql-9.6-dirtyread
Package version 1.2
Package architecture i386
Package type deb
Installed size 35 B
Download size 9.23 KB
Official Mirror
The pg_dirtyread extension provides the ability to read dead but unvacuumed
rows from a PostgreSQL relation.


Package Version Architecture Repository
postgresql-9.6-dirtyread_1.2_amd64.deb 1.2 amd64 Ubuntu Universe
postgresql-9.6-dirtyread - - -


Name Value
libc6 >= 2.4
postgresql-9.6 -


Type URL
Binary Package postgresql-9.6-dirtyread_1.2_i386.deb
Source Package pg-dirtyread

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install postgresql-9.6-dirtyread deb package:
    # sudo apt-get install postgresql-9.6-dirtyread




2017-08-06 - Christoph Berg <>
pg-dirtyread (1.2) unstable; urgency=medium
* Refuse to return the "dead" pseudo column during recovery,
because GetOldestXmin() asserts !RecoveryInProgress().
Spotted by Andreas Seltenreich, thanks!
2017-07-23 - Christoph Berg <>
pg-dirtyread (1.1) unstable; urgency=medium
* Initial release.
* Changes from 1.0:
+ Fix some crashes.
+ Add ability to retrieve system columns such as xmax and ctid.
+ Add "dead" column to allow identification of removed rows

See Also

Package Description
postgresql-9.6-ip4r_2.1.1-1ubuntu2_i386.deb IPv4 and IPv6 types for PostgreSQL 9.6
postgresql-9.6-mimeo_1.5.1-1_all.deb specialized, per-table replication between PostgreSQL instances
postgresql-9.6-mysql-fdw_2.2.0-2_i386.deb Postgres 9.6 Foreign Data Wrapper for MySQL
postgresql-9.6-ogr-fdw_1.0.2-2_i386.deb PostgreSQL foreign data wrapper for OGR
postgresql-9.6-orafce_3.3.1-3_i386.deb Oracle support functions for PostgreSQL 9.6
postgresql-9.6-partman_2.6.3-1_i386.deb PostgreSQL Partition Manager
postgresql-9.6-pgaudit_1.1.0-1_i386.deb PostgreSQL Audit Extension
postgresql-9.6-pgextwlist_1.5-1_i386.deb PostgreSQL Extension Whitelisting
postgresql-9.6-pgfincore_1.2-2_i386.deb set of PostgreSQL functions to manage blocks in memory
postgresql-9.6-pglogical_2.0.0-1_i386.deb Logical Replication Extension for PostgreSQL
postgresql-9.6-pgmemcache_2.3.0-3ubuntu3_i386.deb PostgreSQL interface to memcached
postgresql-9.6-pgmp_1.0.2-3_i386.deb arbitrary precision integers and rationals for PostgreSQL 9.6
postgresql-9.6-pgpool2_3.6.5-1_i386.deb connection pool server and replication proxy for PostgreSQL - modules
postgresql-9.6-pgq3_3.2.6-5_i386.deb Skype tools for PostgreSQL replication, londiste and PGQ
postgresql-9.6-pgrouting-doc_2.4.2-1_all.deb Routing functionality support for PostgreSQL/PostGIS (Documentation)