Re: php-pgsql no longer works under 8.2

If looks like others have had this issue as well, but they were running
under Red Hat. Read this article:

http://people.planetpostgresql.org/devrim/index.php?/archives/66-Compat-libs-RPM-for-FC5,6-and-RHEL4.html

So someone made several compat libs but for Red Hat only... Are there
any compat libs out there for SuSE?

--- Jeff Lanzarotta <[email protected]> wrote:

> OK, I finally got back to looking at this...
> 
> After looking into phpinfo() it looks like postgreSQL is not loaded
> anymore which is what I figured since I un-installed all the
> postgreSQL
> related rpms and then compiled and installed from source.
> 
> I really do not want to have to download the php source and compile
> it
> with pg support if at all possible. There are way to many rpms
> related
> to php already installed on this system.
> 
> After further investigation, it have found an rpm,
> php5-pgsql-5.1.2-29.25.3.i586.rpm, that is for the version of php
> that
> I have as well as pg 8.2. I am not really sure if this will work, but
> I
> am trying to install this php5 rpm. When I do, it says that it needs
> 'libpg.so.4'.
> 
> Is there a way to generate libpg.so.4 from the postgreSQL source? Am
> I
> going in the wrong direction with this little project?
> 
> Thanks.
> 
> --- Chris <[email protected]> wrote:
> 
> > Jeff Lanzarotta wrote:
> > > Hello,
> > > 
> > > I installed PostgreSQL 8.2 from source on openSUSE 10.1 and now
> > various
> > > php related application no longer work. For example phpMyFAQ...
> > > 
> > > Is there a version of php-pgsql for 8.2?
> > 
> > Not sure if you need to, but did you recompile php to pick up the
> new
> > 
> > postgres version?
> > 
> > Is postgres still loaded in php? Check with a phpinfo(); page.
> > 
> > -- 
> > Postgresql & php tutorials
> > http://www.designmagick.com/
> > 
> 
> 
> ---------------------------(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
> 


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings