On Wed, Jan 28, 2004 at 05:01:32PM +1100, Dean Grubb wrote:
> Hi,
>
> I have a debian server running postgresql 7.03 from the packages
> and also postgresql 7.1.3 from source. After doing an upgrade to some
> system files (ahrrrrrr...apt-get is good but I like freeBSD ports) I
> find that I no longer have the postgresql 7.03
> installation but a miss matched 7.2 part install.
I guess you ticked the option to attempt an auto-upgrade. I never trust those :)
> I still have the data folder from the database. Can anybody recommend a
> plan for recovery...Somehow reinsall 7.03 if I can find the .deb
> package?...is it possible to move the data/base files into another
> postgresql installation...can I import them?
Simplest seems to me would be to go to archives.debian.org and pull off the
7.0.2 debs and install those. Do a dump, and then upgrade and reimport.
While you're at it, go straight to 7.4.
Then, put the postgresql package on hold so it never tries that again.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce