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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

How to set Postgres as the default db ?

Scheduled Pinned Locked Moved Solved SnappyMail
4 Posts 3 Posters 24 Views
    • 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 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 Online
    nebulonN Online
    nebulon Staff
    wrote 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 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 last edited by
    #4

    @nebulon @girish
    Thanks for the details!

    1 Reply Last reply
    1
  • S shrey has marked this topic as solved

  • Login

  • Don't have an account? Register

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

  • Don't have an account? Register

  • Login or register to search.