@[email protected] to [email protected]English • 1 year agoHow to backup the DB before upgrading Lemmy?message-square3fedilinkarrow-up110arrow-down12file-text
arrow-up18arrow-down1message-squareHow to backup the DB before upgrading Lemmy?@[email protected] to [email protected]English • 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-squaredudeami0linkfedilinkEnglish3•1 year agoTo dump a simple postgresql database, you can do something like: pg_dump postgresql://lemmy:[email protected]/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.