Re: Old problem needs solution

Ok, well it looks like Richard owes Tom a lunch, or that's my best guess
anyway.  I am running Gentoo, as far as that particular patch, I'm
unsure, but if it's installed by default then yes.  So, I've pulled down
the earliest ebuild I can get which is 7.3.6.  Get it installed and go
to start it:

FATAL:  The data directory was initialized by PostgreSQL version 7.4,
which is not compatible with this version 7.3.6.

So, the plot thickens.  Is there somewhere I can go tweak a few bytes to
make it think it's 7.3?  Also, is 7.3 going to be early enough?  This
database has been around for years, and like I said, I'm not sure when
this happened : /

Truly appreciate the help guys!

g



Alvaro Herrera wrote:

>On Wed, Jun 01, 2005 at 10:24:25AM -0500, Gerald D. Anderson wrote:
>
>
>>Greetings!
>>
>>At some point, I'm not even sure when, I apparently had a bad upgrade on
>>one of my production databases.  I'm in a situation now where I've got
>>my back up against a wall and not sure what to do.  The problem is, I'm
>>receiving this message frequently:
>>
>>did not find '}' at end of input node
>>
>>
>
>Are you using Gentoo?  Are you using the hierarchical queries patch?
>Were you using any of the above in the previous Postgres version?
>
>If this is the case, you will have to get the old postmaster again, and
>run it against your data directory, and use that to make the dump.  The
>reload it in the new directory.
>
>The problem with the hierarchical queries patch (which Gentoo applies to
>some of their builds) is that it doesn't include the necessary
>catalog-version increment.  So people can use the same data directory
>with or without the patch applied, which is a mistake because it causes
>the errors you are seeing.
>
>
>