Koozali.org: home of the SME Server
Obsolete Releases => SME Server 7.x => Topic started by: wjhobbs on March 20, 2007, 07:22:01 PM
-
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
-
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.
-
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
-
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
-
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:# 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: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