We all know that the sdpadmin user of pgsql database has the default password sdp@123 and this isn't good if this databese is supposed to be accessible outside of the server, not only localy

It could be necessary in case of building some reporting using external BI tools. Or in case of external scripting

So I wonder what is a safe way to change this password safely and allow SDP operating as usualy keeping the external SQL access open?