PostgreSqlProject

Grant Gainey edited this page Dec 12, 2016 · 2 revisions
Clone this wiki locally

For up-to-date information about the PostgreSQL port, see PostgreSQL. This page is now obsolete.


PostgreSQL Project

Overview

This project is focused on modifying Spacewalk to support both Oracle and PostgreSQL databases.

The minimum supported version of Oracle is Oracle 10g.

Targeted version of PostgreSQL is 8.1+

Communication

Contacts

| Name | Email | IRC nick | git | Role/Responsibilities | | | --- | --- | --- | --- | --- | | Todd Sanders | mailto:tsanders@redhat.com | tsanders | Y | | | | Jeff Ortel | mailto:jortel@redhat.com | jortel | Y | Technical Lead | | Devan Goodwin | mailto:dgoodwin@redhat.com | dgoodwin | Y | | | | Greg De Koenigsberg | mailto:gdk@redhat.com | gregdek | N | Community Guy |

Planning

Project Plan

Test Plan

Technical Approach

Tracking

What's happening this week ...^03/30/09^

  • Getting perl stack connecting/working with postgres (dgoodwin)
  • Refactoring /schema directory into: (jortel)
    • common parts (done)
    • forked oracle parts (done)
    • forked postgres parts
  • Get build, install & packaging working with refactored directory (jortel).
    • oracle build working.
    • postgres build working but:
      • syntax problems in many of the procs
      • missing 119 trigger files.

|| Tables & Indexes || 100% || Details || |||| || Data (inserts) || 100% || || |||| || Views || 100% || Details || |||| || Triggers || 50% || Details || 119 missing

Procedures 80% Details 13/57 loaded by EDB
Packages 70% Also needs .pks created.
Application infrastructure 30% Details
Query tagging 75% Details
Query migration:java 0%
Query migration:python 0%
Query migration:perl 0%

Branch Review

Project Issues

Project Tasks

Meeting Notes

Worklog - What problems are being encountered in the "pgsql" branch and how they're being solved.

Development Notes - Notes on how to actually work with the as of yet unreleased PostgreSQL code in the pgsql git branch.

Testing Notes - Notes on current testing activities

Resources

Orafce: Oracle support functions http://pgfoundry.org/projects/orafce/

Ora2pg: Convert Oracle DDL to Postgres http://freshmeat.net/projects/ora2pg/

Porting Documentation

Porting Oracle Applications to PostgreSQL http://developer.postgresql.org/~petere/oraport.pdf

EnterpriseDB Oracle Compatibility Developer's Guide http://www.enterprisedb.com/downloads/docs/EnterpriseDB_OraCompat_8.3_v2.7.pdf

Migrating Oracle PL/SQL to PL/pgSQL http://www.pgadmin.org/docs/1.4/pg/plpgsql-porting.html

Porting Guidelines

Postgres Porting guidelines Here are the initial guidelines on how to move ahead with this porting effort. This will be posted, discussed and finalized on the developer mailing list too, so please follow it up there.

References

early research