How to change default Postgres password
Please follow the below-mentioned steps:
1. Stop the application services.
2. Please take a backup of the application <OR> take a Snapshot of the Server
3. Open Command Prompt with Admin Privileges
4. Navigate to <Drive>:\ManageEngine\ServiceDesk\bin and execute the command stopdB.bat
5. Now execute the command "changeDBPassword.bat -p <old password> -P <new password>"
Example: changeDBPassword.bat -p sdp@123 -P sdp@1234
6. Make sure, you get the below message:
7. Now execute the command startdB.bat and the start the application services.
For Linux :
1. Navigate to ManageEngine/ServiceDesk/bin and execute the command stopdB.sh.
2. Execute the command "sh changeDBPassword.sh -p <old password> -P <new password>"
3. Execute the command startdB.sh.
New to ADSelfService Plus?
Related Articles
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 ...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 ...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," ...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 ...Error While connecting default Postgres Database
If you are getting the below error while connecting the postgresDB , please follow the steps below : Error : psql: FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “servicedesk”,SSL off Please open pg_hba.conf under [ServiceDesk ...