Re: : PostgreSQL Online Backup

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: : PostgreSQL Online Backup
Date: 2011-10-03 17:09:20
Message-ID: 201110031009.20670.ahodgson@simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On October 3, 2011 05:33:35 AM Venkat Balaji wrote:
> Did anyone observe this behavior ?? Please help !
>
> This is critical for us. I want to recommend not to use "rsync" (use cp or
> scp instead) for production backup.
>

rsync works fine. Why exactly can't the recovery find the backed up copy of
000000010000053900000076? Please post your archive_command settings, the
contents of any script(s) called by that, and the recovery.conf file you're
using that's having problems, as well as the complete process you followed to
initiate recovery. I strongly suspect you're missing part of the process of
actually saving the WAL files needed for recovery.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-10-03 17:17:07 Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?
Previous Message Francisco Figueiredo Jr. 2011-10-03 16:52:22 Re: Why PGSQL has no developments in the .NET area?