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.
3. Open Command Prompt with Admin Privileges
4. Navigate to <Drive>:\ManageEngine\SupportCenter\bin and execute the command stopdB.bat
5. Now execute the command "changeDBPassword.bat -p <old password> -P <new password>"
Example: changeDBPassword.bat -p scp@123 -P scp@1234
6. Make sure, you get the below message:
7. Now execute the command startdB.bat and start the application services.
New to ADSelfService Plus?
Related Articles
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 ...How to connect to the ServiceDesk database?
For MSSQL database 1. To know the database server information, open command prompt on the server, change the directory to <sdp_home>\bin and invoke the batch file changeDBServer.bat (or changeDBServer.sh) to see the database server information. Note ...Remote read only access to database for Postgres customers
Use case: 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 ...How to reset database users' Password in bundled Postgres?
We have built several database users in our product with bundled postgres, including "rouser," a read-only account used to configure the external reporting tool, "sdpadmin," who handles database activities integrated with our product, and "postgres," ...How to change the database from MSSQL to PostgreSQL
The steps mentioned below are applicable only if you migrate the DB from MSSQL to PgSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to PgSQL DB from the existing MSSL DB. For ...