Hi, I've just updated to 3.3.0b1 and wanted to try out the postgresql db support. I cant seem to find any documentation on what I need to do to configure it. I've clicked the PostgreSQL Database button in System Config But not sure what else is needed? When I try and create a psql db from the console It seems to create a mysql db instead. Am I missing something?
1) You must install PostgreSQL, version 14 or newer. 2) Then you must update ISPConfig to 3.3. beta 1. 3) Install PHP PostgreSQL extension. Take care to install it for the system php version, e.g. php8.2-pgsql and not the package php-pgsql 4) Finally, you must enable PostgreSQL under System > Interface > main config. -- Updated 2025-04-18 --
Above worked well to enable postgresql. I have existing postgresql and databases created on it, is there a way to link it with existing websites? this will help for future tracking as well. Thanks a lot.
There is currently no way to link existing databases. All you could try to do is to manually add them in the ISPConfig database and database user tables.
I have done this and clicked to create a db. It seems to have done it front end but when I log into PSQL The database doesn't show :/ No users or databases seem to have been created although they are showing in the admin I'm using psql 17.4 and ubuntu 24.04.2
Hey till, I've installed this : sudo apt-get install php-pgsql and then done an update again but databases still don't seem to be getting created
Which Linux distributions do you use? E.g. for Debian 12, the package is php8.2-pgsql. If I remember correctly, for some reason php-pgsql did not work for me some time ago, so it's better to try to install the package for the system's PHP version with a correct version number. Besides that, you can use debug mode to see why the database can not be created: https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
I'm running Ubuntu 24.04.02 lts Looks like that might have been the issue. Installed php8.3-pgsql Instead of php-pgsql And all seems to be working now Thanks!!!!
