Hi, Do you have any suggestions on how to backup the database or any other suggestions before upgrading Lemmy?

  • dudeami0@lemmy.dudeami.win
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 year ago

    To dump a simple postgresql database, you can do something like:

    pg_dump postgresql://lemmy:mypassword@example.com/lemmy -f backup.sql
    

    This should result in a file being made named backup.sql for your database.

    As for upgrading, my small instance with a 1.5Gb database upgraded with no issues using the docker images on kubernetes.