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
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 |