From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Is it typo in pg_stat_replication column name in PG 9.4 ? |
Date: | 2014-05-18 08:40:53 |
Message-ID: | CA+h6AhjxzPdA1HRLy-YgFEDW1JbxAXUAmBCQ+zPcHZk1quzNPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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 ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Kane | 2014-05-18 21:47:49 | materialised views vs unlogged table (also, ize vs ise) |
Previous Message | Alvaro Herrera | 2014-05-17 15:58:57 | Re: Adding a not null constraint faster |
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2014-05-18 09:08:34 | Re: 9.4 beta1 crash on Debian sid/i386 |
Previous Message | Pavel Stehule | 2014-05-18 07:52:49 | vacuumdb --all --analyze-in-stages - wrong order? |