| From: | Steve Singer <steve(at)ssinger(dot)info> |
|---|---|
| To: | Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Erik Rijkers <er(at)xs4all(dot)nl> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-owner(at)postgresql(dot)org |
| Subject: | Re: Logical Replication WIP |
| Date: | 2017-01-02 04:23:00 |
| Message-ID: | 5869D5A4.3020405@ssinger.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 12/30/2016 05:53 AM, Petr Jelinek wrote:
> Hi,
>
> I rebased this for the changes made to inheritance and merged in the
> fixes that I previously sent separately.
>
>
>
I'm not sure if the following is expected or not
I have 1 publisher and 1 subscriber.
I then do pg_dump on my subscriber
./pg_dump -h localhost --port 5441 --include-subscriptions
--no-create-subscription-slot test|./psql --port 5441 test_b
I now can't do a drop database test_b , which is expected
but I can't drop the subscription either
test_b=# drop subscription mysub;
ERROR: could not drop replication origin with OID 1, in use by PID 24996
alter subscription mysub disable;
ALTER SUBSCRIPTION
drop subscription mysub;
ERROR: could not drop replication origin with OID 1, in use by PID 24996
drop subscription mysub nodrop slot;
doesn't work either. If I first drop the working/active subscription on
the original 'test' database it works but I can't seem to drop the
subscription record on test_b
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2017-01-02 04:32:25 | Re: safer node casting |
| Previous Message | Pavan Deolasee | 2017-01-02 03:58:28 | Re: rewrite HeapSatisfiesHOTAndKey |