Thread: Can we run pg_basebackup master is still working normally (selects,updates, deleted, etc)
Can we run pg_basebackup master is still working normally (selects,updates, deleted, etc)
From
Adrian Heath
Date:
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 file corruptions in the generated archive file? The documentation states that v9.6 supports running concurrent backups. Can the users operate as normal, ie issue inserts/deletes/updates, while the file copy is occurring? We can pick a time when the system is quieter but there is always something/someone updating the system.
Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
From
Peter Eisentraut
Date:
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 instructions about saving the WAL generated during the backup and replaying it on the newly created standby. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
From
Adrian Heath
Date:
On 04/05/18 12:07, Peter Eisentraut wrote:
Thank you.
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 instructions about saving the WAL generated during the backup and replaying it on the newly created standby.