Topic: Postres Upgrade

[wjhobbs]

I am interested in installing PostgreSQL 8.

Currently PostgreSQL 7.4 seems to be installed on my SME7.1.2 server.

I expect that the two versions cannot coexist. Does anyone know what bad things might happen if I upgrade to v8?

Thanks for your input.

John

[bpivk]

I don't know but may i suggest that you try upgrading torugh vmware first. And then report all your findings to the bugtracker. It might be usefull for developers.

[wjhobbs]

The CentosPlus repository has packages for PostgreSQL 8.1.

On a test server I tried a simple yum update after having enabled that repository. But no luck at all.

So my next thought was to download the relevant packages and do a local install. In order to avoid conflicts, I thought I might remove the current PostgreSQL packages.

The first one I tried to remove (postgresql-libs) had dependencies to dependencies, etc. It asked permission to remove 40+ packages that were, either directly or indirectly, dependent. Most of these were key smeserver packages!

OOPS!!

Time to re-think this whole idea.

May be best to wait until the SME Server version that is based on Centos 5 is available.

John

[pfloor]

I am interested in installing PostgreSQL 8.

Currently PostgreSQL 7.4 seems to be installed on my SME7.1.2 server.

I expect that the two versions cannot coexist. Does anyone know what bad things might happen if I upgrade to v8?

Thanks for your input.

John

PostgreSQL is NOT installed by default on SME7X (only postgresql-libs is)

You could try this however (your mileage may vary)

# yum --enablerepo=centosplus install postgresql

I tried and got this:

[root@spock ~]# yum --enablerepo=centosplus install postgresql
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "smeserver" plugin
Loading "fastestmirror" plugin
Setting up Install Process
Setting up repositories
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
Excluding Packages from CentOS - updates
Finished
Excluding Packages from CentOS - os
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for postgresql to pack into transaction set.
postgresql-8.1.8-1.el4s1. 100% |=========================| 118 kB    00:00
---> Package postgresql.i386 0:8.1.8-1.el4s1.1 set to be updated
--> Running transaction check
--> Processing Dependency: libpq.so.4 for package: postgresql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package postgresql-libs.i386 0:8.1.8-1.el4s1.1 set to be updated
--> Running transaction check
--> Processing Dependency: libpq.so.3 for package: dovecot
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package postgresqlclient7.i386 0:7.4.14-1.el4s1.1.el4.centos set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 postgresql              i386       8.1.8-1.el4s1.1  centosplus        2.7 M
Installing for dependencies:
 postgresqlclient7       i386       7.4.14-1.el4s1.1.el4.centos  centosplus        232 k
Updating for dependencies:
 postgresql-libs         i386       8.1.8-1.el4s1.1  centosplus        183 k

Transaction Summary
=============================================================================
Install      2 Package(s)
Update       1 Package(s)
Remove       0 Package(s)
Total download size: 3.1 M

[wjhobbs]

Paul,

Thank you for pointing me in the right direction.

I did the following on a fresh install on a test machine upgraded to 7.1.2:

Code: [Select]

# yum --enablerepo=centosplus install postgresql
which resulted in the installation of postgresql-8.1.8 and postgresqlclient7 (dependency). It also updated postgresql-libs to 8.1.8 from 7.4.

I was concerned that the update of postgresql-libs might break something -- but so far things seem OK.

I subsequently installed the remaining postgresql packages I was interested in:

Code: [Select]

yum --enablerepo=centosplus install postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test
I then did the initial set up of postgresql and everything seems OK.

Now on to install the application that will use postgres. If I encounter issues, I will report back on this thread. Otherwise, presume the the install worked as it should.

Thanks for your input.

John