I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable pg support PHP must be built with the flag "--with-pgsql[=DIR]" and that the required support extension must be loaded via the /etc/php.ini file with the statement "extension=pgsql.so".
However, I have tried to find this file "pgsql.so" on the CentOS server before proceeding blindly and have come up empty. Can somebody here give me some detailed help on getting DRUPAL running with PsotgreSQL under CentOS; or at least point me to a site where I can find out how to obtatin the necessary and appropriate pgsql.so file? I cannot seem to find the necessary information on either php.net or postgresql.org.
Regards, Jim
On Wed, Jul 05, 2006 at 01:47:26PM -0400, James B. Byrne enlightened us:
I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable pg support PHP must be built with the flag "--with-pgsql[=DIR]" and that the required support extension must be loaded via the /etc/php.ini file with the statement "extension=pgsql.so".
However, I have tried to find this file "pgsql.so" on the CentOS server before proceeding blindly and have come up empty. Can somebody here give me some detailed help on getting DRUPAL running with PsotgreSQL under CentOS; or at least point me to a site where I can find out how to obtatin the necessary and appropriate pgsql.so file? I cannot seem to find the necessary information on either php.net or postgresql.org.
Regards, Jim
yum holds your answer.
Hint: Use the list command.
Matt
James B. Byrne wrote:
I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable pg support PHP must be built with the flag "--with-pgsql[=DIR]" and that the required support extension must be loaded via the /etc/php.ini file with the statement "extension=pgsql.so".
However, I have tried to find this file "pgsql.so" on the CentOS server before proceeding blindly and have come up empty. Can somebody here give me some detailed help on getting DRUPAL running with PsotgreSQL under CentOS; or at least point me to a site where I can find out how to obtatin the necessary and appropriate pgsql.so file? I cannot seem to find the necessary information on either php.net or postgresql.org.
yum whatprovides pgsql.so
yum install php-pgsql.i386
Max
On Wed, 2006-07-05 at 13:47 -0400, James B. Byrne wrote:
I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable pg support PHP must be built with the flag "--with-pgsql[=DIR]" and that the required support extension must be loaded via the /etc/php.ini file with the statement "extension=pgsql.so".
However, I have tried to find this file "pgsql.so" on the CentOS server before proceeding blindly and have come up empty. Can somebody here give me some detailed help on getting DRUPAL running with PsotgreSQL under CentOS; or at least point me to a site where I can find out how to obtatin the necessary and appropriate pgsql.so file? I cannot seem to find the necessary information on either php.net or postgresql.org.
I haven't run this, but I'd expect: yum install php-pgsql to be the first step.
James B. Byrne wrote:
I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable
Hi Jim,
One important note: if you are going to install Drupal (or any type of software for that matter) onto your server, be sure and subscribe to their security mailing list. Every once in a while someone finds a critical error which usually needs to be patched as soon as possible. If you do not stay on top of it, you could get your server owned pretty quickly.
Patrick
-
James B. Byrne -
Les Mikesell -
Matt Hyclak -
Max H. -
Patrick