Re: : PostgreSQL Online Backup

The recovery is unable to find the WAL archive because, it was generated on
26th September.

Whereas the backup is as taken on Oct 2nd, 2011. We deleted all the files.

I do not have that WAL archive copy.

The problem area -

I found that a pg_clog file dated 26th Sep, 2011 is not synced (its not
256K).

Thanks
VB

2011/10/3 Alan Hodgson <ahodgson(at)simkin(dot)ca>

> 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.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>