From: Bernhard Schrader <bernhard.schrader@innogames.de>
To: pgsql-admin@postgresql.org
Subject: Missing clogs and pg_upgrade. What to do without any clog backup?
Date: Thu, 16 Jun 2011 14:21:44 +0200
Message-ID: <1308226904.2334.15.camel@schrader-laptop> (raw)
Hi out there,
i migrated some month ago our databases from 8.4 to 9.0 and now getting
errors like:
2011-06-12 06:25:33 CEST ERROR: could not access status of transaction
59768467
2011-06-12 06:25:33 CEST DETAIL: Could not open file "pg_clog/0038": No
such file or directory.
2011-06-12 06:25:33 CEST CONTEXT: automatic vacuum of table
"database.pg_toast.pg_toast_19029"
Well, I googled so far and also saw that there are other known issues
and also a fix script. But in all cases a backup of the clogs would have
been necessary. I don't have these files. Is there any way to fix my
servers?
I have migrated around 200 servers, until now 40 servers have the clog
issues. i will run the script on all other machines. But for the 40
servers i need a solution.
Would a normal dump & restore fix the issues? This would be the worst
way i could imagine but if there is no way around i will have to do it.
thanks in advance
regards
Bernhard Schrader
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bernhard.schrader@innogames.de
Subject: Re: Missing clogs and pg_upgrade. What to do without any clog backup?
In-Reply-To: <1308226904.2334.15.camel@schrader-laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox