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(dot)klaver(at)aklaver(dot)com