Lemmy

12542 readers

51 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 4 years ago

MODERATORS

submitted 1 year ago by gabriele97@lemmy.g97.top to c/lemmy@lemmy.ml

3 comments fedilink hide all child comments

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

you are viewing a single comment's thread
view the rest of the comments

[–] dudeami0@lemmy.dudeami.win 4 points 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.