Solved

upgrade postgresql 8.4 to 9.1 in fedora 14 64 bits

Posted on 2014-04-19
7
555 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
7 Comments
 
LVL 34

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 34

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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 34

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 61

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 61

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

939 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now