...
2. Run a yum update to pull in the patched version of libxml2 from the IFI CLAIMS repository and any other pending updates.
| Code Block | ||
|---|---|---|
| ||
sudo yum update libxml2 |
| Note |
|---|
Note: Reboot if kernel was upgraded. |
...
Install:
| Code Block | ||
|---|---|---|
| ||
sudo yum -y install postgresql postgresql-contrib postgresql-plperl postgresql-server |
...
4. Enable and restart the PostgreSQL cluster.
| Code Block | ||
|---|---|---|
| ||
sudo systemctl enable postgresql.service ; sudo systemctl start postgresql.service |
...
5. Create the role alexandria and load the SQL via psql into the instance.
| Code Block | ||
|---|---|---|
| ||
echo "create role alexandria with superuser login;" \ | psql -U postgres postgres |
...
6. To ensure that the database has been created, run:
| Code Block | ||
|---|---|---|
| ||
psql -U alexandria --list |
...
8. Run the pre-flight check script to confirm that your system is properly configured to load the data.
| Code Block | ||
|---|---|---|
| ||
cd-pre-flight-check.sh |
The sample output of a properly configured system looks like this:
...
11. Once the loading process is complete, you can run the cd-count.sh script, a simple QA of table counts, to ensure that the tables have loaded correctly. This may take an hour or more to run.
| Code Block | ||
|---|---|---|
| ||
cd-count.sh |
The results should show that 39 xml tables and 4 cdws tables have loaded. The following tables will show a count of 0:
...