Обсуждение: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?
Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?
От
Fabrízio de Royes Mello
Дата:
On 18-05-2014 05:40, 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 ? > Hi, I think this is an incorrect list... moving to pgsql-hackers And yes, this seems to be a typo. Patch attached! Regards, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Вложения
On Mon, May 19, 2014 at 10:05 AM, Fabrízio de Royes Mello <fabrizio@timbira.com.br> wrote: > On 18-05-2014 05:40, 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 ? >> > > Hi, > > I think this is an incorrect list... moving to pgsql-hackers > > And yes, this seems to be a typo. Patch attached! Thanks! Applied. Regards, -- Fujii Masao
On 18-05-2014 05:40, Raghavendra wrote:> * backend_xmin* | xid |
> 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 |> state | text |Hi,
> 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 ?
>
I think this is an incorrect list... moving to pgsql-hackers
Noted..! Thank you. I will take care in my future posting.
--Raghav
And yes, this seems to be a typo. Patch attached!
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers