Search Postgresql Archives

Re: ERROR: could not access status of transaction 2495690984

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 21 Jul 2009 15:32:07 -0400
Merlin Moncure <mmoncure@xxxxxxxxx> wrote:

> 2009/7/21 Bjørn T Johansen <btj@xxxxxxxxxx>:
> > 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux