How do I either set a password for postgres, properly use the postgres user, or stop postgres from asking me for a password?
I accidentally set password to blank for a PostgreSQL database, how do I change it?