Title: [213548] trunk/Websites/perf.webkit.org
- Revision
- 213548
- Author
- [email protected]
- Date
- 2017-03-07 15:21:49 -0800 (Tue, 07 Mar 2017)
Log Message
Update ReadMe.md to use directory format for backing up & restoring the database
https://bugs.webkit.org/show_bug.cgi?id=169263
Reviewed by Joseph Pecoraro.
Update ReadMe.md's instruction to backup and restore the database to use directory format instead of
piping it to gzip. The new command will backup and restore the database with multiple concurrent processes
with a custom compression level.
* ReadMe.md:
Modified Paths
Diff
Modified: trunk/Websites/perf.webkit.org/ChangeLog (213547 => 213548)
--- trunk/Websites/perf.webkit.org/ChangeLog 2017-03-07 23:12:34 UTC (rev 213547)
+++ trunk/Websites/perf.webkit.org/ChangeLog 2017-03-07 23:21:49 UTC (rev 213548)
@@ -1,3 +1,16 @@
+2017-03-07 Ryosuke Niwa <[email protected]>
+
+ Update ReadMe.md to use directory format for backing up & restoring the database
+ https://bugs.webkit.org/show_bug.cgi?id=169263
+
+ Reviewed by Joseph Pecoraro.
+
+ Update ReadMe.md's instruction to backup and restore the database to use directory format instead of
+ piping it to gzip. The new command will backup and restore the database with multiple concurrent processes
+ with a custom compression level.
+
+ * ReadMe.md:
+
2017-03-02 Ryosuke Niwa <[email protected]>
Make baseline data points selectable
Modified: trunk/Websites/perf.webkit.org/ReadMe.md (213547 => 213548)
--- trunk/Websites/perf.webkit.org/ReadMe.md 2017-03-07 23:12:34 UTC (rev 213547)
+++ trunk/Websites/perf.webkit.org/ReadMe.md 2017-03-07 23:21:49 UTC (rev 213548)
@@ -123,9 +123,14 @@
### Making a Backup and Restoring
-- Backing up the database: `/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h localhost --no-owner -f <filepath> webkit-perf-db | gzip > backup.gz`
-- Restoring the database: `gunzip -c backup.gz | /Applications/Server.app/Contents/ServerRoot/usr/bin/psql webkit-perf-db -h localhost --username webkit-perf-db-user`
+Use `pg_dump` and `pg_restore` to backup and restore the database. If you're replicating the production database for development purposes, you may consider excluding `run_iterations` table, which takes up 2/3 of the storage space, to reduce the size of the database for your local copy. Adjust the number of concurrent processes to use by `--jobs` and adjust the compression level by `--compress` (0 is no compression, 9 is most compressed).
+- Making the fullbackup of the database: `/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h localhost webkit-perf-db --format=directory --file=<path to backup directory> --jobs=4 --no-owner --compress=7`
+
+- Making an abridged backup without `run_iterations` table: `/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h localhost webkit-perf-db --format=directory --file=<path to backup directory> --jobs=4 --no-owner --compress=7 --exclude-table=run_iterations`
+
+- Restoring the database: `/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_restore --format=directory --jobs=4 --no-owner --host localhost --username=webkit-perf-db-user <path to backup directory> --dbname=webkit-perf-db`
+
## Concepts
- **Test** - A test is a collection of metrics such as frame rate and malloced bytes. It can have a children and a parent and form a tree of tests.
_______________________________________________
webkit-changes mailing list
[email protected]
https://lists.webkit.org/mailman/listinfo/webkit-changes
