diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2022-02-23 09:35:41 -0800 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2022-02-23 09:35:41 -0800 |
commit | 45464ab2a9ccc18b5440a531dc2e4fdf6508a342 (patch) | |
tree | e84bc29f2f04ab9eab5cffa085757984fd4048d7 /extra/sql_dumps | |
parent | a94b3cc03f3ba59191d6fa5343759ff01d594b93 (diff) | |
download | fatcat-45464ab2a9ccc18b5440a531dc2e4fdf6508a342.tar.gz fatcat-45464ab2a9ccc18b5440a531dc2e4fdf6508a342.zip |
sql dumps: use 'custom' mode instead of 'tar'
Diffstat (limited to 'extra/sql_dumps')
-rw-r--r-- | extra/sql_dumps/README.md | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/extra/sql_dumps/README.md b/extra/sql_dumps/README.md index 7ce59754..2c73fd20 100644 --- a/extra/sql_dumps/README.md +++ b/extra/sql_dumps/README.md @@ -96,9 +96,13 @@ This dump will contain all tables in the backend schema, except for "private" authentication tables. For local or non-production machines, might need to replace the `fatcat_prod` database name. +Note that prior to 2022, public dumps were in `--format=tar`, but this results +in many temporary files being written to disk, which causes unnecessarly load +on the server. + # TODO: for production, probably want consistent serialization mode export DATESLUG="`date +%Y-%m-%d.%H%M%S`" - sudo -u postgres pg_dump --verbose --format=tar --exclude-table-data=auth_oidc fatcat_prod | pigz > /srv/fatcat/snapshots/fatcat_public_dbdump_${DATESLUG}.tar.gz + sudo -u postgres pg_dump --verbose --format=custom --exclude-table-data=auth_oidc fatcat_prod > /srv/fatcat/snapshots/fatcat_public_dbdump_${DATESLUG}.pgdump Can also run using the remote/SSH options above. |