diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2021-06-17 16:28:51 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2021-06-17 16:28:51 -0700 |
commit | 6b3aa0de4e7e2e7673c541ab2017c03273418b11 (patch) | |
tree | 4b43ae2f1bbaf987ff8db8655b40cb0ceaa5155f /extra/sql_dumps | |
parent | b3d019f10277e9b532e13bb85dca38c593b14380 (diff) | |
download | fatcat-6b3aa0de4e7e2e7673c541ab2017c03273418b11.tar.gz fatcat-6b3aa0de4e7e2e7673c541ab2017c03273418b11.zip |
SQL dumps: more pigz (vs. gzip) for speed
Diffstat (limited to 'extra/sql_dumps')
-rw-r--r-- | extra/sql_dumps/README.md | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/extra/sql_dumps/README.md b/extra/sql_dumps/README.md index 9d8cffc9..8c1b5239 100644 --- a/extra/sql_dumps/README.md +++ b/extra/sql_dumps/README.md @@ -50,10 +50,10 @@ couple different ways. We might not want database ports open to the network forwarding anyways. # Locally, or client running on a remote machine - psql fatcat < dump_abstracts.sql | egrep -v ^BEGIN$ | egrep -v ^ROLLBACK$ | pv -l | gzip > abstracts.json.gz + psql fatcat < dump_abstracts.sql | egrep -v ^BEGIN$ | egrep -v ^ROLLBACK$ | pv -l | pigz > abstracts.json.gz # Run on database server, write to file on remote host - psql fatcat < dump_abstracts.sql | egrep -v ^BEGIN$ | egrep -v ^ROLLBACK$ | pv -l | gzip | ssh user@host 'cat > abstracts.json.gz' + psql fatcat < dump_abstracts.sql | egrep -v ^BEGIN$ | egrep -v ^ROLLBACK$ | pv -l | pigz | ssh user@host 'cat > abstracts.json.gz' In production: |