,text,text,integer,text[]) line 3 at
PERFORM
I can see that the schema exists:
postgres=# \dn
List of schemas
Name | Owner
+--
bdr| postgres
public | postgres
Any pointers on what I am missing are appreciated.
Thanks,
Steve Boyle
--
Sent via pgsql
Craig,
Your response was very helpful, thank you.
I was looking at some of the standard bits in Postgres like
txid_current_snapshot() and txid_snapshot_xmin(). Can the results from
txid_snapshot_xmin be used with pg_get_transaction_committime() to get the
latency?
Thanks again,
Steve Boyle
there is activity on the database. I do/can get a catalog_xmin value.
Should I expect the 'xmin' value to be null? Is there another way to monitor
the replication latency when using BDR?
Thanks,
Steve Boyle
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
time stamp of 1999-12-31 16:00:00-08, is that expected?
Thanks,
Steve Boyle
-Original Message-
From: Andres Freund [mailto:and...@2ndquadrant.com]
Sent: Wednesday, February 18, 2015 5:19 AM
To: Steve Boyle
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] BDR Monitoring, mi
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?
Thanks,
Steve Boyle
--
: Steve Boyle
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] trouble adding a node to BDR
On 30 January 2015 at 07:21, Steve Boyle
mailto:sbo...@connexity.com>> wrote:
I have two servers/nodes setup with BDR and that is working. I’m trying to add
a third node. When the thir
I have two servers/nodes setup with BDR and that is working. I'm trying to add
a third node. When the third node tries to sync, I get an error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 600; 1255 17054 FUNCTION
cast_txt_to_int(text,
