<= /div>

Using = the -x will get you to ONE POINT IN TIME. So if you backed up at 9PM you ca= n restore back to that point and that point ONLY. Some people call this poi= nt in time, but its only ONE point in time.

If you are archiving the wal fil= es then you can restore to ANY POINT IN TIME. See the difference, its a big= deal:) So if you backed up at 9PM and you need your database back to the s= tate at 10am, no problem! Restore your 9PM and all the wal files until 10am= . This is ANY POINT IN TIME. I feel the term "point in time=E2=80=9D has go= tten diluted and now there is two different =E2=80=9Cpoint in time;=E2=80= =9D one or any and that a huge difference.

In all honestly it sounds= to me you want ANY POINT IN TIME. So forget about the =E2=80=9C-x=E2=80=9D= and just archive your wal files and its all good. Just make sure you have = the base backup + all wal files until the point in time you want. So in ord= er to keep three days of base backups you need at least three days of wal f= iles as well.

Make sense?

On Septem= ber 23, 2014 at 9:18:37 AM, Campbell, Lance (lance@illinois.edu) wrote:

PostgreSQL 9.3

Would someone be able to clarify if one should use the =E2=80=93X option with pg_basebackup when your intention is to include all WAL files created? There are two scenarios. The first scenario listed below makes sense using the =E2=80=93X option. Bus scenario #2 has me a little confused. I don=E2=80=99t want to cause any issues when restoring.

1) Use pg_basebackup for a fully standalone restorable snapshot of the database using the =E2=80=93X parameter. When a failure occurs you restore the database to that exact point in time.

2) You restore from a pg_basebackup and you also apply all of the WAL files since the last pg_basebackup. Do you want to use the =E2=80=93X option when doing the pg_basebackup if your intention is to have all of the WAL files since you backed up last? Or does it matter. Would PostgreSQL just ignore the duplicate WAL files that were created by the =E2=80=93X option during the pg_basebackup?

Thanks for your clarification. This is a hard scenario to test.

Thanks,

Lance C= ampbell

Software Architect

Web Services at Public Affairs

217-333-0382

This transmission contains confidential = and privileged information intended solely for the party identified above. If you receive = this message in error, you must not use it or convey it to others. Please destroy it immediately and contact the se= nder at (303) 386-3955 or by return e-mail to the sender.

--54219a5f_79e2a9e3_14be7-- --54219a5f_41b71efb_14be7 Content-Type: application/octet-stream Content-Transfer-Encoding: base64 Content-ID: <04AB5E8A-1A03-48F1-868C-C93952DEA3D8> Content-Disposition: inline; filename="=?utf-8?Q?image001.png=4001CFD717.8CC62810?=" iVBORw0KGgoAAAANSUhEUgAAAJYAAAAZCAYAAADT59fvAAAFkElEQVRoge2aQWjbVhjH/xop85hD lMuQ2WEKdcG7rNKtYQmxTovZITIkdIVCLXoqZLi+ubQQB1aWm2Ma6KmVC4WsJBCH0dmnWiEt6Wl+ vQXqEfUUMQZVmQZqN3g7ODJ2otSSY3uk0w9MYiN9+kv663t63/eYhftP6GJRQy9YSMWRUySmJ8EC TjVDAPBV2MTlyB7e/HOmqyAjQ3/j4f5YT4UFnG6GAGDkzDv8/Mfn2H79WVdBJkd/x8iZdz0VFnC6 +ei/FhDwYTLk9mNc4JGeG8eLutH8bUrg27aR0mpfhQWcblyNtaBI4DkWpmWD51gADbMBgGnZKD3d HZjAgNOJq7G2iA5+WsBWbQ+vIqMYCYeaxpLSKkhLJgsIcMP1HSunVjF2MY9ihWBK4PHGsgEAGtED UwV4wtfLu26Y/dIR8IHhy1ivAmMFeCQoNwT0hcBYAX3BdVbYazIrFUpe7gMA2OEQ0rPjiAv8e3uK umHSxaIGff91c7/8fAI8x/rqRRbLNfqgQprfZyZiuD437itGt1pK27u0sL4DoFEHdOujKksl6sTl I6NQs7InbaZl0+W1HTyokGZJiNQN8ByL9OwFpBKi53PUiE4X1Wrzu3Augvz8tGcdytIG9H0TbDgE jehIJcTBGCs/P81IaZVqRMfeo4wnc/Acy6hZGeLVu5TUDbx+fANsOOS7wZ1KiAwb/oQmb63i+ty4 b1OdRIs8GWP4CEvFq3ehER1xcYwefqDUrMwkb61S538vekzLplJaBR9hUbt3ranFtGyaWalAWSph 68Ur6jVeXOAZKBKV0iquz417NhUAJG+ugh0OoXbvGgMApG5Q8erdwQ2FTuXeb8ZhwyHnb9erJtjh RoyRTz/uNkTXWoQoxzj7Jm+ugtQNenib82c5nD/LedYhpVWYlg01m2zTwoZDjJqVGXkyhmK5hpxa PXKsTvi5RrphUo3ouPKN2PxNiHKMmpX9GWvk4MIG+EfNJmFaNpQfN2Batu8b7lAs1yipG0jPXjjW 4Pn5BACgsP6828P4whnuHVIJkfFlLCHq/akKaEeejDFqVgapG07G6cpcm88a7TThXOTYbXiOZYQo B9OyoRG9axN3gudYJi7w0IgOKa1S3TCbxwqMNUBSCZFJJUSQugFlaaOrGOafjS5Ip3vBDmh02bh9 CUKUg0Z0jF3MN4ffY40lT8SQUyTohokvDmYdbDiEnCINRPCHipqVmVRCRGl7F8pSqets0qm1dng1 Sr9gwyGmdu8as5CKAwAWixoyKxXqaix5IoaZyS8xJfDgObY5nQUay4/3HmWC7HUC8vPTEKJcVy/Y zkTEKVEcxxbRG9sPKHPlFIk5mKFieW3HPWNNiWNtZgIaDWjnE/QMTwYbDjHVggIhymGxqGHTxzKk ma9jAIDW2pwbTk3LmZX2g9L2bttDIUS5ZuZyrWNl7pR7LuLNX297Gk8jOi2s72Djh0snunBSWqX5 7xN9vQFAY2reWmphwyFGvZGkzjKkmYmYpziphMgU1p9TjegolmvUrRCaU6vUtGxs3L7UwzM4SmF9 B+xwqK02x3OjAAbU0jEtm2q1PQBwreO8bz8nOy6v7VCN6M1P5k4ZU+d5T3Gcqv/m0120xlhe26Gk bngyVauW1tlPx2MfnK9z/q0IUY6pFhTfw5WT7ZSlkmMi6mjMqVVaWH8ONSt37G604gytL37zvixq SuDbanOmZdPFYhXyZAzMwv0ntPjTY1yOHD1xPzzcH0Pqu29d2xZSWm27EVemhY4tB1I3aKfMqd5I diy4traT3Diu1dJJi5csd3i/41olxXKNmpbtuytQLNfo5rNdkJcGTMuGEOUgnIsgPXvBVyH6cNsL AKoFxdPDllmpgLzch26Y4DnWaZmBUX/59UjQbvFimID/B/8CO2CIAn28iA0AAAAASUVORK5CYII= --54219a5f_41b71efb_14be7--