Re: [GENERAL] Postgres online backup and restore

2009-06-30 Thread Scott Mead
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes 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 environment. H

Re: [GENERAL] Postgres online backup and restore

2009-06-30 Thread Scott Mead
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes 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 environment. H

Re: [GENERAL] Postgres online backup and restore has errors that are concerning

2009-06-25 Thread Alan Hodgson
On Thursday 25 June 2009, Chris Barnes 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 during and immediately after t