aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2020-01-28 19:09:54 -0800
committerBryan Newbold <bnewbold@archive.org>2020-01-28 19:10:40 -0800
commit46171ed3a86e90d8c519a8ce94f379309936fbeb (patch)
tree81d29119d96df160b277a835111f6f512ecad655 /sql
parent6448a4bb41cd9301bc5c6c7ea0bd8b12c2423e39 (diff)
downloadsandcrawler-46171ed3a86e90d8c519a8ce94f379309936fbeb.tar.gz
sandcrawler-46171ed3a86e90d8c519a8ce94f379309936fbeb.zip
sql howto: database dumps
Diffstat (limited to 'sql')
-rw-r--r--sql/README.md7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/README.md b/sql/README.md
index 38052fd..d3e838c 100644
--- a/sql/README.md
+++ b/sql/README.md
@@ -171,3 +171,10 @@ Can also do some quick lookups for a specific domain and protocol like:
WHERE terminal_url LIKE 'https://insights.ovid.com/%'
LIMIT 10;
+## Full Database Dumps
+
+Run a dump in compressed, postgres custom format:
+
+ export DATESLUG="`date +%Y-%m-%d.%H%M%S`"
+ time sudo -u postgres pg_dump --verbose --format=custom sandcrawler > /sandcrawler-db/snapshots/sandcrawler_full_dbdump_${DATESLUG}.pgdump
+