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
    4
    ·
    1 year ago

    To 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.

  • Ruud@lemmy.world
    link
    fedilink
    English
    arrow-up
    1
    ·
    edit-2
    1 year ago

    Either do a pg_dump or stop the database and make a full copy.

    The pg_dump won’t require downtime but will take longer to restore.

    I use this command for the pg_dump

    docker exec lemmy_postgres_1 pg_dump -Fc -U lemmy lemmy > /opt/lemmy/backup/lemmy_db_`date +%Y%m%d`.dump
    
  • fuser@quex.cc
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    you can run something like this on the host - make sure you use the correct container name

    #!/bin/bash
    # check the container name with docker ps first
    container_name="instance_name_postgres_1"
    
    echo "dumping pgsql"
    # Backup command
    docker exec -t "${container_name}" pg_dumpall -c -U lemmy > lemmy_dump.sql
    

    suggest you not leave unencrypted backup on the host system but copy it somewhere else, preferably after encrypting it with gpg.