pg更改数据库用户密码的注意事项

最新推荐文章于 2025-11-17 01:39:36 发布

原创最新推荐文章于 2025-11-17 01:39:36 发布 · 2.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#pg 更改密码

PostgreSQL 专栏收录该内容

162 篇文章

订阅专栏

博客围绕PostgreSQL更改用户密码展开，展示了多次尝试修改用户'postgres9.6'密码为'highgo123'的过程，前几次使用不同语法均报错，最终使用'alter user \postgres9.6\ with password \'highgo123\';'成功修改。

postgres=# alter user postgres9.6 with password highgo123;
ERROR: syntax error at or near ".6"
LINE 1: alter user postgres9.6 with password highgo123;
                            ^
postgres=# alter user 'postgres9.6' with password highgo123;
ERROR: syntax error at or near "'postgres9.6'"
LINE 1: alter user 'postgres9.6' with password highgo123;
                   ^
postgres=# alter user "postgres9.6" with password highgo123;
ERROR: syntax error at or near "highgo123"
LINE 1: alter user "postgres9.6" with password highgo123;
                                               ^

postgres=# alter user 'postgres9.6' with password 'highgo123';
ERROR: syntax error at or near "'postgres9.6'"
LINE 1: alter user 'postgres9.6' with password 'highgo123';

# alter user postgres9.6 with password 'highgo123';
ERROR: syntax error at or near ".6"
LINE 1: alter user postgres9.6 with password 'highgo123';
^
Time: 0.366 ms

postgres=# alter user "postgres9.6" with password 'highgo123';
ALTER ROLE