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.

   Icon

   For XAMP, open the Bitnami folder

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

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

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

   2. Disable the extensions below:

   3. Enable the extensions below:

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.

   Icon

   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
      
      
      
      
   Icon

   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.