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 databaseparams.conf under <Servicedeskplus-Home>/server/default/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


        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • How to Connect External Postgres

              Install a External Postgres such that the version of that postgres is currently in the series of inbuilt postgres of our Application. Say for example, In Servicedeskplus Application version 14010, which has postgres version 10.21, then you should ...
            • Remote read only access to database for Postgres customers

              Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...
            • Migration failure for Postgres Database with a blank space in it

              Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...
            • Query Executor Tool for PostGres

              This tool is designed to execute queries in the customer environment by connecting the database by reading the database configuration file. We need to enter the query that we require to execute in queryToExecute.txt file. We can enter multiple ...
            • How to change the database from MySQL/PostgreSQL to MSSQL

              The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...