gabriele97@lemmy.g97.top to Lemmy@lemmy.mlEnglish · 1 year agoHow to backup the DB before upgrading Lemmy?message-squaremessage-square3fedilinkarrow-up17arrow-down11file-text
arrow-up16arrow-down1message-squareHow to backup the DB before upgrading Lemmy?gabriele97@lemmy.g97.top to Lemmy@lemmy.mlEnglish · 1 year agomessage-square3fedilinkfile-text
Hi, Do you have any suggestions on how to backup the database or any other suggestions before upgrading Lemmy?
minus-squaredudeami0@lemmy.dudeami.winlinkfedilinkEnglisharrow-up3·1 year agoTo 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.
To dump a simple postgresql database, you can do something like:
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.