Re: [BUGS] RHEL4 RPM packages
Hi, On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote: looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist. Ok, I got lots of complaints about this. I will work on this today and announce new sets. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [BUGS] RHEL4 RPM packages
On 4/11/07, Devrim GÜNDÜZ [EMAIL PROTECTED] wrote: On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote: looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist. Ok, I got lots of complaints about this. I will work on this today and announce new sets. It's not a real problem IMHO. AFAIR the compat RPMs were designed to provide a compatibility layer between newer versions of PostgreSQL and the distribution standard packages and you won't have both libpq versions used by the distro. It's probably easy to fix it but I don't think it's so important. At least it doesn't prevent anyone to have a working system. -- Guillaume ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [BUGS] RHEL4 RPM packages
Hi, On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote: well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system that also has, say, RH's build of Apache + PHP + PG access, as thats linked to the -3 libraries Uh? So installing only compat-3 and PostgreSQL 8.2.3 doesn't work? Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [BUGS] RHEL4 RPM packages
On 4/11/07, John R Pierce [EMAIL PROTECTED] wrote: I think what -I- ran into was that there was no compat-3 in the public repositories, just compat-4... this was about a month ago. devrim indicated he was going to upload compat-3, and showed me where to find it, but I'd already installed compat-4, so -3 refused to install. on the grounds that there are undoutablly software out there which WAS linked with libpq.so.4, it seems to me there should just be one compat-postgresql-libs RPM which provides both 3 and 4 and coexists with current 8.2.3 rpms. There's no software linked with libpq.so.4 on standard RHEL 4. They are all built on libpq.so.3. IMHO, your problem is that it seems to the RPM database that compat 4 is newer than compat. I think we should have 2 different packages with different names compat-3 and compat-4. But you only need the compat package with libpq.so.3 to install 8.1 and 8.2 on RHEL 4. -- Guillaume ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [BUGS] RHEL4 RPM packages
Guillaume Smet wrote: But you only need the compat package with libpq.so.3 to install 8.1 and 8.2 on RHEL 4. but, again, I only see the compat -4 here... no -3. http://www.postgresql.org/ftp/binary/v8.2.3/linux/rpms/redhat/rhel-es-4/ the 8.2.1 equiv of that path has a comment thats flat wrong too, that libpq.so.4 shipped with RHEL4... ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] RHEL4 RPM packages
Devrim GÜNDÜZ wrote: Hi, On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote: well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system that also has, say, RH's build of Apache + PHP + PG access, as thats linked to the -3 libraries Uh? So installing only compat-3 and PostgreSQL 8.2.3 doesn't work? I'll have to try that again on a clean box. I think what -I- ran into was that there was no compat-3 in the public repositories, just compat-4... this was about a month ago. devrim indicated he was going to upload compat-3, and showed me where to find it, but I'd already installed compat-4, so -3 refused to install. on the grounds that there are undoutablly software out there which WAS linked with libpq.so.4, it seems to me there should just be one compat-postgresql-libs RPM which provides both 3 and 4 and coexists with current 8.2.3 rpms. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] RHEL4 RPM packages
Guillaume Smet wrote: On 4/11/07, Devrim GÜNDÜZ [EMAIL PROTECTED] wrote: On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote: looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist. Ok, I got lots of complaints about this. I will work on this today and announce new sets. It's not a real problem IMHO. AFAIR the compat RPMs were designed to provide a compatibility layer between newer versions of PostgreSQL and the distribution standard packages and you won't have both libpq versions used by the distro. It's probably easy to fix it but I don't think it's so important. At least it doesn't prevent anyone to have a working system. well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system that also has, say, RH's build of Apache + PHP + PG access, as thats linked to the -3 libraries you get into rpm hell very fast going down that path. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [BUGS] RHEL4 RPM packages
John, On 3/2/07, John R Pierce [EMAIL PROTECTED] wrote: compat-postgresql-libs-4-2PGDG.rhel4.rpm supplies libpq.so.4 and .4.1, but it does NOT include .so.3. I think it should provide a .so.3 which can coexist with the rest of the 8.2.3 stack (or, there should be a compat-postgresql-libs-3 ?) Just use this package: http://developer.postgresql.org/~devrim/rpms/compat/ (and especially http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3-3PGDG.i686.rpm as you don't seem to use 64 bits packages) which includes libpq.so.3. It works well on RHEL4. FYI, Devrim is the PGDG RPM maintainer. -- Guillaume ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] RHEL4 RPM packages
Hi, On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote: (or, there should be a compat-postgresql-libs-3 ?) Hmm. Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend, to rhel-4 directories; so that people can find that package easily. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [BUGS] RHEL4 RPM packages
Devrim GÜNDÜZ wrote: Hi, On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote: (or, there should be a compat-postgresql-libs-3 ?) Hmm. Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend, to rhel-4 directories; so that people can find that package easily. ah! I think thats a good thing. I did not know where to look for this. thanks, all! ---(end of broadcast)--- TIP 6: explain analyze is your friend
[BUGS] RHEL4 RPM packages
the PGDG .rpm's for RHEL4 have a bit of an annoyance... RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a dependency on libpq.so.3 ... # rpm -Uvh postgresql-8.2.3-1PGDG.i686.rpm \ postgresql-libs-8.2.3-1PGDG.i686.rpm \ postgresql-server-8.2.3-1PGDG.i686.rpm \ postgresql-contrib-8.2.3-1PGDG.i686.rpm \ compat-postgresql-libs-4-2PGDG.rhel4.i686.rpm warning: /var/tmp/rpm-xfer.N9M9NQ: V3 DSA signature: NOKEY, key ID 20579f11 error: Failed dependencies: libpq.so.3 is needed by (installed) dovecot-0.99.11-4.EL4.i386 compat-postgresql-libs-4-2PGDG.rhel4.rpm supplies libpq.so.4 and .4.1, but it does NOT include .so.3. I think it should provide a .so.3 which can coexist with the rest of the 8.2.3 stack (or, there should be a compat-postgresql-libs-3 ?) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq