kevintynfron Posted November 20, 2008 Share Posted November 20, 2008 Hi all, I'm not sure where to ask this, but am getting the following in the error file for the server: '<b>Warning</b>: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pgsql.so' - libpq.so.4: cannot open shared object file: No such file or directory in <b>Unknown</b> on line <b>0</b><br />' I'm guessing that this is to do with the postgres database engine. We're running mySQL, but using myISAM and InnoDB tables. It doesn't seem to be causing a problem in terms of site performance, but these warnings are merrily filling the error logs that are getting a bit big. It seems to be related to starting an Apache child process, as the number of warnings has increased since I increased the maxclients in Apache. We have no plans to use the postgres db system, so I'd rather just switch it off. Using Apache 2.054 on Fedora, PHP and mySQL. Cheers, Kevin Quote Link to comment Share on other sites More sharing options...
Mchl Posted November 20, 2008 Share Posted November 20, 2008 Try to disable postgres extension (pgsql) in php.ini Quote Link to comment Share on other sites More sharing options...
kevintynfron Posted November 20, 2008 Author Share Posted November 20, 2008 Cheers, will try tomorrow morning when things aren't busy. The references I've found are below. Will it be enough to just add a ';' to comment out in pgsql.ini, or should I comment out everything in php.ini as well for good measure? Many thanks, Kevin in /etc/php.d/pgsql.ini ; Enable pgsql extension module extension=pgsql.so and in /etc/php.ini [PostgresSQL] ; Allow or prevent persistent links. pgsql.allow_persistent = On ; Detect broken persistent links always with pg_pconnect(). ; Auto reset feature requires a little overheads. pgsql.auto_reset_persistent = Off ; Maximum number of persistent links. -1 means no limit. pgsql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. pgsql.max_links = -1 ; Ignore PostgreSQL backends Notice message or not. ; Notice message logging require a little overheads. pgsql.ignore_notice = 0 ; Log PostgreSQL backends Noitce message or not. ; Unless pgsql.ignore_notice=0, module cannot log notice message. pgsql.log_notice = 0 Quote Link to comment Share on other sites More sharing options...
trq Posted November 20, 2008 Share Posted November 20, 2008 Will it be enough to just add a ';' to comment out in pgsql.ini Should be. Quote Link to comment Share on other sites More sharing options...
kevintynfron Posted November 21, 2008 Author Share Posted November 21, 2008 Went with the comment in pgsql.ini and it worked great. Thanks again, Kevin Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.