...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
|
Note |
---|
Note: It is recommended to copy and paste the code provided in these instructions. |
1. If you received the data as a tar.gz file, extract it into your local environment. The receiving drive requires approximately 3TB 4TB of free space to download and extract the file.
2. Run Prepare repositories and run a yum
update to pull in the patched version of libxml2 from the IFI CLAIMS repository and any other pending updates. Adjust the code if you are using a different version of PostgreSQL.
Code Block | ||
---|---|---|
| ||
# Amazon sudo amazon-linux-extras install epel sudo amazon-linux-extras enable postgresql14 sudo yum clean all sudo yum update # Rocky sudo dnf -y install epel-release sudo dnf config-manager --set-enabled powertools sudo dnf clean all sudo dnf update libxml2 # RHEL sudo subscription-manager repos --enable codeready-builder-for-rhel-8-x86_64-rpms sudo dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm sudo dnf clean all sudo dnf update |
Note |
---|
Note: Reboot if kernel was upgraded. |
...
Initialize:
Code Block | ||
---|---|---|
| ||
sudo -u postgres initdb -A trust -D /var/lib/pgsql/data -E utf8 |
...
Install the schema and tools.
Code Block | ||
---|---|---|
| ||
# Amazon sudo yum -y install alexandria-data-warehouse-pg11 # CentOS / RHEL sudo yum -y install alexandria-schema-tools |
Create the database.
Code Block | ||
---|---|---|
| ||
# Amazon cat /usr/share/alexandria-data-warehouse-pg11/alexandria-dwh.sql | psql -U alexandria postgres # CentOS / RHEL gunzip -c /usr/share/schema-xml/alexandria-schema-tools/alexandria-dbs-10.x.gzxml.sql | psql -U alexandria postgres |
6. To ensure that the database has been created, run:
...
9. Switch to the directory which holds the backfile you extracted in step 1. 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.
Code Block | ||
---|---|---|
| ||
nohup cd-load.sh & |
10. You can monitor the load using pg_stat_activity.
...