Re: And to make things even better...

> > /var/lib/pgsql reports that we're running 6.3 - which I don't find on
the
> >FTP site. Is that not a valid distribution number, or is the source not
> >available?
>
> Maybe the new guy did a make and linked the ancient 6.3 stuff in to Perl.
>
> I suspect that you were in fact running 6.5.3. But now some stuff is
going
> to 6.3.

Nope, it was bona-fide 6.3. : )

> Check your postgres data directory, I believe you can find the version
> number there.

That's where I found that. : )

> Once you have confirmed the version you are really using, you can use the
> correct binaries to back up/dump your data. Please check the docs on what
> actually is dumped - certain things may not be dumped correctly depending
> on which version you are using.

Part of the problem that I ran into was that the old guy had copied most
of the binaries from ~postgres/bin to other directories to get them in the
path. So, even after I wiped out the 6.3 directory and compiled 6.5.3,
when I'd do "initdb", it would create a 6.3 database structure, and make
everything barf. Fun, no?

steve