Re: RE : PostgreSQL coredump : Couldn't find any tables, - Mailing list pgsql-general

From Tom Lane
Subject Re: RE : PostgreSQL coredump : Couldn't find any tables,
Date
Msg-id 10368.1055337540@sss.pgh.pa.us
Whole thread Raw
In response to RE : PostgreSQL coredump : Couldn't find any tables,  ("Bruno BAGUETTE" <pgsql-ml@baguette.net>)
List pgsql-general
"Bruno BAGUETTE" <pgsql-ml@baguette.net> writes:
> I would like to upgrade to 7.3.3 but I have first to get 6.5.2 running
> in order to get the possibility to start a dump and to launch the
> install into a PostgreSQL 7.3.3 server.

How large is pg_log?  If it's 1Gb in size or nearly that, then your
problem is that the transaction counter wrapped around.  I believe that
a couple of people have gotten out of such a fix by resetting the
counter to a few hundred transactions less than 4G, giving them time to
pg_dump before it wraps again.  I don't remember how to do it in such a
prehistoric version of Postgres, though.  Check the archives.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: version 7.3.3 re-configure endlessly in AIX 4.3.3
Next
From: Tom Lane
Date:
Subject: Re: doing VALID UNTIL programmatically in SQL ?