Tai Tran

Unzip base back up file and touch recovery.conf file

Point to wal files folder that archived, pg_wal_backup in my case

restore_command = 'cp /var/lib/postgresql/data/pg_wal_backup/%f %p'

Then reload the system

    time=2020-09-23 06:38:31 UTC; pid=1; LOG:  listening on IPv4 address "0.0.0.0", port 5432
    time=2020-09-23 06:38:31 UTC; pid=1; LOG:  listening on IPv6 address "::", port 5432
    time=2020-09-23 06:38:31 UTC; pid=1; LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    time=2020-09-23 06:38:32 UTC; pid=78; LOG:  database system was interrupted; last known up at 2020-09-21 05:54:28 UTC
    time=2020-09-23 06:38:32 UTC; pid=78; LOG:  creating missing WAL directory "pg_wal/archive_status"
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  starting archive recovery
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  database system was not properly shut down; automatic recovery in progress
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  redo starts at 29/91C5C78
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  invalid record length at 29/91CEEA8: wanted 24, got 0
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  consistent recovery state reached at 29/91CEEA8
    time=2020-09-23 06:38:33 UTC; pid=1; LOG:  database system is ready to accept read only connections
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  restored log file "000000010000002900000009" from archive
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  restored log file "00000001000000290000000A" from archive
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  restored log file "00000001000000290000000B" from archive
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  restored log file "00000001000000290000000C" from archive
    time=2020-09-23 06:38:33 UTC; pid=78; LOG:  restored log file "00000001000000290000000D" from archive
    time=2020-09-23 06:38:34 UTC; pid=78; LOG:  restored log file "00000001000000290000000E" from archive
    time=2020-09-23 06:38:34 UTC; pid=78; LOG:  restored log file "00000001000000290000000F" from archive
    time=2020-09-23 06:38:34 UTC; pid=78; LOG:  restored log file "000000010000002900000010" from archive
    time=2020-09-23 06:38:34 UTC; pid=78; LOG:  restored log file "000000010000002900000011" from archive
    time=2020-09-23 06:38:35 UTC; pid=78; LOG:  restored log file "000000010000002900000012" from archive
    time=2020-09-23 06:38:35 UTC; pid=78; LOG:  restored log file "000000010000002900000013" from archive
    time=2020-09-23 06:38:35 UTC; pid=78; LOG:  restored log file "000000010000002900000014" from archive
    time=2020-09-23 06:38:36 UTC; pid=78; LOG:  restored log file "000000010000002900000015" from archive
    time=2020-09-23 06:38:36 UTC; pid=78; LOG:  restored log file "000000010000002900000016" from archive
    time=2020-09-23 06:38:36 UTC; pid=78; LOG:  restored log file "000000010000002900000017" from archive
    time=2020-09-23 06:38:36 UTC; pid=78; LOG:  restored log file "000000010000002900000018" from archive
    time=2020-09-23 06:38:36 UTC; pid=78; LOG:  restored log file "000000010000002900000019" from archive
    time=2020-09-23 06:38:37 UTC; pid=78; LOG:  restored log file "00000001000000290000001A" from archive
    time=2020-09-23 06:38:37 UTC; pid=78; LOG:  restored log file "00000001000000290000001B" from archive
    time=2020-09-23 06:38:37 UTC; pid=78; LOG:  restored log file "00000001000000290000001C" from archive
    time=2020-09-23 06:38:38 UTC; pid=78; LOG:  restored log file "00000001000000290000001D" from archive
    time=2020-09-23 06:38:38 UTC; pid=78; LOG:  restored log file "00000001000000290000001E" from archive
    time=2020-09-23 06:38:38 UTC; pid=78; LOG:  restored log file "00000001000000290000001F" from archive
    time=2020-09-23 06:38:39 UTC; pid=78; LOG:  restored log file "000000010000002900000020" from archive
    time=2020-09-23 06:38:39 UTC; pid=78; LOG:  restored log file "000000010000002900000021" from archive
    time=2020-09-23 06:38:39 UTC; pid=78; LOG:  restored log file "000000010000002900000022" from archive
    time=2020-09-23 06:38:40 UTC; pid=78; LOG:  restored log file "000000010000002900000023" from archive
    time=2020-09-23 06:38:40 UTC; pid=78; LOG:  restored log file "000000010000002900000024" from archive
    time=2020-09-23 06:38:41 UTC; pid=78; LOG:  restored log file "000000010000002900000025" from archive
    time=2020-09-23 06:38:42 UTC; pid=78; LOG:  restored log file "000000010000002900000026" from archive

