Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. OpenWebUI
  3. PostgreSQL support

PostgreSQL support

Scheduled Pinned Locked Moved OpenWebUI
4 Posts 2 Posters 752 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • LanhildL Offline
    LanhildL Offline
    Lanhild
    App Dev
    wrote on last edited by
    #1

    Hello @girish
    I've opened a PR to add PostgreSQL support for Open WebUI, since they've added it in v0.1.122.

    They don't have a migration guide from SQLite to PostgreSQL, but a kind contributor gave me a script to migrate it, it's in the PR.

    Feel free to take a look.

    1 Reply Last reply
    2
    • girishG Offline
      girishG Offline
      girish
      Staff
      wrote on last edited by
      #2

      @Lanhild awesome, thanks. Will take a look.

      1 Reply Last reply
      0
      • LanhildL Offline
        LanhildL Offline
        Lanhild
        App Dev
        wrote on last edited by
        #3

        @girish I updated my PR, it's ready for merging now.

        Any reason why the app is still marked as "Unstable" in the store? We have tests and the package seems to respect Cloudron's standards.

        I think it could be "Stable" after my PR.

        1 Reply Last reply
        0
        • girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by
          #4

          @Lanhild thanks, will check it out. Apps using sqlite cannot be considered stable until we figure a proper backup strategy. Cloudron's backup strategy is to copy files and this doesn't work well with databases in the data directory. The data can be inconsistent.

          Also, given no automatic migration from sqlite to postgres, we might have to publish a completely new package

          1 Reply Last reply
          1
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • Bookmarks
          • Search