I am trying to set up Postgres destination in my Airbyte locally. I keep getting the following error:

Configuration check failed
Failed to run connection tests.

Airbyte and postgres are set up in docker containers.

Based on the information provided in the extracts, here are the steps to set up a Postgres destination in Airbyte: 1. Start a Postgres container using Docker. Here's an example command:

bash docker run --rm --name postgres-destination -e POSTGRES_PASSWORD=password -p 3000:5432 -d postgres:13

This command will start a Postgres container with the name

postgres-destination

, set the password to

password

, expose the container's port 5432 as your machine's port 3000, and run the container in the background ([source](https://airbyte.com/tutorials/replicate-from-ibm-db2-to-postgres)). 2. Verify that the Postgres container is running. You can do this by opening a shell to the Postgres container and confirming that PostgreSQL is running using the psql shell within the container:

bash docker exec -it postgres-destination /bin/bash psql -U postgres

Enter Ctrl+D to exit the psql shell ([source](https://airbyte.com/tutorials/replicate-from-ibm-db2-to-postgres)). 3. In the Airbyte dashboard, add a new destination. Enter the name and choose Postgres as the destination type. Fill in the login credentials using the information you specified when the Postgres container was started ([source](https://airbyte.com/tutorials/implement-machine-learning-for-your-shopify-store-with-mindsdb)). If you're still encountering the error, it might be due to some limitations or issues with the Postgres connector. You can refer to the [Postgres troubleshooting guide](https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting) for more information ([source](https://docs.airbyte.com/integrations/sources/postgres/cloud-sql-postgres)).