Lemmy PostgreSQL
RoundSparrow
•
1y ago
•
100%
Lemmy PostgreSQL backup pg_dump, compressed, excluded activity tables
# "this is the most flexible output format in that it allows manual selection and reordering of archived items during restore. This format is also compressed by default."
sudo -iu postgres pg_dump --format=custom --compress=5 \
--exclude-table-data "*.received_activity" \
--exclude-table-data "*.sent_activity" \
lemmy > 2023-08-10_backup_compress_1.dump
Comments 0