External database gets recreated upon pod restart
lucasmaj opened this issue · 5 comments
Trying to use external db via NOMINATIM_DATABASE_DSN env variables. However it appears that db is dropped and recreated upon every restart of nominatim container. Obviously it defeats the purpose. Please advise.
Looks like /var/lib/postgresql/14/main/import-finished must be persisted between restarts.
Does it mean that even when using external postrgre db we still need to fuss around with persistent volumes for /var/lib/postgresql/14/main ?
Unfortunately, there is no advice to give. What you're doing just happens to work but it's actually not something that the core contributors use and therefore it's unsupported.
Thank you for clarifying. I was coming with k8s bias where workers are easily disposable and managing stateful disks attached to particular nodes seems anti-pattern. Your answer made me realize the intended purpose is most likely a full VM with attached disks.
Thank you.
Indeed. We are aware that our setup is not adhering to principles of more complex deployments but we value the ease of setup and operation over pretty much anything else.
Maybe https://github.com/smithmicro/n7m meets your requirements.
Good insights. Thanks again!