...
| Code Block | ||
|---|---|---|
| ||
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------------+------------+----------+-------------+-------------+-----------------------
alexandria |alexandria | UTF8 | en_US.UTF-8| en_US.UTF-8 |
postgres |postgres | UTF8 | en_US.UTF-8| en_US.UTF-8 |
template0 |postgres | UTF8 | en_US.UTF-8| en_US.UTF-8 |=c/postgres +
| | | | | postgres=CTc/postgres
template1 |postgres | UTF8 | en_US.UTF-8| en_US.UTF-8 |=c/postgres +
| | | | | postgres=CTc/postgres |
13. Run pgtune. Note that this requires Python. You can also use the online tool https://pgtune.leopard.in.ua/#/ and fill in the required values and those that correspond to your system. Add or change the appropriate settings and restart PostgreSQL.
| Code Block | ||
|---|---|---|
| ||
yum -y install pgtune
pgtune -i postgresql.conf -T DW -c 500
[ paste added configuration options at end of postgres.conf ] |
14. Run the pre-flight check script to confirm that your system is properly configured to load the data.
...
Resolve any recognized errors. For unfamiliar errors, please contact support@ificlaims.com.
1415. 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 detach the script from the terminal to allow it to run in the background. Edit the IP address in the command to reflect the IP address where postgres is installed.
| Code Block |
|---|
nohup bash ./load.sh xxx.xxx.xxx.xxx alexandria & |
1516. Use the ps command periodically to check whether the load.sh process has completed.
| Note | ||
|---|---|---|
Note: If you want to check on the process while it is running, use the following command to show the progress of the tables which are being copied:
|
1617. Once the loading process is complete, you can run the 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 server. This may take an hour or more to run.
...
More information about the tables can be seen in Data Warehouse Design.
1718. Optional: you may want to run a simple SQL query as an additional test to confirm that the data is present.
...