How to login into Postgres Database?
- Identify the database information,
-
For environments running version 9.4 : (To know the database used, check the file named databaseinfo under <Servicedeskplus-Home>/conf folder)
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)
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,
- psql.exe -U <username> -p <port> -d <database_name> -h <server address>
For Linux.
- ./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,
- ./psql -h 127.0.0.1 -p 65432 -d servicedesk -U sdpadmin
For Connecting as Postgres,
- ./psql -h 127.0.0.1 -p 65432 -d servicedesk -U postgres