How to Change default password on PGSQL database

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

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>"

ExamplechangeDBPassword.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 reset Admin password (SDOrg) for SupportCenter Plus 11.0 version and above

                        This is applicable only above SupportCenter Plus 11.0 version. If you are using any other build , please contact support with the details. You can get the build number from About us present in the top right of the user interface. 1. Access your ...
                      • The update option grayed out while restting the password

                        Sometimes, the update option will be grayed out while resetting the password. It could be due to the fact that the there is no valid license applied to the default Portal. Once the default portal is associated with the valid license, the update ...
                      • 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 ...
                      • 8.1 Reset global admin Password from the database

                        MYSQL query to reset Administrator's password: Follow the steps as mentioned below which would help you to reset the "admin"/"administrator" password as "admin".   1. Connect to MySQL Server on Port 33356 using the command from the SC+ server ...
                      • 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. ...