Re: Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)

2018-05-04 Thread Adrian Heath
On 04/05/18 12:07, Peter Eisentraut wrote: On 5/4/18 06:41, Adrian Heath wrote: The system is used 24/7. Can we run pg_basebackup while the master is still receiving updates without worrying about physical file corruptions in the generated archive file? Yes, as long as you follow the

Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)

2018-05-04 Thread Adrian Heath
We have master/standby servers running postgresql 9.6.5 on Debian 8.0 (Wheezy) 64 bit and we want to add a 3rd machine, streaming from the master but running off-site. The system is used 24/7. Can we run pg_basebackup while the master is still receiving updates without worrying about physical