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 ...How to Connect External Postgres
To install an external PostgreSQL server, ensure the PostgreSQL version matches the inbuilt PostgreSQL version series of the ServiceDesk Plus application. For example: If ServiceDesk Plus version is 14010 with PostgreSQL version 10.21, install an ...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 ...Backup password protection
The application backup is protected with a password. The password is required to open the backup file / restore it. This password can be changed in the Admin-> Backup schedule page. Click Edit Scheduling and input the backup password to change the ...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 ...