Subject: Re: Can't drop subscription
To: pgsql-admin@lists.postgresql.org
References: <68BABAB6-10DC-476A-8A16-39D94F231834@Chaos1.DE>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <0e2455bb-8253-676c-63cb-98f3c1a634ac@gmail.com>
Date: Mon, 21 Feb 2022 11:34:13 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: <68BABAB6-10DC-476A-8A16-39D94F231834@Chaos1.DE>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/0e2455bb-8253-676c-63cb-98f3c1a634ac%40gmail.com>
Precedence: bulk

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.