Hi all, hi Hendrick,

Just a note on this.

I was trying to install pgadmin3-1.4.3-1.i686.rpm on CentOS 4.4 with
PostgreSQL 8.1.4, but I could not install the PgAdmin3 1.4.3 because it
requires the /usr/lib/libpq.so.3.
I tried to do the symbolic link and for my surprise it did not work,
it complained in the same way, even after rebooting, just in case.
libpq.so.3 was not in my "ldconfig -p".

As this workaround did not work, I had to "break" yum/RPM
"integrity/consistency", which I really do not like.
I ended up forcing the RPM installation of
postgresql-libs-7.4.13-2.RHEL4.1 ...
This RPM rewrote some locale files, so after that I forced the
resinstallation of my postgresql-libs-8.1.4-3PGDG.

Is there a real solution ofr this issue?

I am not a MySQL fan, but MySQL has a compatibility-libs pkg/RPM that
takes care od issues like this...
I have not seen something similar for PostgreSQL and I have not found
anything else on the Internet about this issue...

This is my config:

CentOS 4.4
Linux localhost 2.6.9-42.0.2.EL #1 Tue Aug 22 23:56:05 CDT 2006 i686
i686 i386 GNU/Linux
rpm -qa | egrep -i -e "(postg)|(pg)|(wx)|(sdl)" | sort:
gnupg-1.2.6-6
gpg-pubkey-443e1821-421f218f
libgpg-error-1.0-1
pgadmin3-1.4.3-1
postgresql-8.1.4-3PGDG
postgresql-contrib-8.1.4-3PGDG
postgresql-libs-7.4.13-2.RHEL4.1
postgresql-libs-8.1.4-3PGDG
postgresql-server-8.1.4-3PGDG
SDL-1.2.7-8
wxGTK-2.6.3-2.6.3.2.1


Regards,
__________________________________________________ ______________________
Check Out the new free AIM(R) Mail -- 2 GB of storage and
industry-leading spam and email virus protection.


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hi,

On Fri, 2006-10-06 at 00:42 -0400, hugoksouza@aim.com wrote:
> Is there a real solution ofr this issue?

Sure.

http://developer.postgresql.org/~devrim/rpms/compat/

Use the RPM which is suitable for your platform. This is Red Hat (so its
clone) problem if you install PGDG RPMs instead of Red Hat RPMs. RH
provide 7.4 RPMs, and they build php-pgsql stuff and other related
things with libpq3. Recent PGDG RPMs for RHEL 4 provide libpq.so.4.
That's why we built a compat lib that solves this problem. Just run rpm
-ivh against this.

> I am not a MySQL fan, but MySQL has a compatibility-libs pkg/RPM
> that takes care od issues like this..

I think you should Google a bit more before talking about My$QL (it
drives me crazy).

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBFJgaopme12CBXnxERAiqDAKCfghf2VcLddJo7yz9aJl GTrUcvDwCgi1Bt
QxYClZdNUwEeo8dckl5ZDQ4=
=ph5a
-----END PGP SIGNATURE-----

Hi Devrim,

Thanks for your prompt and accurate reply.

It seems it worked for me.


Thanks and regards,


-----Original Message-----
From: devrim (at) commandprompt (dot) com
To: Hugo Kawamorita de Souza
Cc: pgadmin-support@postgresql.org
Sent: Fri, 6 Oct 2006 3:32 AM
Subject: Re: [pgadmin-support] Installation on mandriva 2006

Hi,

On Fri, 2006-10-06 at 00:42 -0400, hugoksouza@aim.com wrote:
> Is there a real solution ofr this issue?

Sure.

http://developer.postgresql.org/~devrim/rpms/compat/

Use the RPM which is suitable for your platform. This is Red Hat (so its
clone) problem if you install PGDG RPMs instead of Red Hat RPMs. RH
provide 7.4 RPMs, and they build php-pgsql stuff and other related
things with libpq3. Recent PGDG RPMs for RHEL 4 provide libpq.so.4.
That's why we built a compat lib that solves this problem. Just run rpm
-ivh against this.

> I am not a MySQL fan, but MySQL has a compatibility-libs pkg/RPM
> that takes care od issues like this..

I think you should Google a bit more before talking about My$QL (it
drives me crazy).

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


__________________________________________________ ______________________
Check Out the new free AIM(R) Mail -- 2 GB of storage and
industry-leading spam and email virus protection.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend