From cd170867d7ff34b183de740f030c2e29618c0fed Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 28 Oct 2020 15:21:41 -0400 Subject: [PATCH] LP1901932 making some notes Signed-off-by: Bill Erickson --- NOTES | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 NOTES diff --git a/NOTES b/NOTES new file mode 100644 index 0000000000..93b7273303 --- /dev/null +++ b/NOTES @@ -0,0 +1,13 @@ + +# one option. would this db DB version dependent? + +# dump data and schema from an EG database, tagged with SQL stamp +pg_dump -U evergreen --format custom --file /tmp/evergreen-concerto-master.1241.archive evergreen + +# Create EG database without the schema +sudo perl Open-ILS/src/support-scripts/eg_db_config --create-database --user evergreen --password evergreen --hostname localhost --database evergreen + +# Restore data and schema from archive +pg_restore --clean --if-exists -U evergreen --dbname evergreen /tmp/evergreen-concerto-master.1241.archive + + -- 2.11.0