Re: Please HELP - URGENT - transaction wraparound error

Hmm. I'm pretty sure that database mail_lxtreme was unused (no
connections/activity) - I didn't think that it would need to be vacuumed
at all...

Just out of curiousity would the wraparound error (for mail_lxtreme)
actually have affected data in bp_live?

Could I just have deleted mail_lxtreme and then continued to use bp_live
as though nothing had happened?

Or had database bp_live already been damaged by the wraparound?

Thanks for your great help/advice - it's much appreciated.

John

Tom Lane wrote:
> John Sidney-Woollett <johnsw(at)wardbrook(dot)com> writes:
>
>>OK, I restored the pgsql/data to another server and started up postgres
>>and this is what I got:
>
>
>> SELECT datname, age(datfrozenxid) FROM pg_database;
>> datname | age
>>--------------+-------------
>> mail_lxtreme | -2074187459
>> bp_live | 1079895636
>> template1 | 1076578064
>> template0 | -2074187459
>>(4 rows)
>
>
>>mail_lxtreme is a test mail db and I don't care about it. So it could
>>have been deleted without any worries...
>
>
>>Which databases are a problem? Is it template0 or bp_live and template1?
>
>
> mail_lxtreme is exactly the problem. You weren't vacuuming it...
>
> (template0 is a special case and can be ignored.)
>
> regards, tom lane