I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8
for some time and all was OK. The last days I went to PostgreSQL 8.1.4
and since then the PGSQL extension crashes Apache, no matter what I do.
Is there any experience in this direction?
Thanks,
Iv.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
pobox@verysmall.org wrote:
> I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8
> for some time and all was OK. The last days I went to PostgreSQL 8.1.4
> and since then the PGSQL extension crashes Apache, no matter what I do.
I was going to ask if you compiled php yourself but bsd doesn't have
pre-compiled stuff does it? (I have no experience with *bsd so excuse
the newbie question)..
Did you recompile php after upgrading postgresql?
You might need to generate a backtrace and get the internals list to
help you out..
http://bugs.php.net/bugs-generating-backtrace.php
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Monday 05 June 2006 22:26, pobox@verysmall.org wrote:
> I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8
> for some time and all was OK. The last days I went to PostgreSQL 8.1.4
> and since then the PGSQL extension crashes Apache, no matter what I do.
>
> Is there any experience in this direction?
>
> Thanks,
> Iv.
You have to recompile the postgresql extension for php
(cd /usr/ports/databases/php5-pgsql && make clean && make reinstall)
Also, postgresql's internal files are not backward-compatible, so if you are
updating from 8.0.x to 8.1.x, you should do a dump of all your databases with
your old version of postgresql (8.0.x) and import with the new one (8.1.x)
(sorry if you already did this, just wanted to make sure, but can you connect
to the database using other method than php ? (psql for example ?) )
I am have the same configuration for php and postgresql and it works fine
here.
Hope this helps you.
--
Marius
GPG/PGP: https://unkn.homeunix.org/unkn.asc
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php