I have two red hat 7.1 machines. On one I have successfully upgraded postgres to 7.1.3 from 7.0.x. It took awhile, but I was finally able to do it with the rpm from postgres site. On the other machine, I have been trying for days and all the time end up with non-functioning pg functions. I get an error like "undefinded function pg_pconnect()"
All the advice I have seen about this kind of error says that PHP is not compiled with postgres suppport. I install with postgres, php, pg_php, etc... everything as that is required, and it the pg_functions work after fresh install of red hat. then I attempt install these postgres 7.1 rpm and, same thing. I have tried various combos, like not installing postgres from the distrution, then installing the rpm from postgres.org. The installer doesn't like that if I want to pg_php with postgres. I have tried many combinations of install this, don't install that, install this after that, and before the other. Nothing. Same damn error.
I tried to install from the postgres..tar.gz file. I am going to try that again, because I went with defauts, and I think that red hat has different directory structure (usr/lib not usr/local).
Can anyone can give me a clue which way to go now? I really need outer-joins for what I am doing.
TIA,
Richard
All the advice I have seen about this kind of error says that PHP is not compiled with postgres suppport. I install with postgres, php, pg_php, etc... everything as that is required, and it the pg_functions work after fresh install of red hat. then I attempt install these postgres 7.1 rpm and, same thing. I have tried various combos, like not installing postgres from the distrution, then installing the rpm from postgres.org. The installer doesn't like that if I want to pg_php with postgres. I have tried many combinations of install this, don't install that, install this after that, and before the other. Nothing. Same damn error.
I tried to install from the postgres..tar.gz file. I am going to try that again, because I went with defauts, and I think that red hat has different directory structure (usr/lib not usr/local).
Can anyone can give me a clue which way to go now? I really need outer-joins for what I am doing.
TIA,
Richard