Re: php 5.1.4 and PostgreSQL 8.1.4

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