Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Vick Khera <vivek@xxxxxxxxx> writes:
> On Wed, Dec 1, 2010 at 9:20 AM, Jolles, Peter M (GE Energy)
> <peter.jolles@xxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux