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)