On Tue, 21 Jul 2009 15:32:07 -0400 Merlin Moncure <mmonc...@gmail.com> wrote:
> 2009/7/21 Bjørn T Johansen <b...@havleik.no>: > > I have had som problem with my filesystem and now I get these error > > messsages when trying to access my database..: > > > > ERROR: could not access status of transaction 2495690984 > > Could not open file "pg_clog/094C": No such file or directory. > > got backups? > > One way to suppress this error, but not fix the underlying corruption, > is to generate clog files that the database thinks should be there. > Make a 256k file filled with 0x55 and put it where the database is > expecting. > > merlin > Yes, I have backups... Was just kind of hoping for another solution.... :) BTJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general