How to login into Postgres Database?

How to login into Postgres Database?

  1. Identify the database information,
    1. For environments running version 9.4 : (To know the database used, check the file named databaseinfo under <Servicedeskplus-Home>/conf folder)

    2. For environments running version 9.3 and below : (To know the database used, check the file named databaseinfo under <Servicedeskplus-Home>/server/default/conf folder)

    3. For environments running version 10.5 and above : (To know the database used, check the file named database_params.conf under <Servicedeskplus-Home>/conf folder)

            Or, Invoke changeDBServer.bat or changeDBServer.sh file from <Servicedeskplus-Home>\bin Directory.

                                          


      2. Open command prompt or Terminal at <Servicedeskplus-Home>\pgsql\bin Directory, Execute the below command with identified values in the previous step.

For Windows,
  1. psql.exe -U <username> -p <port> -d <database_name> -h <server address>
For Linux.
  1. ./psql-U <username> -p <port> -d <database_name> -h <server address>

Generally, for our application with default configuration execute the command below.

For Connecting as sdpadmin,
  1. ./psql -h 127.0.0.1 -p 65432 -d servicedesk -U sdpadmin
For Connecting as Postgres, 
  1. ./psql -h 127.0.0.1 -p 65432 -d servicedesk -U postgres