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.