Basic backup and recovery question. I want to perform complete restore and recovery using continuous archive mode.
Lets imagine we have a single table MYTABLE. Here are my high level steps
1) Add a record A) to MYTABLE
2) Take a file system backup to be used for recovery. This backup includes archive logs
3) Add a record B) to MYTABLE
Timeline -> incident happens need backup
4) Stop PG
5) Make copy of current state including PGDATA w/ pg_xlog and WAL archives
6) Cleanup PGDATA /wpg_xlog and WAL archive directory
7) Restore backup taken in step 2, placing contents in PGDATA /w pg_xlog and archives
8) Remove contents of pg_xlog
9) Copy contents of pg_xlog in step 5 to PGDATA/pg_xlog
10) Create recovery.conf file with cp /database/postgres/product/9.4.4/archive/%f %p
11) Startup the server
What I see happen is 1) restores but my change in step 3) is not.
Can anyone explain why this is?