Does anyone by chance know how to set up Dockerfile and docker-compose.yml to connect Aiven to Airflow? I’ve been struggling for 6 hours now :<
Keep getting
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for schema public
error when trying build the docker image.
Dockerfile looks like this:
FROM apache/airflow:2.10.5
USER root
RUN apt-get update
&& apt-get install -y --no-install-recommends
vim
&& apt-get autoremove -yqq --purge
&& apt-get clean
&& rm -rf /var/lib/apt/lists/*
USER airflow
RUN airflow db init
and i have this service in docker-compose:
airflow-webserver:
<<: *airflow-common
command: webserver
ports:
- “8080:8080”
restart: always
depends_on:
<<: *airflow-common-depends-on
airflow-init:
condition: service_completed_successfully
and environment is set up like this:
x-airflow-common:
&airflow-common
image: ${AIRFLOW_IMAGE_NAME:-apache/airflow:2.10.5}build: .
environment:
&airflow-common-env
AIRFLOW__CORE__EXECUTOR: CeleryExecutor
AIRFLOW__DATABASE__SQL_ALCHEMY_CONN: postgresql+psycopg2://user:pass@solarmew-service-solarmew.f.aivencloud.com:10877/airflow_db
AIRFLOW__CELERY__RESULT_BACKEND: db+postgresql://user:pass@solarmew-service-solarmew.f.aivencloud.com:10877/airflow_db