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 ~ wget http://warrensoft.co.uk/home-hub/database/scripts/hub-skeleton.sql 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.