postgresql - psycopg2.OperationalError 致命 : role "ubuntu" does not exist

Question

我在 Windows 上，我安装了 ubuntu 终端，这就是我正在做的事情:
https://medium.com/@ryanroline/installing-apache-airflow-on-windows-10-5247aa1249ef
当我运行 airflow initdb我收到此错误:

Traceback (most recent call last):
  File "/usr/local/bin/airflow", line 37, in <module>
    ...
  File "/home/lucas/.local/lib/python3.8/site-packages/psycopg2/__init__.py", line 127, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL:  role "ubuntu" does not exist

但我确实创建了配置文件并分配了正确的权限:

CREATE ROLE ubuntu;
CREATE DATABASE airflow;
GRANT ALL PRIVILEGES on database airflow to ubuntu;
ALTER ROLE ubuntu SUPERUSER;
ALTER ROLE ubuntu CREATEDB; 
ALTER ROLE ubuntu LOGIN;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public to ubuntu;

我不知道为什么它不断收到此错误。

Answer 1

我修复了它，在 postgres 配置中我有端口 5433，在 Airflow 配置中我有 5432。