Re: Logical Replication WIP

On 09/08/2016 06:59 PM, Petr Jelinek wrote:
> - the CREATE SUBSCRIPTION also tries to check if the specified 
> connection connects back to same db (although that check is somewhat 
> imperfect) and if it gets stuck on create slot it should be normally 
> cancelable (that should solve the issue Steve Singer had) 



When I create my subscriber database by doing a physical backup of the 
publisher cluster (with cp before I add any data) then I am unable to 
connect subscribe.
ie
initdb ../data
cp -r ../data ../data2
./postgres -D ../data
./postgres -D ../data2


This make sense when I look at your code, but it might not be what we want

I had the same issue when I created my subscriber cluster with 
pg_basebackup (The timeline on the destination cluster still shows as 1)