By David Crowther
Question:
I would like to edit the existing password for a PostGIS User because they have forgotten their login credentials. How can I reset their password?
Answer:
If you are the PostGIS Super User you can login to the PostGIS database and run a simple Alter User query to reset the Users password: