Darren Greer wrote:
>
> Somehow, our version of postgres got upgraded during some system
> maintenance. To make a long story short we had to completely re-install
> Posgres (6.3-15). Now I have originaly data directory backed up, but have
> found no way to import the data. I tried simply replacing the new data
> directory with the old, with no luck.
More detail is needed -- operating system, architecture, distribution
(if linux). By saying 6.3-15, this indicates the possibility of a
package-oriented distro -- Debian, RedHat, Caldera, and Mandrake all
have the release numbers (as well as any RPM-based distro, of which
there are many.).
If RedHat, and you upgraded your operating system, POSTGRESQL GETS
UPGRADED AUTOMATICALLY -- WHICH IS A _BAD_ THING.... Which is why I'm
working on support in the RPM's for seamless rpm -Uvh -- I have been
bitten by this more than once. It is possible to go back -- simply
(HAH!) downgrade that package with the one from the older distro -- if
an RPM-based distro, you will need to give the '--oldpackage' directive
to the rpm -U command for the postgresql rpms. Again, I have had to do
this -- and it stinks! Which is why I am working on making the seamless
upgrade, that RedHat wants, happen without causing the data loss that
you are experiencing.
>From my understanding, Debian handles this very gracefully (the upgrade
scripts are EXTENSIVE!), so, this is not likely to be Debian.
More details will help -- what kind of operating sys maintenance was
done, from what version of what distro was the upgrade, to what version,
etc. The more details, the more likely you will be to get useful help.
HTH.
Lamar Owen
WGCR Internet Radio
