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