Re: Dropping database in replica

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Massimo Ortensi <mortensi(at)unimaticaspa(dot)it>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Dropping database in replica
Date: 2020-10-09 15:04:24
Message-ID: 5a3a8be1138b856f5af6b934f2f34bdd9a901a4d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2020-10-09 at 14:30 +0200, Massimo Ortensi wrote:
> I have a stand-by database replicated sending wals
>
> In the master cluster I dropped one of the databases, but the db is
> still present in the replica cluster.
>
> Is this normal or a misbehaviour of replication ?
>
> Then I tried to drop db manually in the standby db but of course got an
> error because the db is in read only mode.
>
> Any suggestion of a clean way to drop the db in D/R site ?

There must be something that broke replication.
Look into the PostgreSQL log of the standby server.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-10-09 15:06:00 Re: terminating connection due to conflict with recovery
Previous Message Massimo Ortensi 2020-10-09 12:30:01 Dropping database in replica