postgre sql not working - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Installation & Setup (https://forum.codeigniter.com/forumdisplay.php?fid=9) +--- Thread: postgre sql not working (/showthread.php?tid=62767) |
postgre sql not working - Theo - 08-24-2015 Hi all, I've spend hours trying to use my postgre database. I've searched internet, tried all i've seen, but it stilll don't work My databse file informations : Code: $active_group = 'default'; I've changed my original connexion inormations ! It's important to note that databse drvier is loaded When i try ti connect, i see this message : A PHP Error was encountered Severity: Error Message: Call to undefined function pg_connect() Filename: postgre/postgre_driver.php Line Number: 154 Backtrace: Thank you very much for your help ! RE: postgre sql not working - nimli - 08-31-2015 Hello, I have faced the same issue for almost a week. At the end, I change the setup in Apache. Instead of installing php as an apache handler, I run it as Fast CGI. After that, I see an error message about the setting with "dsn" in the "application/config/database.php". Then I follow this to change the config file: https://codezone4.wordpress.com/2013/05/27/codeigniter-configuration-for-postgresql-database/ After that, the error seems to have gone away. (...will need more testings to confirm it's actually working...) Hope this helps. RE: postgre sql not working - nimli - 09-01-2015 Hello, After further testing, I seem to find out the cause of the issue. In one test, I install php as an apache handler. The subject issue occurs. Then, I copy "libpg.dll" from the "php" folder to "apache/bin". The problem goes away... |