May 2018
Intermediate to advanced
576 pages
30h 25m
English
The key point here is that we must have both the base backup and the archive in order to recover. Where you put them is entirely up to you. You can use any filesystem backup technology and/or filesystem backup management system to do this.
Many backup management systems have claimed that they have a PostgreSQL interface or plugin, but most of the time they only support logical backups. However, there's no need for them to officially support PostgreSQL; there is no any Runs on PostgreSQL badge or certification required. If you can copy files, then you can run the preceding processes to keep your database safe.
In the event the network or backup server goes down, then the command will begin to fail. When the archive_command fails, ...