How to use a postgresql database for grampsweb?

Ok, so first of all: great stuff! Never thought doing a bit of history into my forefathers would be so much fun :slight_smile:

That said, I reaaallly want to have my database reside in my central PostgreSQL database, and I reaaaally want to use grampsweb across different machines, and I simply cannot get it to work.

I have trouble telling the grampsweb that I want my tree in a database. The search database and user database seem to work, but I am confused by how I’m supposed to use a postgresql database for the tree itself.

The docs tell me to use POSTGRES_USER and POSTGRES_PASSWORD but strangely doesn’t seem to talk about POSTGRES_HOST and POSTGRES_PORT. Those parameters do seem to be present in the config.py file in the gramps-web-api repo, but whatever variables I provide to the container as environment variables or in config.cfg, grampsweb keeps using the sqlite database.

Am I missing something? What’s the trick here? :confused:

I am in the process of setting up Gramps/Gramps Web and Postgresql on my own system. I am following this thread and will comment as I find stuff out.

1 Like

I am using the latest container image, resulting in:

Gramps 5.2.4
Gramps Web API 2.8.2
Gramps Web Frontend 25.3.1
Gramps QL 0.3.0
Sifts 1.0.0
locale: en
multi-tree: false
task queue: false
OCR: true
chat: false

Database is PostgreSQL 15

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.