In order to install the postgre modules, necessary for postgresql, Do the following :
/scripts/installpostgres - To install pgsql
/scripts/easyapache - To enable it in php
/scripts/makecpphp - To enable pgsql support in cpanel php for managing phppgadmin
----------------------------
cpanel staff did cpanel update and perl module checking and at one stage it started working.
I think you could also try the same (force run upcp & checkperlmodules)
Here is the following scripts that you requested.
/scripts/upcp --force
/scripts/checkperlmodules --force
----------------------------
引用:
Reloading MySQL
Done
Restoring PostgreSQL databases....
PostgreSQL is not installed. Skipping.
PGsql [More Info ↑]
Requires PostgreSQL 7.3 or higher to already be installed. You can do that with /scripts/installpostgres
if you're using cPanel/WHM you'll be able to do this via EasyApache., however EasyApache is known to run some browsers out of RAM causing it to stop executing the script, which causes Easyapache to fail.It's always best to run it in a shell to be safe.
Main >> Software >> EasyApache (Apache Update)
Easy::Apache v3.6.2
If the server does not have enough memory to run the build via a browser (IE if you get "Out of memory" errors below) then you will have to do the build via command line with /scripts/easyapache.
PHP 5.2.17 support
make for system PHP
PostgreSQL Functions
Note:
Not all functions are supported by all builds. It depends on your libpq (The PostgreSQL C client library) version and how libpq is compiled. If PHP PostgreSQL extensions are missing, then it is because your libpq version does not support them.
Note:
Most PostgreSQL functions accept connection as the first optional parameter. If it is not provided, the last opened connection is used. If it doesn't exist, functions return FALSE.
Note:
PostgreSQL automatically folds all identifiers (e.g. table/column names) to lower-case values at object creation time and at query time. To force the use of mixed or upper case identifiers, you must escape the identifier using double quotes ("").
Note:
PostgreSQL does not have special commands for fetching database schema information (eg. all the tables in the current database). Instead, there is a standard schema named information_schema in PostgreSQL 7.4 and above containing system views with all the necessary information, in an easily queryable form. See the » PostgreSQL Documentation for full details.
---------------------------------------------------
Installing Postgresql - HOWTO
cPanel requires Postgresql 7.3.x or later. 7.2.x will not work.
===========================================
Step 1
Upgrade to cPanel 7.4.0 build 45 or later
===========================================
Step 1a
(If you do not have 7.2.x or earlier installed skip this step)
===========================================
Login to a root shell via ssh or the console.
If you have Postgres 7.2.x installed, backup your databases using pg_dumpall or some other method.
Move the postgres data directory somewhere else. ie
mv /var/lib/pgsql /var/lib/pgsql.old
===========================================
Step 2
Login to a root shell via ssh or the console and run
/scripts/installpostgres
===========================================
Step 2a
(skip this step if you are not upgrading from postgres 7.2 or earlier
===========================================
Restore your sql dump created with pg_dumpall or by some other method using psql or some other method
===========================================
Step 3
Login to Web Host Manager and choose "Postgres Config" under Server Setup.
Set a postgres password to anything of your choosing. You should avoid using any non-alpha numeric charaters as these cause problems.
===========================================
Step 4
Use the "Postgres Config" option in WHM to install a postgres pg_hba.conf file. You can skip this step if you would like to setup your pg_hba.conf file manually. cPanel should work fine with md5 passwords or plaintext passwords
===========================================
Step 5
Login to cPanel and click on Postgres .. Enjoy!
===========================================
cPanel.net Support Ticket Number:
