Topic: Postgresql

[tgminc]

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

[CharlieBrady]

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 ~]#

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

[tgminc]

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?

[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.

[CharlieBrady]

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.

[CharlieBrady]

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

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

[tgminc]

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.

[duncan]

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.

[tgminc]

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!