...
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. The extracted file will consist of a number of smaller tar.gz files. There is no need to extract each of these smaller files.
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 Linux 2
sudo amazon-linux-extras install epel
sudo amazon-linux-extras enable postgresql14
sudo yum clean all
sudo yum update
# RHEL/CentOS 7
sudo yum -y install epel-release
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. |
...
Install:
Code Block |
---|
|
# Note: this installs the default version of your distribution. If you would like a higher version,
# please see: https://www.postgresql.org/download/linux/redhat/
sudo yum -y install postgresql postgresql-contrib postgresql-plperl postgresql-server |
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.
...
Code Block |
---|
|
echo "select * from xml.t_patent_document_values where ucid = 'US-5551212-A'" | psql -U alexandria |
Note |
---|
Note: For new installations as well as any changes to your subscription, it may take 24 hours for full synchronization of your on-site instance. |
Panel |
---|
|
Once the data has been loaded, proceed to Client Tools Installation. Familiarize yourself with the PostgreSQL Schema and Tools. |