Обсуждение: Dropping database in replica

Поиск
Список
Период
Сортировка

Dropping database in replica

От
Massimo Ortensi
Дата:
Hi everybody.

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 ?


Thanks in advance





Re: Dropping database in replica

От
Massimo Ortensi
Дата:
No, replication is running correctly, and the databases existing in the
master are up to date

Unfortunately replication db logs of the drop database date have been
rewritten

Il 09/10/2020 17.04, Laurenz Albe ha scritto:
>
> There must be something that broke replication.
> Look into the PostgreSQL log of the standby server.
>
> Yours,
> Laurenz Albe