Request #332

PostgreSQL support

Added by Petri Lammi over 1 year ago. Updated 8 months ago.

Status:New Start date:08/30/2010
Priority:Normal Due date:
Assignee:Ruben S. Montero % Done:

0%
Category:OpenNebula Core
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 over 1 year ago

  • Subject changed from Postgesql support to PostgreSQL support

#2
Updated by Jeroen Nijhof over 1 year ago

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 1 year 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 Hutson Betts 8 months 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?

#5
Updated by Carlos Martín 8 months ago

Hi Hutson,

The path indeed needs to be updated. We should consider its addition after the 3.0 release.

#6
Updated by Hutson Betts 8 months ago

Can we have it targeted for 3.2 (Assuming that will be the next release), and I'll work on it assuming no one wishes to.

Also available in: Atom PDF