BDR Monitoring, missing pg_stat_logical_decoding view

Hi,

On 2015-02-17 22:37:43 +0000, Steve Boyle wrote:

I'm trying to setup replication monitoring for BDR, following the doc here:
https://wiki.postgresql.org/wiki/BDR_Monitoring

My BDR installs seem to be missing the pg_stat_logical_decoding view. Is there something specific I need to do to install/create that view?

It has been renamed since - it's part of postgresql 9.4 and named
pg_replication_slots. It seems most of the page refers to it by the
correct name, just a subsection doesn't... Sorry for that.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thank you, that was helpful.

In the pg_replication_slots view, I see that xmin is always NULL, is that expected? I'm not sure how to measure the BDR update latency without this xmin value.

If I run pg_get_transaction_committime(catalog_xmin), sometimes I get what looks like a default time stamp of 1999-12-31 16:00:00-08, is that expected?

Thanks,
Steve Boyle

-----Original Message-----
From: Andres Freund [mailto:andres@2ndquadrant.com]
Sent: Wednesday, February 18, 2015 5:19 AM
To: Steve Boyle
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] BDR Monitoring, missing pg_stat_logical_decoding view

Hi,

On 2015-02-17 22:37:43 +0000, Steve Boyle wrote:

I'm trying to setup replication monitoring for BDR, following the doc here:
https://wiki.postgresql.org/wiki/BDR_Monitoring

My BDR installs seem to be missing the pg_stat_logical_decoding view. Is there something specific I need to do to install/create that view?

It has been renamed since - it's part of postgresql 9.4 and named pg_replication_slots. It seems most of the page refers to it by the correct name, just a subsection doesn't... Sorry for that.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general