Connection to an external database

[devopsnot]

I need to be using an external database for my nomimatim, I need help with what I need to be added to my docker-compose to be connecting to a database;

docker-compose

nominatim:
container_name: nominatim
image: mediagis/nominatim:4.2
restart: always
networks:
nominatim:
aliases:
- nominatim.localhost
environment:
- PBF_PATH=/var/lib/geofabrik/brazil-latest.osm.pbf
- REPLICATION_URL=https://download.geofabrik.de/south-america/brazil-updates/
- NOMINATIM_PASSWORD=nominatim123
volumes:
- /var/lib/geofabrik:/var/lib/geofabrik:ro
- /var/lib/nominatim:/nominatim/flatnode
- /var/lib/pgsql-nominatim:/var/lib/postgresql/14/main
shm_size: 16gb

[leonardehrenfried]

I would like to point out that this is not a big so I remove the label.

A user has documented how to use an external db here:
#245 (comment)

Once you've figured out how to convert this to docker-compose syntax, please post it here so it will be documentation for others.

[dsperling]

@devopsnot - There is a Docker Nominatim project we have started that might be of interest. n7m is a Numeronym for Nominatim. The project supports connecting the Nominatin App to a Postgres database running in a different container. Take a look at the docker-compose.yml at the root.

In the app & feed service of the compose file above, you can reference a different database using PGHOST like this:

...
  app:
    build: app
    image: smithmicro/n7m-app
    environment:
      - PGHOST=<hostname or ip adddress>
      - PGUSER=postgres
      - PGPASSWORD=n7m-geocoding
    depends_on:
      - gis
    mem_limit: 200m
  feed:
    image: smithmicro/n7m-app
    depends_on:
      - gis
    environment:
      - PGHOST=<hostname or ip adddress>
      - PGUSER=postgres
      - PGPASSWORD=n7m-geocoding
      - OSM_FILENAME=brazil-latest.osm.pbf
    command: setup
    volumes:
      - ${PWD}/data:/data/
...

Note: expect significantly slower imports if the Postgres container is running on a different host.