Page History

...

10. Create the role alexandria and load the SQL via psql into the instance.

echo "create role alexandria with superuser login;" \
  | psql -U postgres postgresUpostgres postgres
 
yum -y install alexandria-schema-tools
gunzip -c /usr/share/alexandria-schema-tools/alexandria-dbs-10.x.gz \
  | psql -Ualexandria -h <POSTGRESQL-HOST> postgres
 
# There's also support for 9.x,
# gunzip -c /usr/share/alexandria-schema-tools/alexandria-dbs-9.x.gz \
#  | psql -Ualexandria -h <POSTGRESQL-HOST> postgres

11. Change the directory to the mounted USB file system and create the database. If desired, you can redirect errors (if any) to LOG.2.

...

./cd-pre-flight-check.sh

The sample output of a properly configured system would look like this:

...

15. Use the load script to load the CLAIMS Direct data into PostgreSQL tables. Since the loading process will take 1-2 days, we recommend that you use the nohup command to detach the script from the terminal and allow it to run in the background. Edit the IP address in the command to reflect the IP address where postgres is installed.

nohup bash ./cd-load.sh xxx.xxx.xxx.xxx alexandria &

16. Use the ps command periodically to check whether the load.sh process loading process has completed.

ps -eaf |grep COPY

17. Once the loading process is complete, you can run the the cd-count.sh script, a simple QA of table counts, to ensure that the tables have loaded correctly. Modify the IP address to reflect the postgresql PostgreSQL server. This may take an hour or more to run.

bash ./cd-count.sh xxx.xxx.xxx.xxx alexandria

The results should show that 39 tables have loaded. The following tables are deprecated and will show a count of 0:

...