ius-community team mailing list archive

[Alex Domoradov <alex.hha@xxxxxxxxx>]

> Since you didn't mention where those postgresql RPMs came from, I
just checked CentOS and Fedora RPMs to figure out the soname for 8.4 and
9.3.
sorry, forgot about the source. I have installed PosgreSQL from off site -
http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

> Your postgresql RPMs should provide "libpq.so.5()(64bit)", so in theory
they should work just fine with php55u-pgsql.
it is

# find /usr -name libpq.so* -print
/usr/pgsql-9.3/lib/libpq.so.5
/usr/pgsql-9.3/lib/libpq.so.5.6

# rpm -qf /usr/pgsql-9.3/lib/libpq.so.5
postgresql93-libs-9.3.6-1PGDG.rhel6.x86_64

As you can see on the screen - http://i.imgur.com/lpfecl9.png

So my question is - why phpinfo show me incorrect posgresql info? Where it
takes the info?


On Thu, Apr 2, 2015 at 12:13 AM, Carl George <carl.george@xxxxxxxxxxxxx>
wrote:

>  php55u-pgsql just has a dependency on the soname, not the exact package
> name.
>
>  $ repoquery --requires php55u-pgsql | grep libpq
>  libpq.so.5()(64bit)
>
> Since you didn't mention where those postgresql RPMs came from, I
> just checked CentOS and Fedora RPMs to figure out the soname for 8.4 and
> 9.3.
>
>
>  $ rpm -qp --provides postgresql-libs-8.4.20-2.el6_6.x86_64.rpm |& grep
> libpq.so.5
>  libpq.so.5()(64bit)
>  $ rpm -qp --provides postgresql-libs-9.3.6-1.fc20.x86_64.rpm |& grep
> libpq.so.5
> libpq.so.5()(64bit)
>
>
>  Your postgresql RPMs should provide "libpq.so.5()(64bit)", so in theory
> they should work just fine with php55u-pgsql.
>       ​
> Carl George
>  Rackspace RPM Development
>        ------------------------------
> *From:* Ius-community <ius-community-bounces+carl.george=
> rackspace.com@xxxxxxxxxxxxxxxxxxx> on behalf of Alex Domoradov <
> alex.hha@xxxxxxxxx>
> *Sent:* Wednesday, April 1, 2015 03:22 PM
> *To:* ius-community@xxxxxxxxxxxxxxxxxxx
> *Subject:* [Ius-community] php55u and postgresql 9.3 on centos 6
>
>     Hello
>
>  Is it possible to use php55u-pgsql package with the following postgresql
> packages?
>
> postgresql93-9.3.6-1PGDG.rhel6.x86_64
> postgresql93-libs-9.3.6-1PGDG.rhel6.x86_64
> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64
>
>  As I see in the phpinfo output it show me that php has been linked with
> older pgsql library
>
> PostgreSQL Support enabled
> PostgreSQL(libpq) Version 8.4.20
> PostgreSQL(libpq) PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled
> by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
> Multibyte character support enabled
> SSL support enabled
>
> # ldd /usr/lib64/php/modules/pgsql.so | grep sql
>         libpq.so.5 => /usr/pgsql-9.3/lib/libpq.so.5 (0x00007fad004b2000)
>
>  But at the same time
>
> # strings /usr/lib64/php/modules/pgsql.so | grep 8.4
> PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
> 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
> 8.4.20
>
>  So I'm a little bit confused. Could anyone point me in the right way?
>
>  Thanks in advance
>