Thread: Help, I've killed my system?

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 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?

thanks

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

Dean Grubb <dean@atrium-online.com.au> writes:
> 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 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?

You need to reinstall 7.0.something --- you cannot use that data folder
with any other PG release series.  I do not know the ins and outs of
Debian packaging well enough to recommend how to do that though ...

            regards, tom lane