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

    • Change Implementation Query Report

      Purpose This report extracts Change, Task, and Worklog details specifically for changes in the Implementation stage. It provides a consolidated view to track: Change progress Task execution Ownership and priorities Worklog activity The report ...

    • Change Lock Screen Image

      Purpose This solution explains how to change the Windows lock screen image on managed devices using EPC custom script deployment. The process includes: Preparing the lock screen image Uploading the required script Configuring the deployment settings ...

    • 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 ...

    • Instant Task Deployment Fails with “Invalid Authentication Passcode” - OS Deployment

      Problem Description: A client encountered a deployment failure when using an Instant Task to deploy an OS image over the network. The error displayed: Invalid authentication passcode. Observations: The authentication passcode has been verified as ...

    • Restricting Browser Screenshots: Edge Web Capture Configuration

      Purpose To disable the built-in Web Capture (Screenshot) feature in Microsoft Edge via Registry configuration, ensuring users cannot capture screen content through the browser UI. Prerequisites Administrative Privileges: Required to modify ...