From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Is it typo in pg_stat_replication column name in PG 9.4 ? |
Date: | 2014-05-29 19:16:42 |
Message-ID: | 20140529191642.GF28469@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)postgresql(dot)org>
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Brazeau | 2014-05-29 19:30:04 | Re: log_collector & sysout on windows |
Previous Message | hubert depesz lubaczewski | 2014-05-29 18:51:40 | Re: Backups over slave instead master? |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2014-05-29 19:17:44 | Re: recovery testing for beta |
Previous Message | Bruce Momjian | 2014-05-29 18:45:45 | Re: [PATCH] Replacement for OSSP-UUID for Linux and BSD |