How to configure custom DB port in docker-compose.yaml of haystack annotation tool ?

[rajkumarvenkatasamy]

I have a postgresql backend which runs on a non-default port in a different machine than that of where haystack annotation is targeted to run. How to configure or specify that database details especially the non-default port in the docker-compose.yaml ? I just tried with random env variable options like DB_PORT, POSTGRES_PORT, and PG_PORT but none of them worked. Please clarify on how to handle this scenario.

Thanks for your time and input!

[julian-risch]

Hi @rajkumarvenkatasamy the port is specified in the following line in the docker-compose.yml file: https://github.com/deepset-ai/haystack/blob/b1daa7c6473aaaf4e09d0c8122f0abcc5554e0d3/annotation_tool/docker-compose.yml#L33C15-L33C19
The postgres default port 5432 is specified there but that's all what's exposed. I am not aware of a way to change the port where the annotation tool expects postgres. With port mapping, you should be able to map your host’s port where postgres is running to port 5432 inside the annotation tool container: https://docs.docker.com/network/#published-ports

[rajkumarvenkatasamy]

Hi @julian-risch Thanks for getting back.

The docker-compose file indicated is not applicable for the case that I presented. I have a postgres instance running separately in a different machine and managed separately (not through the docker-compose referred in the link). There should be a way to specify the external postgres connection parameters somehow for haystack annotation service to connect and it will be helpful to capture that in the documentation (if that is already supported). If such feature is not available, then it is good to have that considered as an improvement.

Thanks!