Archiving the transaction log
After taking a look at the big picture, we can see how things can be put to work.
The first thing you have to do when it comes to Point-in-time Recovery is archive the XLOG. PostgreSQL offers all the configuration options related to archiving through postgresql.conf
.
Let us see step by step what has to be done in postgresql.conf
to start archiving:
- First of all, you should turn
archive_mod
e on. - In the second step, you should configure your
archive_command
. Thearchive_command
is a simple shell, and it needs just two parameters to operate properly:%p
: This is a placeholder representing the XLOG file that should be archived, including its full path (source).%f
: This variable holds the name of XLOG without the path pointing ...
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.