From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Can't drop subscription
Date: Mon, 21 Feb 2022 11:34:13 -0600
Message-ID: <0e2455bb-8253-676c-63cb-98f3c1a634ac@gmail.com> (raw)
In-Reply-To: <68BABAB6-10DC-476A-8A16-39D94F231834@Chaos1.DE>
References: <68BABAB6-10DC-476A-8A16-39D94F231834@Chaos1.DE>
On 2/21/22 11:28 AM, Axel Rau wrote:
> While following this receipt:
> https://elephanttamer.net/?p=58
> I’ getting:
> ERROR: subscription \"meteo\" does not exist“
> with this command:
> psql -c \"DROP SUBSCRIPTION meteo\“
Why the backslashes, instead of:
psql -c "DROP SUBSCRIPTION meteo;“
(Presumably you're defining the host and database in PG* environment variables?)
> Same on both subscribers:
> - - -
> operations=# select oid,subdbid,subname,subowner,subenabled,subslotname,subpublications from pg_catalog.pg_subscription;
> oid | subdbid | subname | subowner | subenabled | subslotname | subpublications
> -------+---------+---------+----------+------------+-------------+-----------------
> 16451 | 16388 | meteo | 10 | t | meteo_dbb4 | {meteo}
> (1 row)
> - - -
> operations=# select oid,subdbid,subname,subowner,subenabled,subslotname,subpublications from pg_catalog.pg_subscription;
> oid | subdbid | subname | subowner | subenabled | subslotname | subpublications
> -------+---------+---------+----------+------------+-------------+-----------------
> 16455 | 16388 | meteo | 16384 | t | meteo_dbb5 | {meteo}
> (1 row)
> - - -
>
> How can I drop the subscriptions?
>
> Shouldn’t there be 2 different subscriptions for 2 subscribers to the same publisher?
>
> Any help appreciated,
> Axel
> ---
> PGP-Key: CDE74120 ☀ computing @ chaos claudius
>
>
>
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Can't drop subscription
In-Reply-To: <0e2455bb-8253-676c-63cb-98f3c1a634ac@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox