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

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+

• Developer list:spacewalk-devel@redhat.com(signup)
• IRC: #spacewalk-devel on(irc.freenode.net)
• git repo: branch "pgsql"( last mergedfrom master: 06-22-09 by jortel ){{{git branch --track pgsql origin/pgsqlgit checkout pgsql}}}

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

Project Plan

Test Plan

Technical Approach

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

• Getting perl stack connecting/working with postgres (dgoodwin)
• Refactoring/schema directory into: (jortel)
  • common parts (done)
  • forkedoracle parts (done)
  • forkedpostgres 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

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

Orafce: Oracle support functionshttp://pgfoundry.org/projects/orafce/

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

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

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

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

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.

early research