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

Property Value
Distribution Ubuntu 18.04 LTS (Bionic Beaver)
Repository Ubuntu Universe i386
Package filename postgresql-10-dirtyread_1.3_i386.deb
Package name postgresql-10-dirtyread
Package version 1.3
Package release -
Package architecture i386
Package type deb
Category universe/database
Homepage -
License -
Maintainer Ubuntu Developers <>
Download size 9.43 KB
Installed size 35.00 KB
The pg_dirtyread extension provides the ability to read dead but unvacuumed
rows from a PostgreSQL relation.


Package Version Architecture Repository
postgresql-10-dirtyread_1.3_amd64.deb 1.3 amd64 Ubuntu Universe
postgresql-10-dirtyread - - -


Name Value
libc6 >= 2.4
postgresql-10 -


Type URL
Binary Package postgresql-10-dirtyread_1.3_i386.deb
Source Package pg-dirtyread

Install Howto

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




2017-09-23 - Christoph Berg <>
pg-dirtyread (1.3) unstable; urgency=medium
* Upload for PostgreSQL 10.
* Use TupleDescAttr to access tuple descriptor attributes.
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-10-ip4r_2.2-2_i386.deb IPv4 and IPv6 types for PostgreSQL 10
postgresql-10-jsquery_1.0.1-1_i386.deb PostgreSQL JSON query language with GIN indexing support
postgresql-10-mimeo_1.5.1-2_all.deb specialized, per-table replication between PostgreSQL instances
postgresql-10-mysql-fdw_2.3.0-2_i386.deb Postgres 10 Foreign Data Wrapper for MySQL
postgresql-10-ogr-fdw_1.0.5-2_i386.deb PostgreSQL foreign data wrapper for OGR
postgresql-10-orafce_3.6.1-1_i386.deb Oracle support functions for PostgreSQL 10
postgresql-10-partman_3.1.2-1_i386.deb PostgreSQL Partition Manager
postgresql-10-pgaudit_1.2.0-1_i386.deb PostgreSQL Audit Extension
postgresql-10-pgextwlist_1.6-1_i386.deb PostgreSQL Extension Whitelisting
postgresql-10-pgfincore_1.2.1-1_i386.deb set of PostgreSQL functions to manage blocks in memory
postgresql-10-pglogical_2.1.1-1_i386.deb Logical Replication Extension for PostgreSQL
postgresql-10-pgmemcache_2.3.0-4_i386.deb PostgreSQL interface to memcached
postgresql-10-pgmp_1.0.2-5_i386.deb arbitrary precision integers and rationals for PostgreSQL 10
postgresql-10-pgq-node_3.2.5-1_all.deb Cascaded queueing on top of PgQ
postgresql-10-pgq3_3.2.6-7_i386.deb Generic queue for PostgreSQL