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
Unable to start the application due to Pgsql privilege issue
ISSUE: Application does not start via both services and command prompt. ERROR TRACE: Serverout: [16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| ...Live Chat Doesn't work Outside the server
Issue: Live chat function works on the MSP server i.e. works only when tried on localhost, however does not work outside it. Same will be the case with Bell notification and Request collaboration features. Cause: This happens mostly on HTTPS where ...Connect to default PGSQL database remotely
1. To be able to reach the server remotely you have to add the following line into the file: ManageEngine/ServiceDeskPlus-MSP/pgsql/data/postgresql.conf: listen_addresses = '*' 2. PostgreSQL, by default, refuses all connections it receives from ...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 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 ...