diff options
| -rw-r--r-- | sql/README.md | 7 |
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 + |