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 :
- As mentioned above, It is not advised to modify the default postgresql.conf file bundled along with Postgres database.
- We should do all these configurations only in pgsql\ext_conf\postgres_ext.conf file (which will be retained in future upgrades too).
External Postgres KB : https://pitstop.manageengine.com/portal/en/kb/articles/how-to-connect-external-postgres
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 ...How to access our bundled PostgreSQL from External Applications & Servers
To access a PostgreSQL database from an external machine, you need to configure PostgreSQL to allow remote connections, open the necessary network ports, and ensure proper authentication. Here are the steps to access PostgreSQL from an external ...