this post was submitted on 10 Aug 2023
1 points (100.0% liked)

Lemmy PostgreSQL

33 readers
2 users here now

founded 1 year ago
MODERATORS
[email protected]
[email protected]
1
Lemmy PostgreSQL backup pg_dump, compressed, excluded activity tables (bulletintree.com)
submitted 1 year ago by [email protected] to c/[email protected]
0 comments fedilink hide all child comments
 
# "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
no comments (yet)
sorted by: hot top controversial new old
there doesn't seem to be anything here