Re: Logical replication from 11.x to 12.x and "unique key violations"

2020-07-20 Thread John Ashmead
the specified tables in some random order. > If there are FK references involved, the replication would have to be > done with referenced tables first, and I bet there's no logic for that. > (Even if there was, it could not cope with circular references or > self-references.) >

How can you find out what point logical replication is at?

2020-08-03 Thread John Ashmead
ived_lsn | 9EF/89ADF7E0 last_msg_send_time| 2020-08-03 10:15:48.644575-04 last_msg_receipt_time | 2020-08-03 10:14:57.247993-04 latest_end_lsn| 9EF/89ADF7E0 latest_end_time | 2020-08-03 09:30:57.974223-04 John Ashmead 139 Montrose Avenue Rosemont, PA, 19010-1508 (610) 527 9560

Re: How can you find out what point logical replication is at? -- or weird, slow, infinite loop

2020-08-03 Thread John Ashmead
some kind of a slow infinite loop. Corrupted WAL file? Any other ideas of what to look for? TIA, John > On Aug 3, 2020, at 10:38 AM, John Ashmead > wrote: > > I have logical replication setup from a factory in Zhuhai China to a data > warehouse in New Jersey. We are using post