Search Postgresql Archives
Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)
- From: Adrian Heath <adrian.heath@xxxxxxxxxxxxxx>
- Date: Fri, 4 May 2018 11:41:50 +0100
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.7.0
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.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]