By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

pg_clog / pg_xlog corruption?

P: n/a
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
ad**@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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
ad**@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 <kl*****@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


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/lei/Y5Twig3Ge+YRAgD/AKDBi7WsFUL3MiyeptvqW2B09e66QgCfanB7
4t6sRp1EdygSieJ0B3nOvyA=
=32eB
-----END PGP SIGNATURE-----

Nov 12 '05 #2

P: n/a
Adam Haberlach <ad**@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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.