pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDropping database in replica
3+ messages / 2 participants
[nested] [flat]
* Dropping database in replica
@ 2020-10-09 12:30 Massimo Ortensi <mortensi@unimaticaspa.it>
0 siblings, 1 reply; 3+ messages in thread
From: Massimo Ortensi @ 2020-10-09 12:30 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Dropping database in replica
@ 2020-10-09 15:04 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Massimo Ortensi <mortensi@unimaticaspa.it>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2020-10-09 15:04 UTC (permalink / raw)
To: Massimo Ortensi <mortensi@unimaticaspa.it>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Dropping database in replica
@ 2020-10-11 11:26 Massimo Ortensi <mortensi@unimaticaspa.it>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 3+ messages in thread
From: Massimo Ortensi @ 2020-10-11 11:26 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-10-11 11:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-10-09 12:30 Dropping database in replica Massimo Ortensi <mortensi@unimaticaspa.it>
2020-10-09 15:04 ` Laurenz Albe <laurenz.albe@cybertec.at>
2020-10-11 11:26 ` Massimo Ortensi <mortensi@unimaticaspa.it>
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