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. SnappyMail
  3. How to set Postgres as the default db ?

How to set Postgres as the default db ?

Scheduled Pinned Locked Moved Solved SnappyMail
4 Posts 3 Posters 644 Views 3 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.
  • S Offline
    S Offline
    shrey
    wrote on last edited by
    #1

    Currently, the default db is SQLite

    f678ca04-00e2-406e-b5dd-5d5654cf79bd-image.png

    I would like to change that to Postgres.

    Simply selecting the Postgres option didn't work:
    8e6d5054-9a4a-456e-bf5e-2c55705f1157-image.png

    1 Reply Last reply
    1
    • nebulonN Away
      nebulonN Away
      nebulon
      Staff
      wrote on last edited by
      #2

      For postgres to work, the app package needs to enable the postgres addon first, however this also means that on update, the apps will lose all their data. Generally sqlite is quite efficient these days, so unless there is a strong reason to switch database, its probably better to stick with sqlite.

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

        Note that mails itself and the state are stored in the mail server and not in snappymail. The snappymail db only contains very basic stuff. Sqlite will work just fine.

        1 Reply Last reply
        2
        • S Offline
          S Offline
          shrey
          wrote on last edited by
          #4

          @nebulon @girish
          Thanks for the details!

          1 Reply Last reply
          1
          • S shrey has marked this topic as solved on
          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