Change Postgres Password

Change Postgres Password

Problem :-

Need to change the default password for postgres.

Solution :-

1- connect to the database.

2- execute the below steps.

    servicedesk=# \password
   Enter new password : 
   Enter it again : 

3- Once execute it, do the below.

    - Open <SdpHome>\\pgsql\\data\\pg_hba.conf.
    - Search for "IPv4" local connections and find the below content.
  • host    all             all             127.0.0.1/32         trust
  • Change the value "trust" to "md5"
  • Do the same for # IPv6 local connections too.
4- change the DB server and Write the new password for postgres then test the connection and save it.

    • Related Articles

    • Delete Large System error logs records

      Problem: for large Log files (over 1 million records)  When we select the  "delete all" button in the system log viewer in the support tab the system Crashed !  So How can  we delete these large  log files?  Solution: we can delete them from database ...

    • Performance is slow

      Try access ServiceDesk using the IP address of the Server not using the Alias URL and if the page loads up considerably fast. follow those steps: 1- Go to this path C:\ManageEngine\ServiceDesk\conf and open server.xml file. 2- change the ...

    • Database Warning : Your database transaction log file size has crossed the threshold

      You are getting this email as a result of an enhancement that was made in the 11 version to notify administrators if the SQL Log File Size crossed the threshold. In Service Desk Plus, under Performance Settings in Admin/ESM Directory you have the ...

    • List of Services Template Report

      Tthe below Query to list all service catalog in the system Database : PostgreSQL Server - Version: 10.5 SELECT serd.Name "Service Category", reqtl.templatename "Service catalog", sla.slaname "SLA" , sdo.name "Site", array_to_string(array_agg(CASE ...