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