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)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers