Ingesting a Public Content Release

Prerequisites:

• Postgres 9.2+
• Public Content Release tar
  • provided on the releases, DATE_VER_database.tar.gz
• basic command line capabilities

1. untar the Public Content Release

tar xzvf YYYY-MM-DD_GCIS_vX.Y.Z_database.tar.gz
x YYYY-MM-DD_GCIS_vX.Y.Z_database_contents_1.dump
x YYYY-MM-DD_GCIS_vX.Y.Z_database_contents_2.dump
x YYYY-MM-DD_GCIS_vX.Y.Z_database_schema.dump

2. create the user 'gcisops'*

$ createuser -s -r -d gcisops

3. create the database 'gcis', load the schema, load the report_types, load the main content

# CREATE DATABASE gcis OWNER gcisops;
# \i YYYY-MM-DD_GCIS_vX.Y.Z_database_schema.dump
# \i YYYY-MM-DD_GCIS_vX.Y.Z_database_contents_1.dump
# \i YYYY-MM-DD_GCIS_vX.Y.Z_database_contents_2.dump

---

* If you would like to use a different user than 'gcisops', use that name instead & replace all instances of 'gcisops' with your preferred username in the SQL dumps.