PostgresTasks
For up-to-date information about the PostgreSQL port, see PostgreSQL. This page is now obsolete.
Project tasks are work items that need to be tracked. They are different then issues in that items listed here simply need to be completed and are not necessarily risks to the project.
| ID | Name | Description | Status | Assigned | Notes |
|---|---|---|---|---|---|
| G1 | Dead Query Script | Write a script to: find queries defined but not referenced in perl code; find queries defined but not referenced in java code; find queries defined in both (perl migrated to java). | done | dgoodwin | determined that the number of queries involved did not warrant the risk |
| G2 | Query Script | Enhance script to list files containing SQL; provides file and query counts | done | zeus | script |
| G3 | Query File List | Publish final list of files containing queries that need to be tagged. This item will be created by merging script task(s) output | done | jortel | Included in G7 |
| G4 | Add comments | Add SQL comments to every query and view | bmomjian | ||
| G5 | Postgres Schema | Create test version of Postgres schema, for testing of queries | done | jortel | Used ora2pg 4.11 generated [ddl] DDL only. See G10. |
| G6 | Database Versions | What is the minimum supported version of Postgres? | done | jortel | !1 This will depend on targeted versions of RHEL. Decided: RHEL5+ which means 8.1+ |
| G7 | Custom Data Type | Add EVR_T data type with aggregate | Only (1) table with this column type: RHNPACKAGEEVR. | ||
| G8 | Prepare git branch | Either clean up the existing postgres branch, or create a new branch and cherry pick Devin's changes | done | dgoodwin | Would be good to have this by COB 12/19 |
| G9 | Postgres Dev Packages | Create a devel yum repo containing custom packages required for satellite to use both oracle and postgres | dgoogwin | ||
| G10 | Postgres DDL | Publish an initial postgres schema generated by ora2pg | done | jortel,bmomjian | Files added to git and are to be cleaned up by bmomjian |
| G11 | Sample Dataset | Create a sample database dataset that can be loaded in both oracle and postgres to be used by developers | jortel | ||
| G12 | Monitoring | Are we converting the monitoring module? | done | tsanders | Yes |
| G13 | Remove dead java queries | Remove the dead java data source queries from git | done | dgoodwin | |
| G14 | Orafce | Orafce requires Postgres 8.2; port Orafce to Postgres 8.1; packaging issues? | bmomjian | Orafce 3.0 back-ported to 8.1 in orafce CVS | |
| G15 | Setup schema review meeting | Have developers review schema beforehand, meet to discuss core tables and answer questions with as many developers as possible. | done | jortel | |
| G16 | db-control | what about the RHN db-control stuff. It's probably oracle based | |||
| G17 | Prioritized Modules | Provide a prioritized list of modules (feature sets). | 25% done | jortel | Iteration 1 scoped but need to do 3+. |
| ID | Name | Description | Status | Assigned | Notes | | --- | --- | --- | --- | --- | --- | --- | | Q1 | Sysdate | Convert sysdate to appropriate current_date and current_timestamp | | | | | | Q2 | Sysdate addition | Add Postgres timestamp + float compatibility operator | | | | | | Q3 | nextval() | Handle nextval() differences | | | | |
Here is the assignment table for migrating the table DDL. Please put you name in the Assigned column before you begin working on a table. Start by copying oracle .sql file located in $GIT/spacewalk/schema/spacewalk/rhnsat/tables to $GIT/spacewalk/schema/spacewalk/postgresql/tables. Then proceed with the migration. Also, please note any items of interest in the notes column and be sure to follow the porting guidelines.
Here is the assignment table for migrating the view DDL. Please put you name in the Assigned column before you begin working on a view. Start by copying oracle .sql file located in $GIT/spacewalk/schema/spacewalk/rhnsat/views to $GIT/spacewalk/schema/spacewalk/postgresql/views Then proceed with the migration. Also, please note any items of interest in the notes column and be sure to follow the porting guidelines.
Here is the assignment table for migrating the stored procedures not associated with a package. Please put you name in the Assigned column before you begin working on a procedure. Start by copying oracle .sql file located in $GIT/spacewalk/schema/spacewalk/rhnsat/procs to $GIT/spacewalk/schema/spacewalk/postgresql/procedures. Then proceed with the migration. Also, please note any items of interest in the notes column and sure to follow the porting guidelines.
!1::
RHEL-4 includes postgres 7.4 and RHEL-5 includes postgres 8.1. The latest postgres is 8.3.8. 7.4 has the following limitations (Exceptions, Save Points) appear to be applicable to spacewalk.
