Using external Postgresql

[wonderhoss]

I'd like to run reitti on a server with a shared Postgresql database. I've chosen this approach to save on resources and simplify backup and DR, compared to running a separate postgres container with each service.

Is there any documentation on how to bootstrap the database for reitti?
Immich has a pretty comprehensive guide on how to install the required extensions and such.
I'd love to see something similar for reitti.

Thank you!

[dgraf-gh]

Hi @wonderhoss,

I mainly use the docker image of PostGIS so take this not as a definitive answer. What reitti needs is:

• postgres DB with the PostGis extension enabled. See here for instructions how to do this https://postgis.net/documentation/getting_started/
• a user to access this db

Here it is how it is created in the docker image.

create user reitti
    superuser
    createdb
    createrole
    replication
    bypassrls;

create database reittidb
    with owner reitti;

you propably could get away with:

create user reitti with passsword `reitti`;

create database reittidb
    with owner reitti;

there should be no need to give the reitti user superuser and the other roles. It will only need to be able to create tables.

I hope this helps. If not, feel free to come back here 🙂