Testing transaction log archiving

Before we dig into the actual replay process, it makes sense to actually check archiving to make sure it is working perfectly and as expected:

[hs@zenbook archive]$ ls -l total 212996 -rw------- 1 hs hs 16777216 Jan 30 09:04 000000010000000000000001 -rw------- 1 hs hs 16777216 Jan 30 09:04 000000010000000000000002 -rw------- 1 hs hs 302 Jan 30 09:04 000000010000000000000002.00000028.backup -rw------- 1 hs hs 16777216 Jan 30 09:20 000000010000000000000003 -rw------- 1 hs hs 16777216 Jan 30 09:20 000000010000000000000004 -rw------- 1 hs hs 16777216 Jan 30 09:20 000000010000000000000005 -rw------- 1 hs hs 16777216 Jan 30 09:20 000000010000000000000006 ... 

As soon as there is serious activity in the database, ...

Get Mastering PostgreSQL 10 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.