aboutsummaryrefslogtreecommitdiffstats
path: root/extra/sql_dumps
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2021-06-17 16:28:51 -0700
committerBryan Newbold <bnewbold@robocracy.org>2021-06-17 16:28:51 -0700
commit6b3aa0de4e7e2e7673c541ab2017c03273418b11 (patch)
tree4b43ae2f1bbaf987ff8db8655b40cb0ceaa5155f /extra/sql_dumps
parentb3d019f10277e9b532e13bb85dca38c593b14380 (diff)
downloadfatcat-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.md4
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: