pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedResync postgres database after master slave replication
2+ messages / 2 participants
[nested] [flat]
* Resync postgres database after master slave replication
@ 2015-05-21 13:18 shailesh <ligade_shailesh@bah.com>
0 siblings, 1 reply; 2+ messages in thread
From: shailesh @ 2015-05-21 13:18 UTC (permalink / raw)
To: pgsql-admin
Hello,
I have setup postgres 8.4 master-slave replication. What we want to do is
at some point, make both master slave independent and allow writes to both
for a day, and then somehow sync them again to continue master-slave. Is
this possible?
What I understood about master-slave is that the both databases must be in
sync only then master-slave can work. That's why I am thinking I have to
somehow merge both databases.
What manual (or automated) steps can be taken to get both databases merged
so that master-slave can resume? Will there be any wrt application (liferay
6)?
Appreciate any help.
S
--
View this message in context: http://postgresql.nabble.com/Resync-postgres-database-after-master-slave-replication-tp5850342.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Resync postgres database after master slave replication
@ 2015-05-22 16:53 Jan Lentfer <Jan.Lentfer@web.de>
parent: shailesh <ligade_shailesh@bah.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jan Lentfer @ 2015-05-22 16:53 UTC (permalink / raw)
To: shailesh <ligade_shailesh@bah.com>; +Cc: pgsql-admin
> Am 21.05.2015 um 15:18 schrieb shailesh <ligade_shailesh@bah.com>:
>
> Hello,
>
> I have setup postgres 8.4 master-slave replication. What we want to do is
>
> at some point, make both master slave independent and allow writes to both
> for a day, and then somehow sync them again to continue master-slave. Is
> this possible?
> What I understood about master-slave is that the both databases must be in
> sync only then master-slave can work. That's why I am thinking I have to
> somehow merge both databases.
> What manual (or automated) steps can be taken to get both databases merged
> so that master-slave can resume? Will there be any wrt application (liferay
> 6)?
>
> Appreciate any help.
>
That is not possible and I can't think of any system that will (reliably) do that. It's actually something most people will want to avoid by all possible means - split-brain on purpose.
Jan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-05-22 16:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-05-21 13:18 Resync postgres database after master slave replication shailesh <ligade_shailesh@bah.com>
2015-05-22 16:53 ` Jan Lentfer <Jan.Lentfer@web.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