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.
>
>
>