On Wed, Nov 2, 2011 at 4:48 PM, Karuna Karpe
> 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.
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-admin by date
|Next:||From: Shivakumar Ramannavar||Date: 2011-11-04 09:27:04|
|Subject: Fwd: My Query to insert and retrieve takes time|
|Previous:||From: Erdinc Akkaya||Date: 2011-11-02 08:58:07|
|Subject: process 22254 acquired ShareLock on transaction|