OWNER=xonstat
CONNECTION LIMIT=-1;
+Next, log into the newly created database using the user account
+you just created:
+
+ psql -U xonstat xonstatdb
+
Create the schema in which all of the xonstat tables will reside:
-CREATE SCHEMA xonstat
+ CREATE SCHEMA xonstat
AUTHORIZATION xonstat;
-Navigate to the 'build' directory. Log into the database as the
-admin user created above and issue the following to build the
-initial tables:
+Create the pgplsql language:
+
+ CREATE LANGUAGE plpgsql;
- TODO
+Back in the command shell, navigate to the root directory.
+Log into the database as the admin user created above and issue
+the following to build the initial tables:
-TODO:
+ \i build/build_full.sql
-- Define indexes
-- Audit report SQL to verify index usage
-- Review datatypes to ensure no truncation occurs.
-- Review plurality in table names
-- Review for usage of serial datatypes in foreign keys
-- Review regular serials vs bigserials
+ *Note: You will see a lot of NOTICE messages. This is normal.