4 ms·
pg_basebackup defaults to streaming WAL from whatever server it is taking a copy from, as backups are otherwise inconsistent. There's no need for the source dat
by lawrjone 6y ago
pg_basebackup defaults to streaming WAL from whatever server it is taking a copy from, as backups are otherwise inconsistent. There's no need for the source database to be paused while doing it, and even if your backup takes several hours to complete, once it finishes the target will have all the writes that occurred while the backup was being taken.
Thought you might find this useful, as no one should be considering a Postgres backup as a downtime requiring process!
- spapas82 6y agoThank you very much; I was using pg_dump to take backups until now!