On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes cbar...@recognia.com wrote:
Sorry if posting twice, wasn’t part of general when sent and didn’t see
it received by group.
I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes cbar...@recognia.com wrote:
Sorry if posting twice, wasn’t part of general when sent and didn’t see
it received by group.
I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC
I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC environment. Have I missed
something important?
Online
Backup
psql
checkpoint;
SELECT
pg_switch_xlog();
SELECT
On Thursday 25 June 2009, Chris Barnes compuguruchrisbar...@hotmail.com
wrote:
I started an online backup of postgres, tar’d my data folder, copy to
usb drive in production
and restored it into my RC environment. Have I missed
something important?
You need the transaction logs archived
Sorry if posting twice, wasn't part of general when sent and didn't see it
received by group.
I started an online backup of postgres, tar'd my data folder, copy to usb
drive in production
and restored it into my RC environment. Have I missed something important?
Online Backup
psql