Skip site navigation (1) Skip section navigation (2)

Re: streaming replication

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Karuna Karpe <karuna(dot)karpe(at)os3infotech(dot)com>
Cc: Vinay <vinay(dot)dhoom(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: streaming replication
Date: 2011-11-04 01:38:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Wed, Nov 2, 2011 at 4:48 PM, Karuna Karpe
<karuna(dot)karpe(at)os3infotech(dot)com> wrote:
> But I want huge amount of data in database. so it is take so much to take
> dump from slave db and load in master db.
> for example :-
>         I have one master db server with 20GB of data and two slave db
> server are replicated from master server.  when my master db server is fail,
> then one of slave server become new master server.  In new master server
> 50MB of data add into database.  After some time my failed(old) master back
> up, then I want to become my old master server as master and my new master
> server become slave(as previous setting). So please let me know that how
> replication only that 50MB data into old master database server????

What about using rsync to take a base backup from new master and load it
onto old master? rsync can reduce the backup time by sending only differences
between those two servers.


Fujii Masao
NTT Open Source Software Center

In response to


pgsql-admin by date

Next:From: Shivakumar RamannavarDate: 2011-11-04 09:27:04
Subject: Fwd: My Query to insert and retrieve takes time
Previous:From: Erdinc AkkayaDate: 2011-11-02 08:58:07
Subject: process 22254 acquired ShareLock on transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group