Re: Postgres online backup and restore has errors that are concerning - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Postgres online backup and restore has errors that are concerning
Date
Msg-id 200906250751.09420@hal.medialogik.com
Whole thread Raw
In response to Postgres online backup and restore has errors that are concerning  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
List pgsql-general
On Thursday 25 June 2009, Chris Barnes <compuguruchrisbarnes@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 during and immediately after the
backup, and you need to setup a recovery.conf for the initial startup that
can access those files. See the PITR backup notes in the documentation,
they're really quite complete.

--
WARNING:  Do not look into laser with remaining eye.

pgsql-general by date:

Previous
From: "Hartman, Matthew"
Date:
Subject: Vacuum on the database versus individual tables.
Next
From: Clodoaldo Pinto Neto
Date:
Subject: Re: Fedora 11 where is plpython.so