Cannot start Postgres- FATAL: invalid cache id: 19

From: "Jolles, Peter M (GE Energy)" <peter(dot)jolles(at)ge(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Cannot start Postgres- FATAL: invalid cache id: 19
Date: 2010-12-01 14:20:34
Message-ID: E66B1BA008C7374390C6AE9EF01E584A03B5C853@ALPMLVEM08.e2k.ad.ge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am having problems starting up Postgres and am getting the following
error:

2010-12-01 08:36:42 EST LOG: database system was shut down at
2010-11-29 17:38:17 EST
2010-12-01 08:36:42 EST FATAL: invalid cache id: 19
2010-12-01 08:36:43 EST FATAL: the database system is starting up
2010-12-01 08:36:43 EST LOG: startup process (PID 640) exited with exit
code 1
2010-12-01 08:36:43 EST LOG: aborting startup due to startup process
failure

Prior to shutting down the database, the log file reported the following
message:

2010-11-29 12:39:17 EST ERROR: database is not accepting commands to
avoid wraparound data loss in database "fps_data"
2010-11-29 12:39:17 EST HINT: Stop the postmaster and use a standalone
backend to vacuum that database.

I had multiple auto-vacuum instances running, but it looks like they
were unable to keep up.

I found some reference to bug # 5718
(http://archives.postgresql.org/pgsql-bugs/2010-10/msg00185.php) that
lists a patch, but I am unfamiliar with how to apply the referenced
patch, or if it will help. I am running Postgres 9.0.0-1 on Windows XP
courtesy of Enterprise DB. Hardware is 64bit, but I am running the 32bit
version.

Is this patch likely to help with startup? How does one apply it via
windows, or could I just install Version 9.0.1-1 and get the same
result?

Thanks,
Peter Jolles

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-12-01 14:55:04 Re: Does Postgres support bookmarks (tuples ids)?
Previous Message Martin Gainty 2010-12-01 14:19:09 Re: A question about timezone