How to connect to Database in Version 11.0? PGSQL

How to connect to Database in Version 11.0? PGSQL

1.Open a cmd with admin privileges

2.navigate to ManageEngine\SupportCenterPlus\pgsql\bin and enter the below command:

psql.exe -U scpadmin -p 65432 -h supportcenter

For example:

SupportCenterPlus\pgsql\bin>psql.exe -U scpadmin -p 65432 -h supportcenter

3.Once done, you will be prompted for a password and the default password would be scp@123

Attachment included. 

                    New to ADSelfService Plus?

                      • Related Articles

                      • 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 ...
                      • How to Change default password on PGSQL database

                        Please do follow the below steps which would assist you in changing the default Postgres password.  1. Stop the application services.   2. Please take a trimmed backup <OR> take a Snapshot of  the Server 3. Open Command Prompt with Admin Privileges ...
                      • 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 supportcenter -> C:\> cd ...
                      • 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. ...
                      • 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 ...