Help, I've killed my system?

[Dean Grubb]

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...Some how 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Martijn van Oosterhout]

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...Some how 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 <kl*****@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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFAF2jIY5T wig3Ge+YRAmSFAK DZa9GxHGpiz0uE9 12EDmO+2KhTjgCg gBym
RNNv/CA+bT5D3Od+EKwL XN4=
=Tfxl
-----END PGP SIGNATURE-----

[Tom Lane]

Dean Grubb <de**@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...Some how 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster