PostgresProjectPlan

DEPRECATED, NO LONGER USED

Main Project Page

Project Plan

This is s straw man for the project plan and needs more work.

Planning - phase 1

Development Plan"

Tasks/Track"

Knowledge Transfer

Overview

Datamodel Review

Analysis

Sample (populated) Database (oracle & postgres)

Schema

Views

Queries

Stored Procedures

Identify Risks

Infrastructure

Communication

Source Control

Packaging Plan

Technical (migration) Approach

Technical Approach

Assemble Team

• Bruce Momjian mailto:bruce@momjian.us
• George Williams mailto:george.williams@enterprisedb.com
• Gurjeet Singh mailto:gurjeet.singh@enterprisedb.com
• Vikram Rai mailto:vikram.singh@enterprisedb.com
• Tushar Ahuja mailto:tushar.ahuja@enterprisedb.com

Test Plan

Test Plan"

Functional Test Plan

Query / Stored Procedure ( Level )

System ( Level )

Performance Test Plan

Test Environment

Identify Gaps In Automated Testing

Data Migration Plan

Oracle -> Postgres

Postgres -> Oracle

Schema Upgrade Plan

How do we do this for multiple databases?

Implementation - phase 2

Git Setup

Cleanup or drop and recreate the postgres branch.

Create PG Schema & Sample Database

Compatibility Libraries

• orafce
• other?

Back porting

Packaging

Development Packages

• spacewalk-schema.rpm
• spacewalk-setup.rpm
• ...

Spacewalk Database Infrastructure

Modify Spacewalk infrastructure to support multiple databases.

• Drivers
• Installer
• DB Wrappers
  • Java Stack
  • Python Stack
  • Perl Stack
• db-control scripts

Refine/Tune Postgres Schema

Tag Queries

Isolate Development Branch from Master

Stop pulling from master.

Migrate Queries

Migrate Stored Procedures

Create postgres function of Oracle stored procedures.

Testing - phase 3

Functional Regression Test_(Automated Testing)_

Query/Stored Procedure Performance Testing

Client driven Performance Testing