In the previous section, you have seen that enabling archiving takes just a handful of lines and offers a great deal of flexibility. In this section, we will see how to create a so called base backup, which can be used to apply XLOG later on. A base backup is an initial copy of the data.
Keep in mind that the XLOG itself is more or less worthless. It is only useful in combination with the initial base backup.
host replication all 192.168.0.34/32 md5
In PostgreSQL, there are two main options to create an initial base backup:
The following two sections will explain in detail how a base backup can be created:
The first and most common method to create a backup ...