Unable to Connect the bundled PGSQL from outside the server after upgrading to 14300

Unable to Connect the bundled PGSQL from outside the server after upgrading to 14300


Inorder to connect  our bundled postgres from External machine, we need to configure the postgres in such a way that is accessible from outside the server. By default, it will be accessible only within the server.
Such configurations are to be made in postgres_ext.conf file located at <servicedeskplus_home>\pgsql\ext_conf\ directory. There are some other cases like using our bundled Postgres as external Postgres for other builds, configuration of customized timezone etc. For that we will modify the parameters like listen_address, timezone etc. These parameters can be configured in <servicedeskplus_home>\pgsql\data\postgresql.conf too. 

But It is not advised to modify the default postgresql.conf file bundled along with Postgres database.  If the configurations are made in postgresql.conf, these configurations will not be retained after migration (major upgrade like 14300). 

All these above cases will fail post migration, due to the absence of configuration.

Solution :
  1. As mentioned above, It is not advised to modify the default postgresql.conf file bundled along with Postgres database.
  2. We should do all these configurations only in pgsql\ext_conf\postgres_ext.conf file (which will be retained in future upgrades too).


                    New to ADSelfService Plus?

                      • Related Articles

                      • How to connect to the ServiceDesk database?

                        Open command prompt on the server and change the directory to MangeEngine\ServiceDesk\bin, invoke the batch file 'changeDBServer.bat' For MSSQL database  Connect to the query analyzer of the SQL server and execute the queries. For PostgreSQL database ...
                      • How to connect to the AssetExplorer database?

                        To find the database connected to your installation, open Command Prompt with elevated permission, navigate to [AE-Home]\bin directory and invoke the batch file 'changeDBServer.bat'. [AE-Home] is Drive:\ManageEngine\AssetExplorer\ directory. ...
                      • How to connect PGSQL from a remote computer?

                        To remotely access a PostgreSQL database, you must set the two main PostgreSQL configuration files: postgresql.conf pg_hba.conf First of all, configure PostgreSQL service to listen on port 65432 on all network interfaces in Windows 7 machine: open ...
                      • Unable to connect to the application

                        Checklist :   Check whether the web interface is accessible from the server? Is the URL accessible? Check if there are any errors? Can you connect to the application using the server's IP address? Are there any errors when you start the application ...
                      • Basic Performance Issues RCA On Postgres DB Cx

                        Whenever cx faces slowness in PG SQL Setup, below are the first step of actions to check and proceed based on our previous performance tickets. 1. Antivirus are main cause of slowness, high CPU, and memory consumption of PGSQL in many cx tickets. ...