How to connect to DB - 8121
Connect to PostgreSQL Server in Windows:
Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt.
-> C:\> cd ManageEngine\SupportCenter\pgsql\bin
Enter the command: psql.exe -U postgres -p 65432 -h 127.0.0.1 supportcenter
-> C:\> cd ManageEngine\SupportCenter\pgsql\bin>psql.exe -U postgres -p 65432 -h 127.0.0.1 supportcenter
SupportCenter is the name of the database. 65432 is the port on which SupportCenter Plus database runs. SupportCenter Plus uses postgres account to connect to the database and does not use any password. You can connect to PostgreSQL database only from the server console.
Connect to PostgreSQL Server in Linux:
Install the PostgreSQL client which supports your Linux version.
Once this is accomplished, make sure that the command "psql" is in path. (Most often, psql should be under path, if not, you may add the complete path to psql command under PATH variable in the bashrc file.
Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt.
# cd [SupportCenter Plus Home]/pgsql/bin
Enter the command: # ./psql -U postgres -h localhost -p 65432 supportcenter
