| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Erik Jones <erik(at)myemma(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: WARNINGs after starting backup server created with PITR |
| Date: | 2008-01-20 09:16:33 |
| Message-ID: | 1200820593.4255.469.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 2008-01-19 at 13:53 -0600, Erik Jones wrote:
> > Is the History table Insert only? We might use that fact to examine
> > the
> > LSNs of the equivalent blocks on the Primary. If the LSNs are prior to
> > the start of the recovery, as noted in the backup label file of the
> > original base backup, then we can confirm rsync or postgres as the
> > cause. Do you still have the base backup label file or base backup?
>
> I still have the backup label but not the base backup. The history
> tables are about 90-95% insert only, on average, but they do see the
> occasional update if a message's delivery status is a bounce. If you
> think this would still be an option, I'd be happy to follow whatever
> instructions, or supply any files, needed.
OK. Off-list, please post me the backup label file and 2-3 compressed
WAL files covering the period where recovery started.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-01-20 09:19:46 | Re: WARNINGs after starting backup server created with PITR |
| Previous Message | Jon Hancock | 2008-01-20 08:21:01 | SHA1 on postgres 8.3 |