Re: Cannot start Postgres- FATAL: invalid cache id: 19

Vick Khera <vivek(at)khera(dot)org> writes:
> On Wed, Dec 1, 2010 at 9:20 AM, Jolles, Peter M (GE Energy)
> <peter(dot)jolles(at)ge(dot)com> wrote:
>> 2010-11-29 12:39:17 EST HINT: Stop the postmaster and use a standalone
>> backend to vacuum that database.

> so did you do what the HINT told you to do? does it still not startup?

This is the second report we've seen of relatively new 9.0 installations
shutting down due to wraparound (the other was bug #5718). I find this
disturbing. If we're lucky, the cause is already fixed:
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b58c25055ef6d7097618c680f6768689a110d529
but if that's the only contributing factor then why weren't we seeing
similar reports about 8.3 and 8.4? I'm worried that there is some
other bug in 9.0 autovacuum. Has anyone stress-tested 9.0 to see if
autovacuum manages to keep the wraparound threshold moving forward?

regards, tom lane