postgresql - postgres 生成的与 os 用户名匹配的用户的密码是什么？

Question

我是 Postgres 的新手。

Postgres 在安装时会生成两个用户，一个是'postgres'，另一个匹配你的操作系统用户名。

Getting Started with PostgreSQL on Mac OSX #3-configuring-postgres :

We see the Postgres user I mentioned, but what is that other user, engineerapart? This is one of the things Postgres does to make your life easier when you first install it...So when Postgres is installed, it automatically creates a database user that matches your username, so that you can get started right away.

但是与os用户名匹配的用户的密码是什么？

我的操作系统用户名是'zhouhancheng'，我经常卡在这个错误:

failed: FATAL:  password authentication failed for user "zhouhancheng"

宏:10.13postgresql: 11.2

Answer 1

从 10.6 版本开始，PostgreSQL 不会默认为 os 用户名创建密码。
检查你的pg_hba.conf并允许无密码访问。
您可以使用以下设置允许从本地主机进行无密码访问。

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust  

或者，当您使用 initdb 初始化数据库集群时，您可以为 os 用户名指定密码。

-W
--pwprompt
Makes initdb prompt for a password to give the database superuser. If you don't plan on using password authentication, this is not important. Otherwise you won't be able to use password authentication until you have a password set up.

(我认为 initdb 在你的情况下是由 brew 执行的)