| From: | Jeff Ross <jross(at)openvistas(dot)net> |
|---|---|
| To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Removing a subscription that does not exist |
| Date: | 2021-07-12 14:24:50 |
| Message-ID: | d1175013-1bfc-cfc9-a2be-9d007c3d7f4f@openvistas.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7/11/21 7:38 PM, Kyotaro Horiguchi wrote:
> At Fri, 9 Jul 2021 10:49:46 -0600, Jeff Ross <jross(at)openvistas(dot)net> wrote in
>> Hello,
>>
>> I'm working with an RDS instance running 12 that has an old
>> subscription that I can't seem to drop.
> ...
> Look at the subdbid field in the first query result. You were logging
> into the databsae with OID=66754 and the subscription "metro" belongs
> to the database 14313. The second command doesn't show metro which is
> not of the current database.
>
>
>
> | What else can I try to remove this old non-functional subscription?
>> ...
> Thus you need to log in to the databse OID=14313 to manipulate on the
> subsciption metro.
>
> regards.
>
That was it exactly. Once I connected to that database the subscription
could be disabled, its slot name set to None and finally dropped.
Thank you!
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-07-12 14:27:01 | Re: Undocumented array_val[generate_series(...)] functionality? |
| Previous Message | Phil Endecott | 2021-07-12 13:43:15 | Re: Why can't I drop a tablespace? |