Configuring Developer Portal with PostgreSQL

Database can be changed from MySQL or MariaDB to PostgreSQL. This approach works for any existing system. 

Requirements

For Installation

• PostgreSQL 10 or higher version

For Configuration

• Drupal 9 or higher version
• Apache 2.4 or higher version
• PHP 8 or higher version

Configuring Webserver

System Setup

1. For the existing system, go to the PHP installation path.

   

   For XAMP, open the Bitnami folder

2. Copy the below mentioned DLL files in "PHP_Home/ext":

   CODE

   php_pdo_pgsql.dll
   php_pgsql.dll
   php_apcu.dll
   php_imagick.dll
   php_phpdbg_webhelper.dll

3. Edit the php.ini file with the below changes:
   
   

   1. Ensure that the maximum error information length value is as below:

      CODE

      log_errors_max_len = 1024

   2. Disable the extensions below:

      CODE

      extension=mysqli
      extension=pdo_mysql

   3. Enable the extensions below:

      CODE

      extension=pdo_pgsql
      extension=pgsql

Configuring PostgreSQL

1. Download and Install PotgreSQL.
2. Open the PostgreSQL graphical tool.
3. Right-click the Database and navigate to Create > Database to create the Database Developer Portal.
   
   

   

   
   
   
4. Right-click the created database and navigate to Create > Extension.
   
   

   

   
   
   
5. Choose "pg_trgm" from the drop-down list and click the Save button.
   
   

   

   
   
   

6. Open the URL using the following format.

   CODE

   http://<hostname>:<port>/FioranoDeveloperPortal

   

   hostname and port corresponding to the webserver

7. Provide the following information and click the Save and continue button:
   1. Database name {*}: The name of the database created by following the steps in the section above.
   2. Database username {*}: postgres
   3. Database password {*}: As provided while installing PostgreSQL
      
      

      

      
      
      
   

   Let the modules install. Do not refresh the page.

   

   
   
   

8. In the Configure site page, provide the following and click the Save and continue button:
   1. Site name
   2. Site email address
   3. Site Administrator Mail
   4. Site Administrator password
      
      

      

      
      
      
9. Navigate to the AMS Settings section. Provide the AMS details in the corresponding fields and click the Save and continue button.
   
   

   

   
   
   
10. In the Product Settings section, set the access level of products that should be visible to developers. Click Save and continue.
    
    

    

    
    
    The Developer Portal will be successfully installed.