The PostgreSQL component is the heart of CLAIMS Direct. It contains the XML for the entire data warehouse collection, processes updates from the primary, and functions as data source for the optional SOLR Solr index.
Hardware Requirements
Requirement | Recommended |
---|---|
CPU | 4-cores |
System Memory | 24GB |
Storage Capacity | 4TB 6TB (SSD preferredrequired) |
Software Requirements
Requirement | Supported Versions | Notes |
---|---|---|
Operating System | RHEL |
9.2-6, 10
yum -y install \
postgresql postgresql-contrib \
postgresql-odbc postgresql-plperl \
postgresql-server
/Rocky 8, Amazon Linux 2 | We do not support Ubuntu or any operating system not explicitly listed. | |
PostgreSQL | 10 - 14 | # RHEL/CentOS 7 |
IFI CLAIMS Repository | # Amazon Linux 2 |
|
1.0 |
-1.el7 |
.x86_64.rpm |
Note: CentOS 7 needs an additional repository: yum -y install epel-release
# RHEL/Rocky 8 |
rocky/8/x86_64/ifi-claims-direct- |
1.0 |
-1. |
el8.x86_64.rpm |
Note | ||
---|---|---|
| ||
Some CLAIMS Direct loading and maintenance code utilizes the PostgreSQL perl extension (plperl) as well as a heavy reliance on the libxml2 XML parsing library. IFI CLAIMS has produced a patched release of libxml2 as an RPM. It is highly recommended to update libxml2 from the IFI CLAIMS software repository. For additional distributions, please contact support@ificlaims.com. |
PostgreSQL, Database Schema and Tools
In an effort to further streamline CLAIMS Direct PostgreSQL schema versioning, we are introducing offer a schema and tools package into via the CLAIMS Direct yum
repository . The new package will offer the main which is used to create the CLAIMS Direct database schema as well as the supporting users
database to support deployment of on-site web services. The new package can be installed as follows:and initializes the XML schema.
Amazon Linux 2
Code Block | ||
---|---|---|
| ||
# If you haven't already, install the repository: # CentOS, RHEL 7 sudo amazon-linux-extras install epel sudo amazon-linux-extras enable postgresql14 sudo yum clean all sudo yum -y install \ postgresql postgresql-contrib postgresql-plperl postgresql-server \ alexandria-schema-tools \ libxml2 |
RHEL / CentOS 7
Code Block | ||
---|---|---|
| ||
sudo yum -y install epel-release sudo yum clean all # Note: this installs the default version 10. If you would like a higher version, # please see: https://repowww.ificlaimspostgresql.com/ifi-claims-direct/centos/7/x86_64/ifi-claims-direct-beta-0.0.2-1.el7.centos.x86_64.rpm # CentOS, RHEL 8 sudo yum -y install https://repo.ificlaims.com/ifi-claims-direct/centos/8/x86_64/ifi-claims-direct-beta-0.0.2-1.el8.x86_64.rpm # Install the schema and tools sudo yum -y install alexandria-schema-toolsorg/download/linux/redhat/ sudo dnf -y install \ postgresql postgresql-contrib postgresql-plperl postgresql-server \ alexandria-schema-tools \ libxml2 |
RHEL / Rocky 8
Code Block | ||
---|---|---|
| ||
sudo dnf -y install epel-release
# Rocky
sudo dnf config-manager --set-enabled powertools
# RHEL
sudo subscription-manager repos --enable codeready-builder-for-rhel-8-x86_64-rpms
sudo dnf clean all
# Note: this installs the default version 10. If you would like a higher version,
# please see: https://www.postgresql.org/download/linux/redhat/
sudo dnf -y install \
postgresql postgresql-contrib postgresql-plperl postgresql-server \
alexandria-schema-tools \
libxml2 |
The package contains the SQL needed to create the database (s) supporting PostgreSQL versions 9.2 - 10.x10 - 14, as well as tools to check installation, populate the tables, and perform extracts. To create the databases, simply load the SQL via psql
into the instance.
Code Block | ||
---|---|---|
| ||
echo "create role alexandria with superuser login;" \ | psql -Upostgres postgres gunzipcat -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/schema-xml/alexandria-schema-tools/alexandria-dbs-9.x.gzxml.sql \ # | psql -Ualexandria -h <POSTGRESQL-HOST> postgres |
In addition to the schema, there is a collection of tools to help determine instance loading feasibility, populating, bulk extracting, counts and sizes of tables, and more. All tools accept the same parameters with reasonable defaults for a Type-1 CLAIMS Direct installation.
Code Block | ||
---|---|---|
| ||
Usage: CD-TOOL OPTIONS Option Description Default -------------------------------------------------------- -H|--host specify host localhost -P|--port specify port 5432 -d|--database specify database alexandria -u|--user specify database user name alexandria -h|--help print this usage and exit |
Tool | Description | |||||
---|---|---|---|---|---|---|
cd-pre-flight-check.sh | Use this tool to test the viability of populating the newly created database. It runs a few simple checks.
| |||||
cd-load.sh | You can use this tool to populate the initial data delivery. After unpacking or otherwise making the initial data available,
Note: This tool expects there to be a | |||||
cd-count.sh | This tool counts the rows in all tables in the main schema (cdws, xml).
| |||||
cd-analyze-tables.sh | Analyze all tables in the main schema. | |||||
cd-table-size.sh | Calculate the on-disk size of each table in the main schema.
| |||||
cd-extract.sh | Extract all relevant table data to |
Panel | ||
---|---|---|
| ||
Once the data has been loaded, proceed to:
|