Re: Troubling On-line Backup LOG messages

On Mar 21, 2006, at 11:54 AM, Tom Lane wrote:

> "Thomas F. O'Connell" <tfo@sitening.com> writes:
>> 2006-03-21 10:38:53 CST 1412 :LOG:  archive recovery complete
>> 2006-03-21 10:38:53 CST 1412 :LOG:  could not truncate directory
>> "pg_multixact/offsets": apparent wraparound
>> 2006-03-21 10:38:53 CST 1412 :LOG:  could not truncate directory
>> "pg_multixact/members": apparent wraparound
>
> What file name(s) appear in those directories?  Do you continue to get
> the same log messages during subsequent checkpoints?

pg_multixact/offsets/0001
pg_multixact/members/0002

Thus far, there haven't been any subsequent checkpoints. These
occurred immediately after recovery of an on-line backup, and I
haven't really done much with the new cluster because it just exists
for proof of concept.

--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)