psql -W

-W, --password force password prompt (should happen automatically)

Related

• -U
• -d

See also

• PostgreSQL: psql, .psqlrc, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql --help, psql -c, \?, \connect, --version