The first thing we want to achieve in this chapter is to create a configuration to perform standard Point-In-Time Recovery (PITR). There are a couple of advantages of PITR over ordinary dumps:
- You will lose less data because you can restore to a certain point in time and not just to the fixed backup point
- Restoring will be faster because indexes don't have to be created from scratch. They are just copied over and are ready to use
Configuring for PITR is easy. Just a handful of changes have to be made in the postgresql.conf file:
wal_level = replica # used to be "hot_standby" in older versions max_wal_senders = 10 # at least 2, better at least 2
The wal_level variable says that the server is supposed to produce ...