[pgpool-general: 5825] Re: Trasforming old primary to new standby: is it possible to copy only new data with rsync (incremental copy)?

PropAAS DBA dba at propaas.com
Thu Dec 7 00:13:22 JST 2017

We have done this:

1) run pg_start_backup on the master

2) rsync the data

3) run pg_stop_backup on the master

On 11/27/2017 10:49 AM, Giancarlo Celli wrote:
> Hi,
> I have a db of several GB. Currently to transform an old primary 
> server to become a new standby server I use Pg_basebackup erasing 
> first the PD_DATA. But in this case the copy of the entire DB takes a 
> long time.
> Using rsync would it be possible to avoid deleting the previous 
> PG_DATA and making a copy of only the new data?
> Thanks!
> Best regards.
> Giancarlo
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20171206/7754c639/attachment.html>

More information about the pgpool-general mailing list