On 07/26/2018 05:34 PM, Adrian Klaver wrote: > On 07/26/2018 03:01 PM, Dimitri Maziuk wrote:
>> 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 Thanks but what I ask (and what I suspect happened here while I wasn't looking) is - create schema foo with tables bar and baz and some rows in 'em - create publication foopub with foo.bar and foo.baz - create subscription to foopub on the other node, initial sync and all - drop schema foo on the publisher - create schema foo with tables bar and baz and some rows in 'em The publication foopub is at this point fubar I take it? And needs to be re-created on the publisher and reconnected on the subscriber? Complete with with inital resync? -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
