Backlog #332: PostgreSQL support - OpenNebula - OpenNebula Development pages

Backlog #332

PostgreSQL support

Added by Petri Lammi almost 11 years ago. Updated over 6 years ago.

Status:

Closed

Start date:

08/30/2010

Priority:

None

Due date:

Assignee:

% Done:

Category:

Core & System

Target version:

Description

A sophisticated, truly dependable DBMS. Please support it for crash-free DB operations.

PostgreSQL home

pgsql.patch (41.5 KB) Jeroen Nijhof, 10/14/2010 11:50 AM

History

#1 Updated by Tino Vázquez almost 11 years ago

Subject changed from Postgesql support to PostgreSQL support

#2 Updated by Jeroen Nijhof over 10 years ago

File pgsql.patch added

I finally wrote the PostgreSQL driver for ONE, see the attached patch.
Fixed a number of SQL statements so it will work with every database and not only SQLite and MySQL.

REMARKS:

To compile with pgsql support use: scons pgsql=yes
"CREATE TABLE IF NOT EXIST" is not SQL compliant and therefor I fixed the code to be more generic.
It will first check if a table exist by doing a normal query and if it doesn't exist it will create the table...
"REPLACE" is not SQL compliant and therefor I changed it to "UPDATE" just to be more generic.

#3 Updated by Javi Fontan over 10 years ago

Thanks! Its an amazing job. We are discussing the best way to incorporate this patch. It cannot go into 2.0 release as we are in feature freeze but we are looking on a way that it can be accessible and that we can work on it in parallel.

#4 Updated by Anonymous almost 10 years ago

Does this patch need to be updated to work with the upcoming OpenNebula 3.0 version, and if so, will this require someone to step in and contribute an updated patch?