Re: BDR Monitoring, missing pg_stat_logical_decoding view

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
BDRupdate 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-3116: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/createthat view? 

It has been renamed since - it's part of postgresql 9.4 and named pg_replication_slots. It seems most of the page
refersto 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