Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: tgminc on May 21, 2006, 11:18:03 PM

Title: Postgresql
Post by: tgminc on May 21, 2006, 11:18:03 PM

Why is postgresql-libs-7.4.8-1.RHEL4.1 part of this distribution???

It really does impede trying to install a full PostgreSQL distribution from postgresql.org

Title: Re: Postgresql
Post by: CharlieBrady on May 21, 2006, 11:24:27 PM

Quote from: "tgminc"

Why is postgresql-libs-7.4.8-1.RHEL4.1 part of this distribution???

Maybe there's no good reason:

[root@test7 ~]# rpm -q --whatrequires postgresql-libs
no package requires postgresql-libs
[root@test7 ~]#

Quote

It really does impede trying to install a full PostgreSQL distribution from postgresql.org

It's your system, if you don't want postgresql-libs installed, then just remove it:

rpm -e postgresql-libs

Title: Postgresql
Post by: tgminc on May 21, 2006, 11:37:33 PM

I did test the waters and...

[root@pegasus rhel-es-3.0]# rpm -e postgresql-libs-7.4.8-1.RHEL4.1
error: Failed dependencies:
        libpq.so.3 is needed by (installed) dovecot-0.99.14-1.2.el4.rf.i386

What is dovecot?

Title: Postgresql
Post by: tgminc on May 21, 2006, 11:41:34 PM

Ok google says - "Dovecot is an open source IMAP and POP3 server for Linux/UNIX-like systems" - not sure what the corelation is - yet.

Title: Postgresql
Post by: CharlieBrady on May 21, 2006, 11:46:44 PM

Quote from: "tgminc"

Ok google says - "Dovecot is an open source IMAP and POP3 server for Linux/UNIX-like systems" - not sure what the corelation is - yet.

Some parts of dovecot - parts which we don't use - are linked against the postgresql libraries. If you're prepared to take my word for it, you can use --nodeps to remove that RPM without breaking dovecot.

Title: Re: Postgresql
Post by: CharlieBrady on May 21, 2006, 11:47:41 PM

Quote from: "tgminc"

It really does impede trying to install a full PostgreSQL distribution from postgresql.org

Couldn't you just use the postgresql RPMs from CentOS?

Title: Postgresql
Post by: tgminc on May 21, 2006, 11:57:34 PM

I've been using e-smith since 4.1.

In recent years I have been using an out-of-the-box intall with templated customizations that include apache->mod_jk->tomcat->postgresql. I have been using this configuation in production and it has been rock solid. The best part is that is is "out of the box" and the customizations are templated so recovery is a snap. The few times I have run into hardware failures recovery was easy - just install from CD and restore the sme backup - painless.

I think you can see why this might fall into the hacked/customized install and would be a bit of a pain during recovery. I think I'll hang on to 6.5 for now.

Thanks.

Title: Postgresql
Post by: duncan on May 22, 2006, 12:38:05 AM

Again

Couldn't you just use the postgresql RPMs from CentOS?

Code: [Select]

yum --enablerepo=base --enablerepo=updates install postgresql postgresql-server

Wait a couple of minutes and Voila.

Title: Postgresql
Post by: tgminc on May 22, 2006, 04:26:51 AM

Ok - so I "rpm -e --nodeps postgresql-libs" and then installed the 8.1.3 distribution from postgresql.org.

I installed all that I wanted with the exception of postgresql-pl - seems to have a dependancy on libtcl8.4.so.

I have the CentOS-4.3 distribution so its on the CDs somewhere. I'll sort it out later ;-)

Thanks Charlie!