Solved

upgrade postgresql 8.4 to 9.1 in fedora 14 64 bits

Posted on 2014-04-19
7
629 Views
Last Modified: 2014-05-03
Most of the sql is not running in PostgreSQL 8.4 so that's why i need to upgrade PostgreSQL 9.1
Running OS Fedora 14 (64 bits)
0
Comment
Question by:itaakashcom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 40010227
You're 6 versions down on an OS that's meant to be constantly updated (the current one is Fedora 20). Fedora is the distro that tests the latest and greatest packages so they can be incorporated into RedHat.

If Postgresql 9 is not available with
yum list postgresql
then I suggest you upgrade to the latest version of Fedora.

Or, if you don't like constantly upgrading, switch to a more stable distro.
If you're used to RedHat, switch to CentOS.

HTH,
Dan
0
 

Author Comment

by:itaakashcom
ID: 40010249
but i don't want to change my operating system
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 40010266
According to this, you need to be at least on Fedora 18: http://www.postgresql.org/download/linux/redhat/

So if you don't want to change your OS, upgrade it to a more modern version.
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 35

Expert Comment

by:Seth Simmons
ID: 40010267
fedora 14 isn't listed so probably won't work unless you upgrade

http://yum.postgresql.org/
0
 
LVL 62

Expert Comment

by:gheist
ID: 40010751
Fedora 14 is very close to CentOS6 which was based off Fedora 13.
Postgresql 8->9 update is via dumpall, so if you can have spare server just bring up CentOS6 for some 5 more years of support...
0
 
LVL 22

Expert Comment

by:earth man2
ID: 40011247
If you want just install the source, configure it and build it yourself and address any library incompatabilities you may encounter along the way....
refer to
http://www.postgresql.org/docs/current/static/install-short.html

usually for fedora to overwrite an existing postgresql install (don't forget to backup your data first using pg_dumpall).

./configure --prefix=/usr

see
./configure --help
for more details.
0
 
LVL 62

Expert Comment

by:gheist
ID: 40011336
You can extract .spec dfrom source tarball and build right away at least on CentOS 6
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How many times have you wanted to quickly do the same thing to a list but found yourself typing it again and again? I first figured out a small time saver with the up arrow to recall the last command but that can only get you so far if you have a bi…
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Suggested Courses

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question