Re: : PostgreSQL Online Backup
| От | Alan Hodgson |
|---|---|
| Тема | Re: : PostgreSQL Online Backup |
| Дата | |
| Msg-id | 201110041057.48406.ahodgson@simkin.ca обсуждение исходный текст |
| Ответ на | Re: : PostgreSQL Online Backup (Venkat Balaji <venkat.balaji@verse.in>) |
| Ответы |
Re: : PostgreSQL Online Backup
|
| Список | pgsql-general |
> > 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.
В списке pgsql-general по дате отправления: