In Linux, it can be done by
My OSX is not a server app.
I think it it can be done by
ALTER USER postgres with password '1234'; postgreQSL prompt but I am not sure if it is the meant way.
How can you restart the PostgreSQL server in OSX?