time=2020-09-23 06:38:31 UTC; pid=1; LOG: listening on IPv4 address "0.0.0.0", port 5432 time=2020-09-23 06:38:31 UTC; pid=1; LOG: listening on IPv6 address "::", port 5432 time=2020-09-23 06:38:31 UTC; pid=1; LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" time=2020-09-23 06:38:32 UTC; pid=78; LOG: database system was interrupted; last known up at 2020-09-21 05:54:28 UTC time=2020-09-23 06:38:32 UTC; pid=78; LOG: creating missing WAL directory "pg_wal/archive_status" time=2020-09-23 06:38:33 UTC; pid=78; LOG: starting archive recovery time=2020-09-23 06:38:33 UTC; pid=78; LOG: database system was not properly shut down; automatic recovery in progress time=2020-09-23 06:38:33 UTC; pid=78; LOG: redo starts at 29/91C5C78 time=2020-09-23 06:38:33 UTC; pid=78; LOG: invalid record length at 29/91CEEA8: wanted 24, got 0 time=2020-09-23 06:38:33 UTC; pid=78; LOG: consistent recovery state reached at 29/91CEEA8 time=2020-09-23 06:38:33 UTC; pid=1; LOG: database system is ready to accept read only connections time=2020-09-23 06:38:33 UTC; pid=78; LOG: restored log file "000000010000002900000009" from archive time=2020-09-23 06:38:33 UTC; pid=78; LOG: restored log file "00000001000000290000000A" from archive time=2020-09-23 06:38:33 UTC; pid=78; LOG: restored log file "00000001000000290000000B" from archive time=2020-09-23 06:38:33 UTC; pid=78; LOG: restored log file "00000001000000290000000C" from archive time=2020-09-23 06:38:33 UTC; pid=78; LOG: restored log file "00000001000000290000000D" from archive time=2020-09-23 06:38:34 UTC; pid=78; LOG: restored log file "00000001000000290000000E" from archive time=2020-09-23 06:38:34 UTC; pid=78; LOG: restored log file "00000001000000290000000F" from archive time=2020-09-23 06:38:34 UTC; pid=78; LOG: restored log file "000000010000002900000010" from archive time=2020-09-23 06:38:34 UTC; pid=78; LOG: restored log file "000000010000002900000011" from archive time=2020-09-23 06:38:35 UTC; pid=78; LOG: restored log file "000000010000002900000012" from archive time=2020-09-23 06:38:35 UTC; pid=78; LOG: restored log file "000000010000002900000013" from archive time=2020-09-23 06:38:35 UTC; pid=78; LOG: restored log file "000000010000002900000014" from archive time=2020-09-23 06:38:36 UTC; pid=78; LOG: restored log file "000000010000002900000015" from archive time=2020-09-23 06:38:36 UTC; pid=78; LOG: restored log file "000000010000002900000016" from archive time=2020-09-23 06:38:36 UTC; pid=78; LOG: restored log file "000000010000002900000017" from archive time=2020-09-23 06:38:36 UTC; pid=78; LOG: restored log file "000000010000002900000018" from archive time=2020-09-23 06:38:36 UTC; pid=78; LOG: restored log file "000000010000002900000019" from archive time=2020-09-23 06:38:37 UTC; pid=78; LOG: restored log file "00000001000000290000001A" from archive time=2020-09-23 06:38:37 UTC; pid=78; LOG: restored log file "00000001000000290000001B" from archive time=2020-09-23 06:38:37 UTC; pid=78; LOG: restored log file "00000001000000290000001C" from archive time=2020-09-23 06:38:38 UTC; pid=78; LOG: restored log file "00000001000000290000001D" from archive time=2020-09-23 06:38:38 UTC; pid=78; LOG: restored log file "00000001000000290000001E" from archive time=2020-09-23 06:38:38 UTC; pid=78; LOG: restored log file "00000001000000290000001F" from archive time=2020-09-23 06:38:39 UTC; pid=78; LOG: restored log file "000000010000002900000020" from archive time=2020-09-23 06:38:39 UTC; pid=78; LOG: restored log file "000000010000002900000021" from archive time=2020-09-23 06:38:39 UTC; pid=78; LOG: restored log file "000000010000002900000022" from archive time=2020-09-23 06:38:40 UTC; pid=78; LOG: restored log file "000000010000002900000023" from archive time=2020-09-23 06:38:40 UTC; pid=78; LOG: restored log file "000000010000002900000024" from archive time=2020-09-23 06:38:41 UTC; pid=78; LOG: restored log file "000000010000002900000025" from archive time=2020-09-23 06:38:42 UTC; pid=78; LOG: restored log file "000000010000002900000026" from archive

Serverless Blog

WAL Archiving and Point-in-Time Recovery

WAL Archiving and Point-in-Time Recovery