Project

General

Profile

Database Checklists

This chapter provides checklists for the setup of the DBMS and the migration of data into the new database. These processes will be run on the database server system. Choose one checklist that corresponds to the DBMS in use. The data migration checklist should also be followed.

PostgreSQL Checklist

# Description Reference Chapter Complete
1 compile/install en_US@p2j_basic collation in Linux OS of database server Database Setup  
2 install PostgreSQL 9.1.x on database server and create cluster Database Setup  
3 create PostgreSQL cluster Database Setup  
3a specify en_US@p2j_basic as locale during initdb of cluster Database Setup  
3b create the database user account that will be used by the application server/hibernate to access the database Database Setup  
3c optionally modify pg_hba.conf to remove local and trust access Database Setup  
4 install PL/Java 1.4.3 on database server Database Setup  
4a prerequisite: install Java 6.0 (JRE) on database server for PL/Java's use (64-bit) Database Setup  
4b build 64-bit version of PL/Java (requires 64-bit JDK 5.0) Database Setup  
4c ensure pljava.so is available to PostgreSQL Database Setup  
4d configure environment variables CLASSPATH and LD_LIBRARY_PATH for postgres account Database Setup  
4e update postgresql.conf "CUSTOMIZED OPTIONS" to support PL/Java Database Setup  
4e1 optionally set max heap for the PL/Java JVM (pljava.vmoptions = '-Xmx{8|12|16}M') Database Setup  
4f bootstrap PL/Java base languages, functions, etc. Database Setup  
5 configure/tune PostgreSQL cluster Database Setup  
5a postgresql.conf - increase max_connections@; ensure PostgreSQL cluster supports enough connections for peak use Database Setup  
5b postgresql.conf - increase shared_buffers (increase SHMMAX if necessary) Database Setup  
5c postgresql.conf - increase work_mem Database Setup  
5d postgresql.conf - increase wal_buffers Database Setup  
5e postgresql.conf - increase maintenance_work_mem Database Setup  
5f postgresql.conf - increase effective_cache_size Database Setup  
5g postgresql.conf - reduce random_page_cost Database Setup  
5h postgresql.conf - increase checkpoint_warning Database Setup  
5i postgresql.conf - increase checkpoint_segments Database Setup  
5j postgresql.conf - increase default_statistics_target Database Setup  

H2 Checklist

# Description Reference Chapter Complete
1 Install p2jspi.jar Database Setup  
2 Set collation en_US_FWD Database Setup  
3 Set property for null values sort Database Setup  
4 Add p2jpl.jar in case of using separate H2 server Database Setup  
5 Create database Database Setup  

Data Migration Checklist

PostgreSQL Data Migration Checklist

# Description Reference Chapter Complete
1 Create the database. Database Migration  
2 Generate a PostgreSQL schema. Database Migration  
3 Install the schema into the new database. Database Migration  
4 Prepare a path to the exported data, so FWD can import Database Migration  
5 Set logging properties for the import process Database Migration  
6a Have prerequisite for running the import Database Migration  
6b Run the import Database Migratio  
7 Install base PL/Java support into the new database Database Migration  
8 Create a “live”, master database backup. (optional) Database Migration  
9 Create a file archive of your database.(optional) Database Migration  
10 Install Progress-compatible built-in functions as PL/Java UDFs. Database Migration  
11 Change ownership of your working database copy. Database Migration  

H2 Data Migration Checklist

# Description Reference Chapter Complete
1 Create the database. Database Migration  
2 Generate an H2 schema. Database Migration  
3 Install the schema into the new database. Database Migration  
4 Prepare a path to the exported data, so FWD can import Database Migration  
5 Set logging properties for the import process Database Migration  
6a Have prerequisite for running the import Database Migration  
6b Run the import Database Migration  
7 Create a “live”, master database backup. (optional) Database Migration  
8 Install Progress-compatible built-in functions UDFs. Database Migration  
9 Change ownership of your working database copy. Database Migration  

© 2004-2017 Golden Code Development Corporation. ALL RIGHTS RESERVED.