Gallery database location

[Roger963]

Again in this great community.
I want to know in which postgres table are the survey photos stored?

[Kal_Lam]

Maybe this post discussed previously should help you solve your issue:

KoboTool Box Database storage path on self hosted server

Hi @zeeshu96, You can activate backups with kobo-install when you choose to use advanced options. Otherwise, the data is located in kobo-docker/.vols . db is for PostgreSQL mongo is for MongoDB (obviously) redis_main is for redis If you already have activated backups with kobo-install. You should find files in kobo-docker/backup. Once again, you should see 4 folders kobocat contains users’ file (if you use local storage) mongo, postgres, redis are database backups location respective…

[nolive]

@Roger963 The attachments, themselves, are not stored in the database. They are stored on the drive of your server. You can look at kobo-docker/.vols/kobocat_media_uploads .
Otherwise, the path to these files are stored in the logger_attachments table in kobocat database.