elt_script-1 | Error connecting to PostgreSQL: Command '['pg_isready', '-h', 'source_postgres']' returned non-zero exit status 2.

[mdeshon82]

I am getting error below and can not figure out why it can not connect after attempting to apply the database dump

-1 | -- elt_script-1 | ALTER TABLE ONLY public.film_category elt_script-1 | ADD CONSTRAINT film_category_film_id_fkey FOREIGN KEY (film_id) REFERENCES public.films(film_id); elt_script-1 | ALTER TABLE elt_script-1 | -- elt_script-1 | -- PostgreSQL database dump complete elt_script-1 | -- elt_script-1 | Error connecting to PostgreSQL: Command '['pg_isready', '-h', 'source_postgres']' returned non-zero exit status 2. elt_script-1 | Retrying in 5 seconds... (Attempt 1/5) elt_script-1 | Successfully connected to PostgreSQL! elt_script-1 | Starting ELT script... elt_script-1 | Ending ELT script... elt_script-1 exited with code 0

[ValantisChatzimagkas]

@mdeshon82 Hello, I had the same error, and for me what worked is that I went in the docker-compose.yaml and changed:

Change 1: services: source_postgres: image: postgres:latest I changed it to image: postgres:15.7

Change 2 (not sure if needed) In the Dockerfile I changed this: RUN apt-get update && apt-get install -y postgresql-client ---> RUN apt-get update && apt-get install -y postgresql-client-15

I hope it works and that I did not make it work by luck

[bglid]

@ValantisChatzimagkas Your workaround, along with changing '-u' to '-U' in both the dump_command and load_command, fixed this problem for me. I also did both of the changes you listed. Thanks!

[ValantisChatzimagkas]

@bglid great! I am glad it helped