I installed FME Server on my Mac using Docker...running using docker-compose. I am wondering if I can connect to the Postgresql database external to the docker image from my Mac. Just interested in using it while testing, but not sure which port/user/pw to use. I couldn't tell this information from the docker-compose file. Any help would be appreciated.
Question
How to Connect to FME Server Postgres DB Running in Docker
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi @tacreeodot,
I am not 100% sure if I understand the role of the DB here, but in case you want to use the PostgreSQL as FME Server DB instead of the default DB coming with the compose deployment, you can switch to a different DB with some environment variables:
https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Container-Environment-Variables.htm
If the PostgreSQL runs on your Mac, so on the same host as Docker for Mac, you might have to access the DB via:
host.docker.internalThe port would be whichever port the DB is using (e.g 5432). Take a look at these Use cases and workarounds for more details.
If the DB is running on a different host within your network just use the hostname/port you usually use to connect to the DB.
I hope this helps!