Thread: Installation on mandriva 2006
I amtrying to install pgadmin on to a mandrake 2006 system , bu the installation fails due to a lack of libpgq.so.3. I can find no trace of libpq.so.3. there is however a libpq.so and a libpq.so.4 which is an sl of the .so version HELP Alan Bromley
libpq.so.3 is part of the libpq3 rpm. As i compiled it on Mandriva linux 2005LE, it can be that in 2006 libpq3 has become libpq4. The easiest solution: as root do: ln -s /usr/lib/libpq.so.4 /usr/lib/libpq.so.3 next, install the rpm. I'll see what I can do to change this dependency in the rpm package. Hendrik-Jan 2005/12/20, Alan Bromley <alan@queni.net>: > I amtrying to install pgadmin on to a mandrake 2006 system , bu the > installation fails due to a lack of libpgq.so.3. > > I can find no trace of libpq.so.3. > > there is however a libpq.so and a libpq.so.4 which is an sl of > the .so version > > HELP > > > Alan Bromley > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
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/Linuxrpm -qa | egrep -i -e "(postg)|(pg)|(wx)|(sdl)" | sort:gnupg-1.2.6-6gpg-pubkey-443e1821-421f218flibgpg-error-1.0-1pgadmin3-1.4.3-1postgresql-8.1.4-3PGDGpostgresql-contrib-8.1.4-3PGDGpostgresql-libs-7.4.13-2.RHEL4.1postgresql-libs-8.1.4-3PGDGpostgresql-server-8.1.4-3PGDGSDL-1.2.7-8wxGTK-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.
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/
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.