I installed Apache 2.4
via the “Apache Lounge” link (i.e. no XAMPP or WAMP), PostgreSQL 17.5
via the EDB installer, and php 8.4.10
from the php.net.
Apache and PHP work fine, i also successfully ported a database dump from ny linux system and verified that PsogreSQL is working correctly (using psql
.
Apache is located in C:Apache24
, php is in C:php84
, and postgresql is in C:Program FilesPostgreSQL
In php.ini
I have the lines
extension=pdo_pgsql
extension=pgsql
I then installed phpPgAdmin 7.13.0
from the official GitHub repository and put the extracted folders under C:Apache24htdocs
.
I created a file phppgadmin.conf
in C:Apache24confextra
with the contents
Alias /phppgadmin "C:/Apache24/htdocs/phppgadmin"
<Directory "C:/Apache24/htdocs/phppgadmin">
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>
Then I added C:Apache24bin;C:php84;C:Program FilesPostgreSQL17bin
to the PATH environment variable.
When i point my browser at http://localhost/phppgadmin
i get a page with the contents
Your PHP installation does not support the pgsql, mbstring modules. You will need to install, enable, or compile them to use phpPgAdmin.
How can i make PHP “support the pgsql, mbstring modules”, so that i can run phppgadmin, and access my postgresql DB from php scripts?
EDIT: in C:Apache24htdocsphppgadminconfconfig.inc.php
i have these lines (amongst many others):
$conf['servers'][0]['desc'] = 'PostgreSQL';
$conf['servers'][0]['host'] = 'localhost';
$conf['servers'][0]['port'] = 5432;
$conf['servers'][0]['defaultdb'] = 'postgres';
$conf['servers'][0]['username'] = 'postgres';
$conf['servers'][0]['password'] = 'MyPGPassword';