Обсуждение: Can't drop subscription

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\“
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

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.

Axel Rau <Axel.Rau@Chaos1.DE> writes:
> This was the  error message from an ansible script. I assumed, ansible did the quoting.
> Doing it per hand, works:

Seems likely that the ansible script is connecting to a different
database.  Log-rep subscriptions are database-local objects, not
cluster-wide, so it matters.

            regards, tom lane