dump_instance.sh and load_instance.sh scripts

Issue #65 - Prepare regression test covering database backup/restore

Issue #4 use database backup to restore HAF

The scripts save or load the haf database along with the hived state.

OPTIONS:
  --backup-dir=DIR                 Allows to specify where the dumps are located, required
  --hived-executable-path=PATH     Allows to specify where the main executable is located, required
  --hived-data-dir=DIR             Allows to specify where node data is located, required
  --haf-db-name=NAME               Allows to specify a name of database to store HAF data, required
  --haf-db-admin=NAME              Allows to specify a name of database admin role having permission to create the database
  --haf-db-host=VALUE              Allows to specify a PostgreSQL host location
  --haf-db-port=NUMBER             Allows to specify a PostgreSQL operating port
  --haf-db-jobs=NUMBER             Allows to specify how many processes are run during dump/restore
  --override-existing-backup-dir   Erases backup directory and its contents
  --help                           Display this help screen and exit

A note using Docker: hivemind SELECT * on hivemind_app view issues an error "could not resize shared memory segment" . Fixed by adding --shm-size=2gb to the docker run command.

src/hive_fork_manager/context_rewind/data_schema.sql

@@ -34,6 +34,7 @@ CREATE TABLE IF NOT EXISTS hive.contexts(
     CONSTRAINT pk_hive_contexts PRIMARY KEY( id ),
     CONSTRAINT uq_hive_context_name UNIQUE ( name )
 );
+SELECT pg_catalog.pg_extension_config_dump('hive.contexts', '');
 
 CREATE INDEX IF NOT EXISTS hive_contexts_owner_idx ON hive.contexts( owner );
 
@@ -49,6 +50,7 @@ CREATE TABLE IF NOT EXISTS hive.registered_tables(
    CONSTRAINT fk_hive_registered_tables_context FOREIGN KEY(context_id) REFERENCES hive.contexts( id ),
    CONSTRAINT uq_hive_registered_tables_register_table UNIQUE( origin_table_schema, origin_table_name )
 );
+SELECT pg_catalog.pg_extension_config_dump('hive.registered_tables', '');
 
 
 CREATE INDEX IF NOT EXISTS hive_registered_tables_context_idx ON hive.registered_tables( context_id );
@@ -64,6 +66,7 @@ CREATE TABLE IF NOT EXISTS hive.triggers(
    CONSTRAINT fk_hive_triggers_registered_table FOREIGN KEY( registered_table_id ) REFERENCES hive.registered_tables( id ),
    CONSTRAINT uq_hive_triggers_registered_table UNIQUE( trigger_name )
 );
+SELECT pg_catalog.pg_extension_config_dump('hive.triggers', '');
 
 CREATE INDEX IF NOT EXISTS hive_registered_triggers_table_id ON hive.triggers( registered_table_id );
 CREATE INDEX IF NOT EXISTS hive_triggers_owner_idx ON hive.triggers( owner );