Connecting to postgres metadata table locally when using astro

jped · December 20, 2021, 5:05pm

Hey,

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

bhavaniravi · January 4, 2022, 8:35am

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?

Topic		Replies	Views
Having an issue with ports when starting up astrocloud Astro CLI	1	3266	May 31, 2022
Astro dev start failure - waiting on database Astro CLI cli , astro-cli , astro	1	38	October 10, 2024
Unable to set-up an external database backend for Airflow Astro CLI	2	2515	October 31, 2022
How can I connect using a script from docker-container to a database on the local host (not in docker containers) Astronomer connections , docker , airflow	1	1314	October 25, 2023
How do I set my postgres username and password to access the ad hoc query feature locally? Astro CLI	2	5602	April 4, 2019

Connecting to postgres metadata table locally when using astro

Related topics