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@xxxxxxxxxxxxxxx] Sent: Wednesday, February 18, 2015 5:19 AM To: Steve Boyle Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
