upgrade postgresql 8.4 to 9.1 in fedora 14 64 bits

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)
itaakashcomAsked:
Who is Participating?
 
Dan CraciunIT ConsultantCommented:
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
 
itaakashcomAuthor Commented:
but i don't want to change my operating system
0
 
Dan CraciunIT ConsultantCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Seth SimmonsSr. Systems AdministratorCommented:
fedora 14 isn't listed so probably won't work unless you upgrade

http://yum.postgresql.org/
0
 
gheistCommented:
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
 
earth man2Commented:
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
 
gheistCommented:
You can extract .spec dfrom source tarball and build right away at least on CentOS 6
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.