Bug #68646 [Nab]: Cannot load pgsql extension

Edit report at https://bugs.php.net/bug.php?id=68646&edit=1 ID: 68646 User updated by: tony at marston-home dot demon dot co dot uk Reported by: tony at marston-home dot demon dot co dot uk Summary: Cannot load pgsql extension Status: Not a bug Type: Bug Package: PostgreSQL related Operating System: Windows 7 PHP Version: 5.6.4 Block user comment: N Private report: N New Comment: I did not change my Apache configuration, nor did I change my postgresql installation. My httpd.conf file contains the same LoadFile "E:\Program Files (x86)\PostgreSQL\9.2\bin\libpq.dll" directive that it did with the previous PHP installation. I did not overwrite the php.ini file as that exists in the C:/windows directory and not the F:/PHP5 directory. Your reference to me using a different SAPI is incorrect. My extension_dir setting remains unchanged at F:/php5/ext I repeat, all I have done is upgrade the files in my F:/PHP5 directory. The pgsql extension no longer shows up in phpinfo() and is therefore not usable. Previous Comments: ------------------------------------------------------------------------ [2014-12-25 11:51:53] ab@php.net Also, from what i see in the bug #68645 - ext with different SAPI, and - as you told you was doing an overwrite. That probably something on shouldn't do. Yes, you might be able reuse the php.ini (but check also), but don't do overwrite - replace the dir. I'd advise you to start from backing up your old f:\php5 and extracting new fresh zipball, then putting the old/revisited php.ini in there. Thanks. ------------------------------------------------------------------------ [2014-12-25 11:44:41] ab@php.net With this you see that the pgsql ext itself isn't broken. You need to revisit your configuration under Apache. Please note, that Apache does chroot away from the php dir. So check what you have on the %path% when Apache starts. Also ensure that php.ini has correct path to the extension_dir. Thanks ------------------------------------------------------------------------ [2014-12-25 10:47:46] tony at marston-home dot demon dot co dot uk This is the output I get from that command: Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. F:\PHP5>php -n -d extension_dir=ext -d extension=php_pgsql.dll -m [PHP Modules] bcmath calendar Core ctype date dom ereg filter ftp hash iconv json libxml mcrypt mhash mysqlnd odbc pcre PDO pgsql Phar Reflection session SimpleXML SPL standard tokenizer wddx xml xmlreader xmlwriter zip zlib [Zend Modules] F:\PHP5> The pgsql extension is still not showing in phpinfo(). ------------------------------------------------------------------------ [2014-12-24 17:29:36] ab@php.net Ok, so this is checked. Please do the following cd <5.6 folder path> php -n -d extension_dir=ext -d extension=php_pgsql.dll -m do you see the pgsql ext loading? Thanks. ------------------------------------------------------------------------ [2014-12-24 15:12:54] tony at marston-home dot demon dot co dot uk No, I did not edit the wrong php.ini file. I did not edit any file at all as I already had a working PHP installation. All I did was overwrite my 5.5.18 installation with the files for 5.6.4, and the pgsql extension simply stopped working. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=68646 -- Edit this bug report at https://bugs.php.net/bug.php?id=68646&edit=1