Page History

1.  IFI IFI CLAIMS will create a single tar.gz file that includes several bash scripts that are used during implementation and a subdirectory of tar.gz files for each of the tables in the PostgreSQL data warehouse. This file will be placed into an S3 bucket and we will provide you with a link for you to access and download the file. Alternately, if you have received the data on a USB, connect it to your intended PostgreSQL machine and mount the drive so that it can be read.

2. Extract the If you received the data as a tar.gz file, extract it into your local environment. The receiving drive will require approximately 3TB of free space to download and extract the file.

...

10. Create the role alexandria and load the SQL via psql into the instance.

If you are using PostgreSQL version 10.x, use the following code:

echo "create role alexandria with superuser login;" \
  | psql -Upostgres postgres
 
yum -y install alexandria-schema-tools
gunzip -c /usr/share/alexandria-schema-tools/alexandria-dbs-10.x.gz \
  | psql -Ualexandria -h <POSTGRESQL-HOST> postgres
 
# There's also support for 9.x,
# 

If you are using PostgreSQL version 9.x, use the following code:

echo "create role alexandria with superuser login;" \
  | psql -Upostgres postgres

gunzip -c /usr/share/alexandria-schema-tools/alexandria-dbs-9.x.gz \ 
#  | psql -Ualexandria -h <POSTGRESQL-HOST> postgres

...

12. Run pgtune. Note that this requires Python. You can also If you are using PostgreSQL version 9.4 and above, you can use the online tool https://pgtune.leopard.in.ua/#/ and fill in the required values as well as those that correspond to your system. Add or change the appropriate settings and restart PostgreSQL.

yum -y install pgtune
  pgtune -i postgresql.conf  -T DW -c 500

#  [If using the online tool, paste added configuration options at end of postgres.conf ]

13. Run the pre-flight check script to confirm that your system is properly configured to load the data.

...