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 -- "The best way to predict the future is to invent it." - XEROX PARC slogan, circa 1978
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: > 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? >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.) -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part URL: <http://lists.centos.org/pipermail/centos/attachments/20051226/bd148611/attachment-0001.sig>
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 bitsystem.> > > > I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflictswith> > 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 symlinkedthe> > /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 yumupdate> > - 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.) >-- "The best way to predict the future is to invent it." - XEROX PARC slogan, circa 1978
>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 bitsystem.> > > > I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflictswith> > 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 symlinkedthe> > /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 yumupdate> > - 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.) >-- "The best way to predict the future is to invent it." - XEROX PARC slogan, circa 1978