psql login with password

With a connection now established to Postgres at the psql prompt, issue the ALTER USER command to change the password for the postgres user: postgres= # ALTER USER postgres PASSWORD 'myPassword'; ALTER ROLE. weibo login If successful, Postgres will output a confirmation of ALTER ROLE as seen above Finally, exit the psql client by using the \q command