[GH-ISSUE #1118] Changing postgresql schema #6326

Closed
opened 2026-04-20 16:54:32 -05:00 by GiteaMirror · 2 comments
Owner

Originally created by @a2xzy on GitHub (Jul 14, 2025).
Original GitHub issue: https://github.com/go-vikunja/vikunja/issues/1118

Description

Hello,

I am trying to access a different postgres schema than public by setting the env variable VIKUNJA_DATABASE_SCHEMA as per this commit : 28d5cd7b28

And it seems that it is just being ignored :

Migration failed: pq: permission denied for schema public

Excerpt of the env var I set :

- name: VIKUNJA_DATABASE_SCHEMA
  value: vikunja

I am running Vikunja on k8s with the latest image available 0.24.6.

I am missing something obvious ?

P.S. : If this works (or is supposed to work) and I messed it up it is missing from the docs : https://vikunja.io/docs/config-options/#0--database

Thanks

Vikunja Version

0.24.6

Browser and version

No response

Can you reproduce the bug on the Vikunja demo site?

No

Screenshots

No response

Originally created by @a2xzy on GitHub (Jul 14, 2025). Original GitHub issue: https://github.com/go-vikunja/vikunja/issues/1118 ### Description Hello, I am trying to access a different postgres schema than `public` by setting the env variable `VIKUNJA_DATABASE_SCHEMA` as per this commit : https://github.com/go-vikunja/vikunja/commit/28d5cd7b287c75508f01af35a1fa361dfa67f6c4 And it seems that it is just being ignored : ``` Migration failed: pq: permission denied for schema public ``` Excerpt of the env var I set : ``` - name: VIKUNJA_DATABASE_SCHEMA value: vikunja ``` I am running Vikunja on k8s with the latest image available `0.24.6`. I am missing something obvious ? P.S. : If this works (or is supposed to work) and I messed it up it is missing from the docs : https://vikunja.io/docs/config-options/#0--database Thanks ### Vikunja Version 0.24.6 ### Browser and version _No response_ ### Can you reproduce the bug on the Vikunja demo site? No ### Screenshots _No response_
Author
Owner

@a2xzy commented on GitHub (Jul 14, 2025):

This change is not in 0.24.6, using the unstable tag makes it work.

@kolaente Will this be included in the next release and do you have any idea when it will happen ?

Thanks!

<!-- gh-comment-id:3068745957 --> @a2xzy commented on GitHub (Jul 14, 2025): This change is not in `0.24.6`, using the `unstable` tag makes it work. @kolaente Will this be included in the next release and do you have any idea when it will happen ? Thanks!
Author
Owner

@kolaente commented on GitHub (Jul 14, 2025):

It will be included in the next release, until then you'll need to use the unstable build.

<!-- gh-comment-id:3069106284 --> @kolaente commented on GitHub (Jul 14, 2025): It will be included in the next release, until then you'll need to use the unstable build.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/vikunja#6326