Re: PostgreSQL 7.1 Linux Installation

> Paulo Parola wrote:
> I had a previously installed version of PostgreSQL server
> (postgresql-server-7.0.2-17.i386.rpm). I had though a problem with the
> RPM install procedure, when the following messages were issued:

> postgresql-server
> ##################################################
> /sbin/ldconfig: Input file /usr/lib/libgck.so not found.
> /sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
> /sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

> Is that problematic? In fact I started the postmaster and have tested
> accessing the database both with 'psql' remotely through SSH as well
> as with phpPgAdmin via Web and it is apparently functioning very well.

It's a quirk of the server postinstall script.  But it doesn't cause any
problems.

> [root@atlas PostgreSQL]# rpm -Uvh postgresql-7.1beta4-1.i386.rpm
> error: failed dependencies:
>         postgresql = 7.0.2 is needed by postgresql-server-7.0.2-17
>         libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
>         libpq.so.2.1 is needed by postgresql-server-7.0.2-17
> [root@atlas PostgreSQL]# rpm -Uvh
> postgresql-server-7.1beta4-1.i386.rpm
> error: failed dependencies:
>         postgresql = 7.1beta4 is needed by
> postgresql-server-7.1beta4-1
>         libpq.so.2 is needed by postgresql-server-7.1beta4-1

The upgrade has to be done on one line: rpm -Uvh
postgresql-7.1beta4-1.i386.rpm postgresql-server-7.1beta4-1.i386.rpm.
Please note that those RPM's were built on RedHat 6.2, not 7.0.

> [root@atlas PostgreSQL]# rpm -e postgresql-server-7.0.2-17.i386.rpm
> error: package postgresql-server-7.0.2-17.i386.rpm is not installed
> [root@atlas PostgreSQL]# rpm -e postgresql-7.0.2-17.i386.rpm
> error: package postgresql-7.0.2-17.i386.rpm is not installed

The installed package name is just 'postgresql-7.0.2-17' or
'postgresql-server-7.0.2-17'. No .i386.rpm.

The dependencies on libpq.so.2.1 are more troublesome, unfortunately.
While you can use --nodeps to force bypassing the dependencies, that is
not recommended for the 'typical' RPM install.  7.1beta4 provides
libpq.so.2.2, not libpq.so.2.1, and the dependency system as it stands
won't automatically say 'oh, it's a newer _minor_ version -- no
problem.'
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11