postgresql database user and database creation does not work from ISPConfig

Discussion in 'Installation/Configuration' started by atmomin2003, Aug 5, 2025.

Tags:
  1. atmomin2003

    atmomin2003 New Member

    I have setup new server. I have installed postgresql. On ISPConfig control panel, I m trying to create postgresql database user, but I don't see selection of pgsql in user creation and also when I create database, the job finishes, but I don't see the database in pgsql cli

    sudo -i -u postgres
    psql
    \l
    I only see the default databases. Is this right way to check?
    I m on 3.3.0p2.

    In the ISPConfig Cron - Log, I see error for the pgsql database but on job queue database creation job completes fine.
    Tue 05 Aug 2025 12:10:02 PM MDT ERROR: database "c5_name" does not exist

    Thanks
     
    Last edited: Aug 5, 2025
    atmomin2003, Aug 5, 2025
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Ensure that you have the PHP postgresql extension installed for the system PHP version of your server. if the extension is not installed, ISPConfig can not create the database. Important, you must install e.g. phpX.X-pgsql extension for the correct PHP version and not just php-pgsql. And then you must delete the database and create it again in ISPConfig.
     
    till, Aug 5, 2025
    #2
  3. atmomin2003

    atmomin2003 New Member

    Do I need to enable PHP on the website that I have created database for? My website is nodejs based, so, I have not enabled php on that website.
    Just wondering, what about user creation, how does ISPConfig knows the user is for pgsql and not for mariadb? the link next to database still points to phpmyadmin.
     
    atmomin2003, Aug 5, 2025
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    No. But ISPConfig is written in PHP, and when ISPConfig can not access PostgreSQL, it can not create the database.

    The user is created in MySQL and Postgres when you create the database, not when you create the user. So ISPConfig knows which users are for MySQL, PostgreSQL, or both.
     
    till, Aug 5, 2025
    #4
  5. atmomin2003

    atmomin2003 New Member

    That worked great. pgsql database and user as created with control panel is working well with my nodejs app. Thanks a lot!
     
    atmomin2003, Aug 7, 2025
    #5

Share This Page