Help, I've killed my system?

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/

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