pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't drop subscription
5+ messages / 3 participants
[nested] [flat]
* Can't drop subscription
@ 2022-02-21 17:28 Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 17:34 ` Re: Can't drop subscription Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Axel Rau @ 2022-02-21 17:28 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't drop subscription
2022-02-21 17:28 Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
@ 2022-02-21 17:34 ` Ron <ronljohnsonjr@gmail.com>
2022-02-21 18:04 ` Re: Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
0 siblings, 1 reply; 5+ messages in thread
From: Ron @ 2022-02-21 17:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't drop subscription
2022-02-21 17:28 Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 17:34 ` Re: Can't drop subscription Ron <ronljohnsonjr@gmail.com>
@ 2022-02-21 18:04 ` Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 18:22 ` Re: Can't drop subscription Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Axel Rau @ 2022-02-21 18:04 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
> Am 21.02.2022 um 18:34 schrieb Ron <ronljohnsonjr@gmail.com>:
>
>
> Why the backslashes, instead of:
>
> psql -c "DROP SUBSCRIPTION meteo;“
This was the error message from an ansible script. I assumed, ansible did the quoting.
Doing it per hand, works:
- - -
Why the backslashes, instead of:
psql -c "DROP SUBSCRIPTION meteo;“
- - -
I will put the command into a file and give that per -f to psql.
Thanks for answering, Axel
---
PGP-Key: CDE74120 ☀ computing @ chaos claudius
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't drop subscription
2022-02-21 17:28 Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 17:34 ` Re: Can't drop subscription Ron <ronljohnsonjr@gmail.com>
2022-02-21 18:04 ` Re: Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
@ 2022-02-21 18:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-02-23 20:47 ` [RESOLVED] Re: Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2022-02-21 18:22 UTC (permalink / raw)
To: Axel Rau <Axel.Rau@Chaos1.DE>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* [RESOLVED] Re: Can't drop subscription
2022-02-21 17:28 Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 17:34 ` Re: Can't drop subscription Ron <ronljohnsonjr@gmail.com>
2022-02-21 18:04 ` Re: Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 18:22 ` Re: Can't drop subscription Tom Lane <tgl@sss.pgh.pa.us>
@ 2022-02-23 20:47 ` Axel Rau <Axel.Rau@Chaos1.DE>
0 siblings, 0 replies; 5+ messages in thread
From: Axel Rau @ 2022-02-23 20:47 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
> Am 21.02.2022 um 19:22 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>
> 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.
The problem did not happen again after I did a clean clone, where I let CREATE SUBSCRIPTION create the slot.
I implemented this recipe [1] in ansible and it upgraded 2 subscribers and one publisher in 4 minutes from 12 to 13. (-;
Thanks for all your help,
Axel
[1] https://elephanttamer.net/?p=58 <https://elephanttamer.net/?p=58;
---
PGP-Key: CDE74120 ☀ computing @ chaos claudius
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2022-02-23 20:47 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-02-21 17:28 Can't drop subscription Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 17:34 ` Ron <ronljohnsonjr@gmail.com>
2022-02-21 18:04 ` Axel Rau <Axel.Rau@Chaos1.DE>
2022-02-21 18:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-02-23 20:47 ` Axel Rau <Axel.Rau@Chaos1.DE>
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