On Sun, May 18, 2014 at 02:10:53PM +0530, Raghavendra wrote: > Hi, > > PostgreSQL 9.4 document for pg_stat_replication view mentions column name as > "backend_xid", whereas when a view described it shows column name as > "backend_xmin". > http://www.postgresql.org/docs/devel/static/monitoring-stats.html# > PG-STAT-REPLICATION-VIEW > > postgres=# select version(); > -[ RECORD 1 ] > ------------------------------------------------------------------------------------------------------------ > version | PostgreSQL 9.4beta1 on x86_64-unknown-linux-gnu, compiled by gcc > (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit > > postgres=# \d pg_stat_replication > View "pg_catalog.pg_stat_replication" > Column | Type | Modifiers > ------------------+--------------------------+----------- > pid | integer | > usesysid | oid | > usename | name | > application_name | text | > client_addr | inet | > client_hostname | text | > client_port | integer | > backend_start | timestamp with time zone | > backend_xmin | xid | > state | text | > sent_location | pg_lsn | > write_location | pg_lsn | > flush_location | pg_lsn | > replay_location | pg_lsn | > sync_priority | integer | > sync_state | text | > > Is it a typo in pg_stat_replication view column ? This has been fixed by this commit: commit eb56812144bb310f7cb2f63e53d6d58f30df95b5 Author: Fujii Masao <fujii@xxxxxxxxxxxxxx> Date: Mon May 19 17:03:30 2014 +0900 Fix incorrect column name in pg_stat_replication document. Fabrízio de Royes Mello -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
