Is-it possible to get access to the Airbyte's PostgreSQL instance when using acbtl ?

Yes, it is possible to access Airbyte's PostgreSQL instance. If you are using the default

airbyte-db

Postgres database, you can access the data that tracks jobs with the following command:

bash docker exec -ti airbyte-db psql -U docker -d airbyte

The credentials for the database are specified in the

.env

file that is used to run Airbyte. By default, the values are:

bash DATABASE_USER=docker   DATABASE_PASSWORD=docker   DATABASE_DB=airbyte

If you have overridden these defaults, you will need to substitute them in the instructions above. Please note that this method is for extraordinary circumstances. For regular operations, it's recommended to interact with the database via the Export and Import functionalities of this database via the API or the UI. For more details, you can refer to the [official documentation](https://docs.airbyte.com/operator-guides/configuring-airbyte-db#accessing-the-default-database-located-in-docker-airbyte-db).

@kapa.ai it seems this answer was helpful when using docker-compose, isn't-it ?

Yes, the information provided in the knowledge sources is indeed helpful when using docker-compose with Airbyte. It covers various aspects such as: - Setting up and configuring Airbyte using Docker Compose. This includes modifying the bundled

.env

file and ensuring applications get the correct variables from the

docker-compose.yaml

file. [source](https://docs.airbyte.com/operator-guides/configuring-airbyte) - Instructions on how to use Docker Compose to bootstrap a modern data stack. This involves using a shell script to start and stop instances and making necessary customizations in the compose files. [source](https://airbyte.com/tutorials/modern-data-stack-docker#step-2) - Steps to install and launch Airflow using Docker Compose, which includes creating necessary directories, downloading the Docker Compose file for Airflow, and building the Docker image. [source](https://airbyte.com/tutorials/how-to-use-airflow-and-airbyte-together) - Instructions on setting up Airbyte OpenTelemetry Integration using Docker Compose. This involves deploying an OpenTelemetry Collector, updating Docker Compose configuration, setting environment variables, and re-deploying Airbyte. [source](https://docs.airbyte.com/operator-guides/collecting-metrics#airbyte-opentelemetry-integration) Please note that the specific steps and code snippets would depend on your exact use case and requirements.

@kapa.ai My original question was about abctl, it does not concern docker-compose ? May you update your answer ?

A message from kapa.ai

I apologize for the confusion. You're right, the information provided in the knowledge sources is indeed about

abctl

, not Docker Compose. Here are some key points about

abctl

from the knowledge sources: -

abctl

is the new local deployment tool for Airbyte, designed to deploy Airbyte locally using Kubernetes with minimal onboarding friction. It allows users to test what a production deployment would look like without needing to provide their own Kubernetes cluster. [source](https://github.com/airbytehq/airbyte/discussions/40599) - Docker Compose is deprecated and users are encouraged to migrate to

abctl

. [source](https://github.com/airbytehq/airbyte/discussions/40599) - If you want to bring an instance of Airbyte running on your laptop up and down, you can stop the Docker container using the command

docker stop airbyte-abctl-control-plane

. [source](https://github.com/airbytehq/airbyte/discussions/46538) - If you're trying to use

abctl

on a server with no internet access, you can read the Kind docs about side-loading images into the container. [source](https://github.com/airbytehq/airbyte/discussions/45661) - If you're facing issues after migrating from Docker Compose to

abctl

, the Airbyte team is working on better materials for running Sources and Destinations in Docker while using

abctl

. [source](https://github.com/airbytehq/airbyte/issues/45381) Please note that the specific steps and commands would depend on your exact use case and requirements.