Switching from Oracle to PostgreSQL

September 11, 2009 at 11:50 am 3 comments

We, consultants, aren’t so techie as developers are and changes take a bit longer. During last couple of months I’m introducing myself to PostgreSQL: installing sources, developing, installing database client, etc.

Just in case you are in a similar situation:
- On config/Openbravo.properties file, bbdd.sid parameter is a different concept from what you are used to in Oracle. In case you have an environments and want to install a second one, bbdd.sid must be different. Otherwise, when executing ant install.source your first database user will be erased. Conclusion, when using PostgreSQL, per each OpenbravoERP installation you will need a different database.sid. This is, bbdd.sid concept is different in Oracle and in PostgreSQL.

- When accessing database throw a terminal-based front-end, Oracle uses SQL+ while PostgreSQL uses psql. They are very similar and really helpful when accessing OpenbravoERP server using ssh connection.

Please feel free to comment any additional main differences when switching from Oracle to PostgreSQL.

Like this:

Be the first to like this post.

Entry filed under: Openbravo. Tags: .

Data migration, watch out! Pluging and unpluging

3 Comments Add your own

1. Francesco | September 15, 2009 at 2:04 pm

If you use oracle you can set one user and for every installation choose a different sid.
If you use postgres you must use a different sid and a different user.
Reply
2. carbonete | September 16, 2009 at 3:04 pm

I´m think the bad in change is for OB Alert , thei are plataform dependent, in actual version examples don´t work in postgresql.
Reply
3. Galder | September 22, 2009 at 2:13 pm

This has been reported as an issue:
https://issues.openbravo.com/view.php?id=10687

Thanks!
Reply