RPM (YUM) dependency question

[Paul Howarth]

John Wendel wrote:
> 
> I recently wanted to rebuild Postgres from sources on my play box. I 
> thought I'd start by removing the existing Postgres installation and ran 
> into what seems to be a strange dependency. For some reason, Apache 
> depends on postgres-libs. Can someone explain why this is required?
> 
> Thanks,
> 
> John
> 
> Dependencies Resolved
> 
> ============================================================================= 
> 
>  Package                 Arch       Version          Repository   Size
> ============================================================================= 
> 
> Removing:
>  postgresql-libs         i386       8.1.4-1.FC5.1    installed   502 k
> Removing for dependencies:
>  apr-util                i386       1.2.2-4.2        installed   155 k
>  httpd                   i386       2.2.0-5.1.2      installed   2.7 M
>  httpd-manual            i386       2.2.0-5.1.2      installed   3.4 M
>  mod_perl                i386       2.0.2-5.1        installed   6.6 M
>  mod_python              i386       3.2.8-3          installed   1.2 M
>  mod_ssl                 i386       1:2.2.0-5.1.2    installed   172 k
>  system-config-httpd     noarch     5:1.3.3-1.1      installed   2.2 M
> 
> Transaction Summary
> ============================================================================= 
> 
> Install      0 Package(s)
> Update       0 Package(s)
> Remove       8 Package(s)

httpd is linked against postgresql libs to add postgresql client support:

$ ldd /usr/sbin/httpd
         linux-gate.so.1 =>  (0x00649000)
         libm.so.6 => /lib/libm.so.6 (0x00b0e000)
         libpcre.so.0 => /lib/libpcre.so.0 (0x00f58000)
         libselinux.so.1 => /lib/libselinux.so.1 (0x00462000)
         libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0x002be000)
         libcrypt.so.1 => /lib/libcrypt.so.1 (0x0021a000)
         libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0x0098e000)
         liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0x00bfc000)
         libdb-4.3.so => /lib/libdb-4.3.so (0x00111000)
         libexpat.so.0 => /lib/libexpat.so.0 (0x006a3000)
         libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0x007f8000)
         libpthread.so.0 => /lib/libpthread.so.0 (0x00b9c000)
         libdl.so.2 => /lib/libdl.so.2 (0x005fc000)
         libc.so.6 => /lib/libc.so.6 (0x002db000)
         /lib/ld-linux.so.2 (0x0064a000)
         libsepol.so.1 => /lib/libsepol.so.1 (0x00d76000)
         libuuid.so.1 => /lib/libuuid.so.1 (0x005a2000)
         libpq.so.4 => /usr/lib/libpq.so.4 (0x00248000)
         libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0x008c6000)
         libresolv.so.2 => /lib/libresolv.so.2 (0x00269000)
         libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x0027c000)
         libssl.so.6 => /lib/libssl.so.6 (0x00c99000)
         libcrypto.so.6 => /lib/libcrypto.so.6 (0x009c8000)
         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00479000)
         libnsl.so.1 => /lib/libnsl.so.1 (0x00740000)
         libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00887000)
         libcom_err.so.2 => /lib/libcom_err.so.2 (0x00e15000)
         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00294000)
         libz.so.1 => /usr/lib/libz.so.1 (0x0040e000)
         libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00e81000)
$ rpm -qf /usr/lib/libpq.so.4
postgresql-libs-8.1.4-1.FC5.1

You'll see it's linked against the sqlite client libraries too.

Paul.