password authentication failed for user "postgres" in lightdash

Question

I'm trying to create a new Lightdash project. I used the Lightdash CLI to set up the project locally. After configuring the PostgreSQL and dbt connections, I was able to successfully test and compile the setup. However, when I attempt to run a query, I encounter the following error:

Password authentication failed for user 'postgres'.