PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Assuming we have a server that should be archiving transaction logs, follow these steps to store them in a cloud service using WAL-E:

1. Edit the postgresql.conf file to reflect these parameter settings:

archive_command = 'envdir ~postgres/env wal-e wal-push %p' 
archive_timeout = '60' 

2. Reload the PostgreSQL service with the following command as the postgres user:

pg_ctl -D /db/pgdata reload 

3. Connect as the postgres user and force it to switch transaction logs with this SQL if using PostgreSQL 10 or above:

SELECT pg_switch_wal(); 

4. Users of PostgreSQL 9.6 and below should use this SQL instead:

SELECT pg_switch_xlog(); 

5. Watch the end of the PostgreSQL log file for transmission success. Use a command similar to this to capture ...