Re: Logical Replication Issue

From: Donzell White <whitedv(at)verizon(dot)net>
To: "mlewis(at)entrata(dot)com" <mlewis(at)entrata(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Logical Replication Issue
Date: 2020-06-30 18:05:28
Message-ID: 1666701639.381721.1593540328899@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My table has a primary key.  In addition, this is an initial load issue where the replication identity should not matter.

-----Original Message-----
From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Donzell White <whitedv(at)verizon(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Sent: Tue, Jun 30, 2020 1:05 pm
Subject: Re: Logical Replication Issue

Per the release notes, there are some enhancements to logical replication that came after 11.5 like 11.8 particularly related to replication identity full. Do you have a primary key or unique index that is being used for the replication identity?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-06-30 20:16:58 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device
Previous Message FOUTE K. Jaurès 2020-06-30 18:03:34 PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device