Re: And to make things even better... - Mailing list pgsql-general

From Steve Wolfe
Subject Re: And to make things even better...
Date
Msg-id 002001bfaae8$58be8a00$85755ad1@iboats.com
Whole thread Raw
In response to Re: And to make things even better...  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List pgsql-general
> >  /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


pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: automatic crash recovery
Next
From: "Steve Wolfe"
Date:
Subject: One last thing... psql and readline