Connecting to postgres metadata table locally when using astro


I have been following this trying to connect to the PostgreSQL metadata table.

Specifically when I run the psql command locally to connect:

psql -h localhost -U postgres -p 5432

I get the following error – any idea why this happens?

psql: error: could not connect to server: FATAL: role "postgres" does not exist

I tried to recreate the issue but couldn’t. Can you share your astro cli version?
Are you trying to run this from inside the docker container or from your local machine?