Re: logical replication snapshots

From: Dimitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: logical replication snapshots
Date: 2018-07-26 22:01:28
Message-ID: fbe173fd-7780-a691-5ec5-f5173c5e5c57@bmrb.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/26/2018 04:39 PM, Adrian Klaver wrote:

> The thing that has me somewhat confused is:
>
> ERROR: permission denied for schema macromolecules
>
> I would thought the replication user could access that.

The more I look at the errors, the less sense it all makes.

Let me ask a different question: if I drop and re-create a published
table on the publisher without doing anything to the publication and
subscription, what happens?

Do I need to re-create the publication when I re-create the table?

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-26 22:34:13 Re: logical replication snapshots
Previous Message Adrian Klaver 2018-07-26 21:39:22 Re: logical replication snapshots