Обсуждение: pg_clog / pg_xlog corruption?

    We had one of our databases suddenly try to reference a pg_clog
file that didn't exist whenever we attempted to select from a certain
table.  Anyone know of a way to recover from this?  Is there a way to
reset the transaction logs and just use whatever data is actually
stored in the system?

--
Adam Haberlach         |  "We spent the 90's all trying to figure out
adam@mediariffic.com   |  how to get email and the 00's trying to
http://mediariffic.com |  figure out how to not get email."
                       |             -- Joe Gross

You can create the missing clog file as a file 256K big full of zeros. Then
dump, initdb and restore.

And upgrade the db to the latest minor version.

On Tue, Oct 21, 2003 at 04:49:26PM -0700, Adam Haberlach wrote:
>     We had one of our databases suddenly try to reference a pg_clog
> file that didn't exist whenever we attempted to select from a certain
> table.  Anyone know of a way to recover from this?  Is there a way to
> reset the transaction logs and just use whatever data is actually
> stored in the system?
>
> --
> Adam Haberlach         |  "We spent the 90's all trying to figure out
> adam@mediariffic.com   |  how to get email and the 00's trying to
> http://mediariffic.com |  figure out how to not get email."
>                        |             -- Joe Gross
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

Adam Haberlach <adam@newsnipple.com> writes:
>     We had one of our databases suddenly try to reference a pg_clog
> file that didn't exist whenever we attempted to select from a certain
> table.  Anyone know of a way to recover from this?

You need to provide more details.  For one, exactly which PG version
are you using?  And is the complained-of clog file newer or later than
the range of files actually present in $PGDATA/pg_clog?

            regards, tom lane