Software – Hub Database

Now we have a working database server, we can create and populate the hub database itself.

This is the first of a number of commands that use wget to download files from the project repository.

cd ~
psql -h localhost -U postgres -d postgres -f hub-skeleton.sql

After confirming your postgres password you should have a hub database containing 16 tables (some populated with basic data), plus a number of supporting views and functions.  We will examine this schema in the next post.