To connect Postgres database from remote PC using PgAdmin tool
Please follow the below steps to connect Postgres database from remote PC using PgAdmin tool.
Stop the server and perform the steps.
1. Go to the location C:\\ManageEngine\\SupportCenter\\pgsql\\data, edit the file postgresql.conf and make the below changes.
change #listen_addresses = 'localhost' to listen_addresses = '*' and save the file.
2. From the same location C:\\ManageEngine\\SupportCenter\\pgsql\\data, edit the file pg_hba.conf and make the below changes.
# IPv4 local connections:
host all all 127.0.0.1/32 trust
From the above parameter, change 127.0.0.1/32 to 0.0.0.0/0 and save the file.
3. Start the server.
Note : In attached screen shot scp is installed in ' scp-k12r2-1 ' machine. ' pgadmin ' is installed in ' scp-w2k8r2-1 '
New to ADSelfService Plus?
How to Connect to SCP Database ? (from 11000 builds)
In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command 1. If the database is PGSQL (Default database) psql -h localhost -U scpadmin -p 65432 -d ...
Database migration from MySQL to Postgres/MSSQL in SCP 8.1
We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...
solution for postgres 11 upgrade issues
When Supportcenter Plus is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...
How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine Supportcenter Plus service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup. ...
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 ...