[HACKERS] RPMs for RedHat ES3.0
Devrim, I had some problems installing on RedHat ES3.0 with the RPMs. This issue turned out to be that I needed the compat libs to provide the old libs before I could install the new libs. I found a link to http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm in an archived post from -hackers. It wasn't all that obvious what was required though, so is it possible that this RPM could actually be put with the downloads for the main RPMs? I'm not sure anyone's installation would succeed without that RPM on RedHat ES3.0. Please let me know if I'm missing something. As an aside: is it possible to actually to just include the contents of compat-libs in postgresql-libs, since they actually seem to be required? It'd save me some hassles for future installations. Probably other folks too. Regards, Philip. Boring details: 1) removed all previous traces of postgresql: [EMAIL PROTECTED] root]# rpm -e `rpm -qa | grep postgres` \ perl-DBD-Pg-1.21-2 mod_auth_pgsql-2.0.1-4.ent php-pgsql-4.3.2-19.ent 2) Grabbed 8.0.3 binaries from: http://www.postgresql.org/ftp/binary/v8.0.3/linux/rpms/redhat/rhel-es-3.0/ 3) Try to install: [EMAIL PROTECTED] 8.x]# rpm -i postgresql-8.0.3-1PGDG.i686.rpm error: Failed dependencies: libpq.so.4 is needed by postgresql-8.0.3-1PGDG [EMAIL PROTECTED] 8.x]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm error: Failed dependencies: libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG Suggested resolutions: rh-postgresql-libs-7.3.8-2.i386.rpm 4) Install http://developer.postgresql.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm , repeat step 3 and suddenly life gets a whole lot better :-) - Utiba Pty Ltd This message has been scanned for viruses and dangerous content by Utiba mail server and is believed to be clean. ---(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
Re: [HACKERS] RPMs for RedHat ES3.0
Hi, On Mon, 3 Oct 2005, Philip Yarra wrote: Devrim, I had some problems installing on RedHat ES3.0 with the RPMs. This issue turned out to be that I needed the compat libs to provide the old libs before I could install the new libs. I found a link to http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm in an archived post from -hackers. It wasn't all that obvious what was required though, so is it possible that this RPM could actually be put with the downloads for the main RPMs? I'm not sure anyone's installation would succeed without that RPM on RedHat ES3.0. Please let me know if I'm missing something. We haven't discussed it before, but I think we can't put the RPM among PGDG RPMs. The main reason is that this is not a piece of software that's included within that release of PostgreSQL. Also, this compat RPM is not needed if you don't have a software that needs that RPM. As an aside: is it possible to actually to just include the contents of compat-libs in postgresql-libs, since they actually seem to be required? It'd save me some hassles for future installations. Probably other folks too. As I wrote above, it does not seem possible. Also remember that this will be probably 'solved' in RHEL 5 (and FC 5), so merging compat with main libs package is not a good idea. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] RPMs for RedHat ES3.0
Hi Devrim, thanks for the quick response. We haven't discussed it before, but I think we can't put the RPM among PGDG RPMs. The main reason is that this is not a piece of software that's included within that release of PostgreSQL. Also, this compat RPM is not needed if you don't have a software that needs that RPM. Have a look at my original post: I was unable to install any of the PGDG RPMs as they have a dependency on the contents of the compat RPM. E.g.: [EMAIL PROTECTED] 8.x]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm error: Failed dependencies: libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG Once I installed the compat RPM, I could then install postgresql-libs-8.0.3-1PGDG. So the software that needs the compat RPM is the PGDG RPMs. Please tell me if I have missed something here, I'm not claiming any great insight, just what rpm seems to be telling me, and what worked to get me through the installation. Also remember that this will be probably 'solved' in RHEL 5 (and FC 5), so merging compat with main libs package is not a good idea. Our clients are still on ES3.0, then they *might* migrate to 4.0 one day. RHEL5 is a long way off for us, I assure you :-) so I'm happy to lend any help I can to resolve this issue for ES3.0. I don't quite understand how the compat libs can be counted as not part of this release if the release packages require it. Is it maybe just an issue with rpm creating automatic dependiencies for those .so files? (sorry, this is me at my vaguest, rpm is something of an unknown to me, but I suspect I'm about to learn). Regards, Philip. - Utiba Pty Ltd This message has been scanned for viruses and dangerous content by Utiba mail server and is believed to be clean. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] RPMs for RedHat ES3.0
Philip Yarra [EMAIL PROTECTED] writes: Have a look at my original post: I was unable to install any of the PGDG RPMs as they have a dependency on the contents of the compat RPM. E.g.: [EMAIL PROTECTED] 8.x]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm error: Failed dependencies: libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG I think there's no question that this represents an RPM-building error. We haven't entirely figured out what's causing it though. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] RPMs for RedHat ES3.0
Hi Tom, On Tue, 4 Oct 2005 11:36 am, Tom Lane wrote: I think there's no question that this represents an RPM-building error. We haven't entirely figured out what's causing it though. Right, gotcha. I think this may be the issue: [EMAIL PROTECTED] 8.x]# rpm -ql postgresql-libs-8.0.3-1PGDG [snip] /usr/lib/libecpg_compat.so.2 [snip] [EMAIL PROTECTED] 8.x]# ldd /usr/lib/libecpg_compat.so.2 libecpg.so.4 = /usr/lib/libecpg.so.4 (0x007ba000) libpgtypes.so.1 = /usr/lib/libpgtypes.so.1 (0x00e0e000) libpq.so.3 = /usr/lib/libpq.so.3 (0x00efa000) [EMAIL PROTECTED] 8.x]# rpm -q --whatprovides /usr/lib/libpq.so.3 compat-postgresql-libs-3-3PGDG Including /usr/lib/libecpg_compat.so.2 in postgresql-libs-8.0.3-1PGDG causes automatic dependency (http://www.rpm.org/max-rpm/s1-rpm-depend-auto-depend.html) on those .so files which are only included in compat RPM. Regards, Philip. - Utiba Pty Ltd This message has been scanned for viruses and dangerous content by Utiba mail server and is believed to be clean. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org