postgres 16密码带特殊字符会失败

postgres 16密码带特殊字符会验证失败

sudo -u postgres psql -c "ALTER USER bloguser WITH PASSWORD '@Re123456';"
ALTER ROLE
(venv) ubuntu@10-7-146-155:~/pieast$ psql -U bloguser -d blog_prod -W
Password: 
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  password authentication failed for user "bloguser"

去掉特殊字符@ 修改密码验证成功

psql -U bloguser -d blog_prod -W
Password: 
psql (16.8 (Ubuntu 16.8-0ubuntu0.24.04.1))
Type "help" for help.

blog_prod=> \q