Need Postgres 8.1, not 8.0

[km4hr]

I want to install an application that requires Postgresql 8.1 (or higher). As far as I can tell only 8.0.8 is available in the default repositories for FC4. (Note: I'm not good with yum, repositories, etc).

Can anyone tell me if Postgresql 8.1 is available in any repository?

I could do a fresh install from the Postgres web site but I'd rather do it the "right" way.

Actually, the Postgres download site has installation files specifically for Fedora:
http://www.postgresql.org/ftp/binary...x/rpms/fedora/
Can I use these without screwing up my system's rpm/yum repository mechanism?

[William Haller]

PostgreSQL is available from the postgresql.org/download site. Don't know how it will work on FC4. It installed and ran on Whitebox Linux just fine though and it's older. The only issues were needing to dump dovecot as it had a dependency. First do a rpm -e postgresql --test to see what is tied to the version you are running now and see if you can give them up (or if they have other RPMs that can be downloaded that will run with 8.1)

[paolosca]

I would try first to see if you can run the application with the version you have. We ported applications from postgres 7 to 8 and again from 8 to 7 without a problem.

The only problem we got is that sometimes the sql scripts to create the database give some error but they are quite easy to fix. Beside that, the applications work perfectly.

If your server is dedicated this database you may want to upgrade fedora, FC6 have Postgres 8.1.4 (and perhaps also FC5).

If upgrading the server is too much of a problem then you can do a fresh install of postgres with the sources you find on the postgres website although it may (or may not) be more troublesome than the two options above.

Out of curiosity, what application are you trying to install?

Regards,

Paolo.

[giulix]

yum remove postgresql
rpm -i postgresql-libs-8.2.1-1PGDG.i686.rpm postgresql-8.2.1-1PGDG.i686.rpm postgresql-server-8.2.1-1PGDG.i686.rpm

After removing every dependency of 8.0.8, installation of 8.2.1 worked fine on my FC4 system:

su -
[root@localhost ~]# service postgresql initdb
[root@localhost ~]# service postgresql start
[root@localhost ~]# su - postgres
-bash-3.00$ createdb giulix
CREATE DATABASE
-bash-3.00$ psql
Welcome to psql 8.2.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# \q

[km4hr]

I'm trying to install MediaWiki (http://mediawiki.org). The MW installer terminates telling me I don't have Postgress 8.1.

Back to my original question. The Postgresql download site I referenced has Fedora FC4 installation files. Will it mess my system's rpm database if I use these?

Speaking of upgrading the server to FC6, is there a way to do that easily, like with Debian based systems that can be upgraded forever? Or do you still have to use installation CD's and basically start over with a fresh install for ever major update? (I need to review the Fedora installation docs. Perhaps things have changed.)

[giulix]

Originally Posted by km4hr

Back to my original question. The Postgresql download site I referenced has Fedora FC4 installation files. Will it mess my system's rpm database if I use these?

No, it won't. Only you won't be able to update version 8.0.8 if a new release comes out, but since FC4 is not supported anymore, this is a non-issue...

[paolosca]

I never upgraded from FC4 to FC6 but upgrading from FC4 to FC5 and from FC5 to FC6 has always been a smooth process to me.

You can also do it with yum, it will download and upgrade only the packages installed.

If you are currently using Postgres for other applications remember that the database will not be compatible and you will have to backup all your data before upgrading.

Strange MediaWiki needs PostGres 8.1. We have servers with the lastest versions of Suse and Debian and they are still using Postgres 7.4.