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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
