Jump to content

[SOLVED] postgress files missing/php installation


Recommended Posts

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

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

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.