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: |