Mastering PostgreSQL 12 - Third Edition

Testing transaction log archiving

Before we dive into the actual replay process, it makes sense to actually check archiving to make sure that it is working perfectly and as expected by using a simple ls command, as shown in the following code:

[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 ...