Re: logical replication snapshots

On 07/26/2018 03:01 PM, Dimitri Maziuk wrote:
> 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.

Sounds like my problems:)

> 
> 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?


Take a look at:

https://www.postgresql.org/docs/10/static/sql-alterpublication.html

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com