Search Postgresql Archives

Re: : PostgreSQL Online Backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> > 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.

> 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).
> 

I'm going to need the rest of what I asked for to offer any further suggestions 
- especially the full and exact steps you took to initiate recovery and the 
contents of recovery.conf. Also, please don't top-post.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux