Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-16-2007, 04:59 PM   #1
Registered: Sep 2006
Location: Sydney Australia
Distribution: fedora/Ubuntu
Posts: 100

Rep: Reputation: 16
Postgress Database upgrade renders data unreadable

During one of the updates of Fedora, Postgres was upgraded. After not having used my Postgres datbases for some time I recently found that the data had at some stage become incompatible with one of the versions of Postgres.

The not so helpful advice is; to re-install an old version of Postgres do a database backup, upgrade Postgres and then reinstall the data. Even if this were not problematical it is time consuming.

Have these people ever experienced rpm hell? If you try to return to an old rpm, a long list of applications dependent on the newer rpm also have to be removed. Applications that I would rather remain on the computer. This is really annoying.

Does anyone know a way to convert the old Postgres database to the new format without ripping my poor computer's software to pieces.

This would be most helpful to many people I am sure.

Last edited by keirvt; 11-16-2007 at 05:04 PM.
Old 11-18-2007, 03:06 AM   #2
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,047
Blog Entries: 11

Rep: Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908
Sorry, there's no other way. Well, you can avoid RPM hell by
NOT trying to install the old version from the RPM but rather
using the source tar-ball. If the version discrepancy isn't all
too dramatic it should compile fine within the more recent environment.

And don't complain about "these people" (I assume you're talking
about the good folk from postgreSQL?). Their upgrade guides are
quite clear - if the package maintainers for fedora choose to ignore
their pretty clear warnings and do a drop-in replacement of the
binary they should be tarred and feathered ...



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Processing data from a 'foreign' database with mysql, or tools to pre-process data. linker3000 Linux - Software 1 08-14-2007 09:36 PM
Cedega renders fonts improper; but wine renders fonts fine. (Screenshots) jon_k Linux - Software 1 01-01-2006 02:25 AM
Postgress: pgaccess - failed to create database FoxleighFlyer Linux - Newbie 11 12-22-2005 03:16 PM
Postgress TCP/IP connection at Startup dhruiz Linux - Newbie 5 10-29-2004 10:09 AM
pulling data from mysql database zuessh Linux - Software 5 05-29-2003 10:13 AM

All times are GMT -5. The time now is 03:05 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration