On Wed, Nov 2, 2011 at 4:48 PM, Karuna Karpe <karuna.karpe@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
