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.iso88591_fwd_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.iso88591_fwd_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.