From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PgLogical 1.1 feedback |
Date: | 2016-05-18 20:42:32 |
Message-ID: | 573CD3B8.2050603@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 05/18/2016 01:17 PM, Joshua D. Drake wrote:
And then there are things like this:
postgres=# \c logical
You are now connected to database "logical" as user "postgres".
logical=# select * from pglogical.node;
-[ RECORD 1 ]----------
node_id | 3276292710
node_name | replica2
-[ RECORD 2 ]----------
node_id | 2125761069
node_name | subscriber0
logical=# select pglogical.drop_node(node_name := 'replica2');
ERROR: cannot drop node "replica2" because it still has subscriptions
associated with it
HINT: drop the subscriptions first
logical=# select * from pglogical.subscription ;
-[ RECORD 1 ]--------+--------------------------------------
sub_id | 1763399739
sub_name | subscription1
sub_origin | 2125761069
sub_target | 3276292710
sub_origin_if | 2466493301
sub_target_if | 182959776
sub_enabled | t
sub_slot_name | pgl_logical_subscriber0_subscription1
sub_replication_sets | {default,default_insert_only,ddl_sql}
sub_forward_origins | {all}
logical=# select pglogical.drop_subscription(subscription_name :=
'subscription1');
The last function call never returns, it will just hang indefinitely.
Sincerely,
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-05-18 21:57:49 | Fix checkpoint skip logic on idle systems by tracking LSN progress |
Previous Message | Joshua D. Drake | 2016-05-18 20:17:13 | PgLogical 1.1 feedback |