I'm building a database/application server with a Dual-Opteron 64 bit system.
I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts with Postgres 8.1 and PHP 4 that comes with CentOS.
History: 1) I installed Apache and PHP with yum. 2) I then installed PostgreSQL 8.1 RPMs from the PG website. 3) Then, I tried to install php-pgsql with yum - and it didn't work, complaining about pgsql.so.3. So, I installed with --nodeps and symlinked the /usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.3.
Now, PHP and PGSQL work without any problems. But now, I can't do a yum update - it still complains about pgsql.so.3!
What can I do to resolve this?
Thanks, -Ben
On Mon, 2005-12-26 at 10:33 -0800, Benjamin Smith wrote:
I'm building a database/application server with a Dual-Opteron 64 bit system.
I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts with Postgres 8.1 and PHP 4 that comes with CentOS.
History:
- I installed Apache and PHP with yum.
- I then installed PostgreSQL 8.1 RPMs from the PG website.
- Then, I tried to install php-pgsql with yum - and it didn't work,
complaining about pgsql.so.3. So, I installed with --nodeps and symlinked the /usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.3.
Now, PHP and PGSQL work without any problems. But now, I can't do a yum update
- it still complains about pgsql.so.3!
What can I do to resolve this?
We have a pgslq 8.x in the dev.centos.org site ... you might try that:
http://dev.centos.org/centos/4/testing/x86_64/RPMS/
(remember that this is beta quality for centos ... but it still should be a better fit than standard stuff from the pgsql website because it should work with php/apache from centos.)
Thanks - you rock!
-Ben
On Monday 26 December 2005 12:48, Johnny Hughes wrote:
On Mon, 2005-12-26 at 10:33 -0800, Benjamin Smith wrote:
I'm building a database/application server with a Dual-Opteron 64 bit
system.
I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts
with
Postgres 8.1 and PHP 4 that comes with CentOS.
History:
- I installed Apache and PHP with yum.
- I then installed PostgreSQL 8.1 RPMs from the PG website.
- Then, I tried to install php-pgsql with yum - and it didn't work,
complaining about pgsql.so.3. So, I installed with --nodeps and symlinked
the
/usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.3.
Now, PHP and PGSQL work without any problems. But now, I can't do a yum
update
- it still complains about pgsql.so.3!
What can I do to resolve this?
We have a pgslq 8.x in the dev.centos.org site ... you might try that:
http://dev.centos.org/centos/4/testing/x86_64/RPMS/
(remember that this is beta quality for centos ... but it still should be a better fit than standard stuff from the pgsql website because it should work with php/apache from centos.)
We have a pgslq 8.x in the dev.centos.org site ... you might try that: http://dev.centos.org/centos/4/testing/x86_64/RPMS/
I tried using the dev Postgres RPMS, and am still running into the same issues. I did this on an x86 system, since the x86_64 is currently partially in production, to see if it could/would work.
I tried: 1) yum remove `rpm -qa | grep postg`; # This removed php-pgsql due to dependencies
2) wget all the PG 8.x RPMS from Centos dev.
3) rpm -Uvh postg*
4) yum install php-pgsql; # returns an error pasted below: Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package php-pgsql.i386 0:4.3.9-3.9 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.3 for package: php-pgsql --> Finished Dependency Resolution Error: Missing Dependency: libpq.so.3 is needed by package php-pgsql
Back to square one. Ideas?
-Ben On Monday 26 December 2005 12:48, Johnny Hughes wrote:
On Mon, 2005-12-26 at 10:33 -0800, Benjamin Smith wrote:
I'm building a database/application server with a Dual-Opteron 64 bit
system.
I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts
with
Postgres 8.1 and PHP 4 that comes with CentOS.
History:
- I installed Apache and PHP with yum.
- I then installed PostgreSQL 8.1 RPMs from the PG website.
- Then, I tried to install php-pgsql with yum - and it didn't work,
complaining about pgsql.so.3. So, I installed with --nodeps and symlinked
the
/usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.3.
Now, PHP and PGSQL work without any problems. But now, I can't do a yum
update
- it still complains about pgsql.so.3!
What can I do to resolve this?
We have a pgslq 8.x in the dev.centos.org site ... you might try that:
http://dev.centos.org/centos/4/testing/x86_64/RPMS/
(remember that this is beta quality for centos ... but it still should be a better fit than standard stuff from the pgsql website because it should work with php/apache from centos.)
Hmm, that looks like a rebuild of the php-pqsql package might be necessary (get the php.src.rpm package and rpmbuild --rebuild php.src.rpm it, and install the php-pqsql package that generates)
???
MaZe.
On Tue, 27 Dec 2005, Benjamin Smith wrote:
We have a pgslq 8.x in the dev.centos.org site ... you might try that: http://dev.centos.org/centos/4/testing/x86_64/RPMS/
I tried using the dev Postgres RPMS, and am still running into the same issues. I did this on an x86 system, since the x86_64 is currently partially in production, to see if it could/would work.
I tried:
- yum remove `rpm -qa | grep postg`; # This removed php-pgsql due to
dependencies
wget all the PG 8.x RPMS from Centos dev.
rpm -Uvh postg*
yum install php-pgsql; # returns an error pasted below:
Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package php-pgsql.i386 0:4.3.9-3.9 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.3 for package: php-pgsql --> Finished Dependency Resolution Error: Missing Dependency: libpq.so.3 is needed by package php-pgsql
Back to square one. Ideas?
-Ben On Monday 26 December 2005 12:48, Johnny Hughes wrote:
On Mon, 2005-12-26 at 10:33 -0800, Benjamin Smith wrote:
I'm building a database/application server with a Dual-Opteron 64 bit
system.
I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts
with
Postgres 8.1 and PHP 4 that comes with CentOS.
History:
- I installed Apache and PHP with yum.
- I then installed PostgreSQL 8.1 RPMs from the PG website.
- Then, I tried to install php-pgsql with yum - and it didn't work,
complaining about pgsql.so.3. So, I installed with --nodeps and symlinked
the
/usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.3.
Now, PHP and PGSQL work without any problems. But now, I can't do a yum
update
- it still complains about pgsql.so.3!
What can I do to resolve this?
We have a pgslq 8.x in the dev.centos.org site ... you might try that:
http://dev.centos.org/centos/4/testing/x86_64/RPMS/
(remember that this is beta quality for centos ... but it still should be a better fit than standard stuff from the pgsql website because it should work with php/apache from centos.)
On 12/27/05, Benjamin Smith lists@benjamindsmith.com wrote:
We have a pgslq 8.x in the dev.centos.org site ... you might try that: http://dev.centos.org/centos/4/testing/x86_64/RPMS/
I tried using the dev Postgres RPMS, and am still running into the same issues. I did this on an x86 system, since the x86_64 is currently partially in production, to see if it could/would work.
I tried:
- yum remove `rpm -qa | grep postg`; # This removed php-pgsql due to
dependencies
wget all the PG 8.x RPMS from Centos dev.
rpm -Uvh postg*
yum install php-pgsql; # returns an error pasted below:
Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package php-pgsql.i386 0:4.3.9-3.9 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.3 for package: php-pgsql --> Finished Dependency Resolution Error: Missing Dependency: libpq.so.3 is needed by package php-pgsql
Back to square one. Ideas?
Yes. Install the compat-libs also. this is the exact problem they fix. They're in the dev repository as well.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center
Totally missed this one - it didn't start with "postgresql"...
Seems to have done the trick. Thanks!
-Ben
On Tuesday 27 December 2005 15:34, Jim Perrin wrote:
Yes. Install the compat-libs also. this is the exact problem they fix. They're in the dev repository as well.
On 12/28/05, Benjamin Smith lists@benjamindsmith.com wrote:
Totally missed this one - it didn't start with "postgresql"...
Seems to have done the trick. Thanks!
-Ben
No problem. I'd appreciate some feedback about the rpms to know if there's anything I need to tweak for them. Also, we need feedback in order to move them to centosplus where more might find/use them.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center
See my other email. It worked perfectly in 32-bit land, but bombed in 64 bit. (loaded a 32-bit .so into /usr/lib64)
-Ben
On Wednesday 28 December 2005 05:14, Jim Perrin wrote:
On 12/28/05, Benjamin Smith lists@benjamindsmith.com wrote:
Totally missed this one - it didn't start with "postgresql"...
Seems to have done the trick. Thanks!
-Ben
No problem. I'd appreciate some feedback about the rpms to know if there's anything I need to tweak for them. Also, we need feedback in order to move them to centosplus where more might find/use them.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 12/28/05, Benjamin Smith lists@benjamindsmith.com wrote:
See my other email. It worked perfectly in 32-bit land, but bombed in 64 bit. (loaded a 32-bit .so into /usr/lib64)
-Ben
Turns out the previous x86_64 version wasn't very x86_64ish. I'm working to put out an update so that it's fixed, but I don't currently have an x86_64 box so that's slowing me down a little. Hopefully it'll be in the x86_64 dev tree in the next 24hours or so.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center
Turns out the previous x86_64 version wasn't very x86_64ish. I'm working to put out an update so that it's fixed, but I don't currently have an x86_64 box so that's slowing me down a little. Hopefully it'll be in the x86_64 dev tree in the next 24hours or so.
Should be there now. Please try the new set and see if you still have the same issue.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center
I installed the new compat (there are now both in the dev RPM repo) rpm and then was able to install php-pgsql with yum.
I've verified that it works, on the dual-proc Opteron without a hitch. After a bit more testing, I'll finally be able to switch over production fully from the wheezing, 32-bit P4 server to the big new shiny server...
Thanks!
Is this PG 8.1 ever going to be part of the official 4.x release, or is this something that's done separately by you instead of coming from upstream? And, the corollary question - what do I need to do to ensure that these packages get updated via yum, without subscribing to all the other "development" rpms?
-Ben
On Wednesday 28 December 2005 18:33, Jim Perrin wrote:
Turns out the previous x86_64 version wasn't very x86_64ish. I'm working to put out an update so that it's fixed, but I don't currently have an x86_64 box so that's slowing me down a little. Hopefully it'll be in the x86_64 dev tree in the next 24hours or so.
Should be there now. Please try the new set and see if you still have the same issue.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On Thu, 2005-12-29 at 00:15 -0800, Benjamin Smith wrote:
I installed the new compat (there are now both in the dev RPM repo) rpm and then was able to install php-pgsql with yum.
I've verified that it works, on the dual-proc Opteron without a hitch. After a bit more testing, I'll finally be able to switch over production fully from the wheezing, 32-bit P4 server to the big new shiny server...
Thanks!
Is this PG 8.1 ever going to be part of the official 4.x release, or is this something that's done separately by you instead of coming from upstream? And, the corollary question - what do I need to do to ensure that these packages get updated via yum, without subscribing to all the other "development" rpms?
No, it will never be in base / updates, it will be in centosplus (after we move it out of testing).
How you can get JUST the RPMS you want and no others is to use yum (and not up2date) for the centosplus repo ...
When we move it to the centosplus repo, in your "/etc/yum.repos.d/CentOS-Base.repo" file, you would change the centosplus section of the file to look like this:
#------------------------------------------------------------------- #additional packages that extend functionality of existing packages [centosplus] name=CentOS-$releasever - Plus baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/ gpgcheck=1 enabled=1 includepkgs=postgresql* compat-postgresql-libs* gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos4 ------------------------------------------------------------------
the only lines that are changed from default are the "enabled=" and the "includepkgs=" lines ...
If you want to have any files except postgresql* and compat-postgreqsl- libs*, you will need to add them to the "includepkgs=" line ... because after use "includepkgs=", yum will only install the packages on that line from the that repo.
DO NOT USE up2date for the centosplus repo, as it will not honor the "includepkgs=" line and install all packages from the repo, not just those listed. Updates to the CentOSPlus repo will also not show up in the CentOSNetwork Applet if you use it.
if you are using a different mirror than mirror.centos.org ... you can include the other mirror URLS instead of mirror.centos.org.
-Ben
On Wednesday 28 December 2005 18:33, Jim Perrin wrote:
Turns out the previous x86_64 version wasn't very x86_64ish. I'm working to put out an update so that it's fixed, but I don't currently have an x86_64 box so that's slowing me down a little. Hopefully it'll be in the x86_64 dev tree in the next 24hours or so.
Should be there now. Please try the new set and see if you still have the same issue.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
I long ago standardized on yum, and have been maintaining my own repos for various flavors. (Such as, a yum repo for updates from Progeny for aging RedHat 7.x systems - their curl-based system sucks, but sticking a yum repo on top of an "update" yum repo managed by a cron script makes managing updates a single-command process)
Thanks - the config on my server has been so updated, and yum update works as expected.
-Ben
On Thursday 29 December 2005 04:01, Johnny Hughes wrote:
On Thu, 2005-12-29 at 00:15 -0800, Benjamin Smith wrote:
I installed the new compat (there are now both in the dev RPM repo) rpm
and
then was able to install php-pgsql with yum.
I've verified that it works, on the dual-proc Opteron without a hitch.
After a
bit more testing, I'll finally be able to switch over production fully
from
the wheezing, 32-bit P4 server to the big new shiny server...
Thanks!
Is this PG 8.1 ever going to be part of the official 4.x release, or is
this
something that's done separately by you instead of coming from upstream?
And,
the corollary question - what do I need to do to ensure that these
packages
get updated via yum, without subscribing to all the other "development"
rpms?
No, it will never be in base / updates, it will be in centosplus (after we move it out of testing).
How you can get JUST the RPMS you want and no others is to use yum (and not up2date) for the centosplus repo ...
When we move it to the centosplus repo, in your "/etc/yum.repos.d/CentOS-Base.repo" file, you would change the centosplus section of the file to look like this:
#------------------------------------------------------------------- #additional packages that extend functionality of existing packages [centosplus] name=CentOS-$releasever - Plus baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/ gpgcheck=1 enabled=1 includepkgs=postgresql* compat-postgresql-libs* gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos4
the only lines that are changed from default are the "enabled=" and the "includepkgs=" lines ...
If you want to have any files except postgresql* and compat-postgreqsl- libs*, you will need to add them to the "includepkgs=" line ... because after use "includepkgs=", yum will only install the packages on that line from the that repo.
DO NOT USE up2date for the centosplus repo, as it will not honor the "includepkgs=" line and install all packages from the repo, not just those listed. Updates to the CentOSPlus repo will also not show up in the CentOSNetwork Applet if you use it.
if you are using a different mirror than mirror.centos.org ... you can include the other mirror URLS instead of mirror.centos.org.
-Ben
On Wednesday 28 December 2005 18:33, Jim Perrin wrote:
Turns out the previous x86_64 version wasn't very x86_64ish. I'm working to put out an update so that it's fixed, but I don't currently have an x86_64 box so that's slowing me down a little. Hopefully it'll be in the x86_64 dev tree in the next 24hours or so.
Should be there now. Please try the new set and see if you still have the same issue.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On Thursday 29 December 2005 07:01, Johnny Hughes wrote:
Is this PG 8.1 ever going to be part of the official 4.x release, or is this something that's done separately by you instead of coming from
No, it will never be in base / updates, it will be in centosplus (after we move it out of testing).
You need to warn people about updating with centosplus enabled, otherwise if they use centosplus (for perhaps the unsupported kernels or PHP5) and they have a running PostgreSQL instance, they will get a nasty surprise.
To the OP, a major PostgreSQL version jump/upgrade is virtually impossible to automate within the constraints of the RPM mechanism (and yum/up2date do not change the underlying mechanism, except perhaps the order in which triggers fire and scriptlets execute, but I've not tested that). You need to know to do a full backup/dump and wipe the database dir before the upgrade, then do your restore. Database upgrades are not easy; PostgreSQL, because of the way and depth in which it can be extended can be more difficult than most, but that's due to its power.
Well, in this case, I've long been aware of the dump/reload cycle when incrementing any major version, and had already setup PG 8.1 using the RPMs from the PostgreSQL website, so for me, it was just a case of removing the PG RPMs and then installing the CentOS RPMs.
Where this broke is that php-pgsql was looking for libpg.so.3, but PG 8.1 installs libpg.so.4, and AFAI can tell, this is now resolved.
-Ben
On Friday 30 December 2005 08:58, Lamar Owen wrote:
On Thursday 29 December 2005 07:01, Johnny Hughes wrote:
Is this PG 8.1 ever going to be part of the official 4.x release, or is this something that's done separately by you instead of coming from
No, it will never be in base / updates, it will be in centosplus (after we move it out of testing).
You need to warn people about updating with centosplus enabled, otherwise if they use centosplus (for perhaps the unsupported kernels or PHP5) and they have a running PostgreSQL instance, they will get a nasty surprise.
To the OP, a major PostgreSQL version jump/upgrade is virtually impossible
to
automate within the constraints of the RPM mechanism (and yum/up2date do not change the underlying mechanism, except perhaps the order in which triggers fire and scriptlets execute, but I've not tested that). You need to know to do a full backup/dump and wipe the database dir before the upgrade, then do your restore. Database upgrades are not easy; PostgreSQL, because of the
way
and depth in which it can be extended can be more difficult than most, but that's due to its power. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 12/30/05, Benjamin Smith lists@benjamindsmith.com wrote:
Well, in this case, I've long been aware of the dump/reload cycle when incrementing any major version, and had already setup PG 8.1 using the RPMs from the PostgreSQL website, so for me, it was just a case of removing the PG RPMs and then installing the CentOS RPMs.
Where this broke is that php-pgsql was looking for libpg.so.3, but PG 8.1 installs libpg.so.4, and AFAI can tell, this is now resolved.
Technically all you needed were the compat libs. There isn't much difference between the centos rpms and the pg rpms. You'll see Lamar's name plastered all over both sets I'm sure. :-P
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center
On Friday 30 December 2005 16:16, Jim Perrin wrote:
Technically all you needed were the compat libs. There isn't much difference between the centos rpms and the pg rpms. You'll see Lamar's name plastered all over both sets I'm sure. :-P
Indeed. This is a two-edged sword, mind you (as I'm sure all the CentOS developers have also found out the hard way....celebrity, even geekdom celebrity, has significant downsides!). Not so much since the 8.0 set, though, as I passed the release mechanic torch to Devrim after 7.4; the CentOS 4 base 7.4 set, on the other hand...and I may be more involved in the 8.2 cycle than in the last two.
Well I thought this was going to do it - it worked fine on the 32-bit CentOS. But, in the 64 bit one, the compat-libs installs a 32 bit binary into the /usr/lib64 directory, even though the rpm file is clearly marked 64...
[root@kepler pg81]# rpm -Uvh compat-postgresql-libs-3-3.c4.centos.x86_64.rpm
[root@kepler pg81]# file /usr/lib64/libpq.so.3.1 /usr/lib64/libpq.so.3.1: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), stripped
[root@kepler pg81]# rpm -qf /usr/lib64/libpq.so.3.1 compat-postgresql-libs-3-3.c4.centos
So, I guess I've tested it, and it's not built correctly? (I'm beginning to HATE 64 bit, even though performance is awesome!)
-Ben
On Tuesday 27 December 2005 15:34, Jim Perrin wrote:
Yes. Install the compat-libs also. this is the exact problem they fix. They're in the dev repository as well.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On Wednesday 28 December 2005 14:00, Benjamin Smith wrote:
Well I thought this was going to do it - it worked fine on the 32-bit CentOS. But, in the 64 bit one, the compat-libs installs a 32 bit binary into the /usr/lib64 directory, even though the rpm file is clearly marked 64...
The compat RPM's source RPM isn't. That is, the source RPM is actually a pre-package of binaries, not buildable source, made from a binary tarball of the libpq.so.3 and associated libs. I had to rebuild the source tarball for my UltraSPARC myself, when building and installing PG 8.1 on Aurora 2.0 on my Enterprise 6500.
So an rpmbuild --rebuild of the compat libs will, on any architecture you care to mention, install the i386 libs. This includes SPARC, PPC, Alpha, etc. You will have to install/build the previous libs (7.4.8 is current CentOS 4), make the tarball, modify the SPEC, and build that way. It IS a kludge, but what other way to do it smoothly without including 10MB of PostgreSQL source code in the source RPM? The postgresql-rpm building group would love to see the solution.
-
Benjamin Smith -
Jim Perrin -
Johnny Hughes -
Lamar Owen -
Maciej Żenczykowski