From: | Will McCormick <wmccormick(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Complete Recovery 9.4.4 |
Date: | 2015-12-11 20:55:08 |
Message-ID: | CA+jgkY7CjEN0WWVk5XwpbL+HvyL2vKWTDeT-+L07K0Db0pABug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2015-12-11 21:15:50 | Re: Complete Recovery 9.4.4 |
Previous Message | Corradini, Carlos | 2015-12-11 20:11:50 | Re: [GENERAL] plpgsql function with RETURNS SETOF refcursor in JAVA |