note 100918 added to install.windows.apache2

I wanted to install PHP5.3 for Apache2.2 with PostgreSql 9.0 support on WindowsXP. It took me hours to solve it. The following possible problems occur: - You should use the VC6-compiled version of php instead of VC9. The later one does not work properly with apache. - the postgres handler dlls are not working in PHP5.3. The symptom was a misleading and very confusing error message: Unable to load dynamic library 'c:\Progra~1\PHP\ext\php_pgsql.dll' The dll itself was there but when it started to load the other dll (libpq.dll) from the php directory then this caused an error. This error was misinterpreted internally in the above message. The solution was NOT to use the libpq.dll from php but use it from postgres distribution instead. For this purpose I inserted the following line into the apache httpd conf: LoadFile "C:/Progra~1/PostgreSQL/9.0/bin/libpq.dll" This preloads the dll. When php_pgsql.dll would load his own libpq.dll, then there is the preloaded version of this file in the memory already. This prevents us from using the bad version of dll. I hope I helped. ---- Server IP: 69.147.83.197 Probable Submitter: 91.82.72.102 ---- Manual Page -- http://www.php.net/manual/en/install.windows.apache2.php Edit -- https://master.php.net/note/edit/100918 Del: integrated -- https://master.php.net/note/delete/100918/integrated Del: useless -- https://master.php.net/note/delete/100918/useless Del: bad code -- https://master.php.net/note/delete/100918/bad+code Del: spam -- https://master.php.net/note/delete/100918/spam Del: non-english -- https://master.php.net/note/delete/100918/non-english Del: in docs -- https://master.php.net/note/delete/100918/in+docs Del: other reasons-- https://master.php.net/note/delete/100918 Reject -- https://master.php.net/note/reject/100918 Search -- https://master.php.net/manage/user-notes.php