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: CAHGQGwHn8DLQF1vPaizJzwtFk+Y0ciML-zjXct_y6NmZ+BFy6g@mail.gmail.com (view raw or flat)
Thread:
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.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

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-2014 The PostgreSQL Global Development Group