[Erp5-dev] Is it possible to change MySQL database system into Postgress SQL ?

Discussion:

Muhamad Reza

2009-09-18 09:11:23 UTC

Hi,

I know that ERP5 use Zope + MySQL as their database systems. Nonetheless, Is
it possibly ERP5 use PostgressSQL as database ?
If yes, How can I configure it ?

Best Regards,
Reza
--
exodream - beyond a dream
Everyone has rights to get what they expect.

----Free Software is better than Open Source----
Why ? See www.gnu.org/philosophy/free-software-for-freedom.html

Join Free Software Foundation at
https://my.fsf.org/associate/support_freedom/join_fsf?
Take all of advantages by Joining FSF. Join Now !!

i n f i n i t y . s o l u t i o n (www.infi-nity.com) - pt. vikasa infinity
anugrah
bsd city sektor 14 - ruko golden madrid g/9 - tangerang 15321 - indonesia
t: +62 (21) 5316 4796 f: +62 (21) 5316 4797 m:+62 816 956207
Contact me at + 62 878 3229 5036
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20090918/be96768a/attachment.htm>

Łukasz Nowak

2009-09-18 09:20:33 UTC

Permalink

Hello,

Post by Muhamad Reza
Hi,
I know that ERP5 use Zope + MySQL as their database systems.
Nonetheless, Is it possibly ERP5 use PostgressSQL as database ?
If yes, How can I configure it ?

Such issue was already discussed:

http://mail.nexedi.com/pipermail/erp5-dev/2007-June/001158.html

Regards,
Luke

Post by Muhamad Reza
Best Regards,
Reza
--
exodream - beyond a dream
Everyone has rights to get what they expect.
----Free Software is better than Open Source----
Why ? See www.gnu.org/philosophy/free-software-for-freedom.html
Join Free Software Foundation at
https://my.fsf.org/associate/support_freedom/join_fsf?
Take all of advantages by Joining FSF. Join Now !!
i n f i n i t y . s o l u t i o n (www.infi-nity.com) - pt. vikasa
infinity anugrah
bsd city sektor 14 - ruko golden madrid g/9 - tangerang 15321 - indonesia
t: +62 (21) 5316 4796 f: +62 (21) 5316 4797 m:+62 816 956207
Contact me at + 62 878 3229 5036
_______________________________________________
Erp5-dev mailing list
Erp5-dev at erp5.org
http://mail.nexedi.com/mailman/listinfo/erp5-dev

Jean-Paul Smets

2009-09-18 09:31:55 UTC

Permalink

Hi,

Thanks.

Please feel free to try and contribute (it will take you about 2 to 4
weeks of work to make it realy work - only a few SQL methods to change).

Last time we tried, inserts were 10 times slower with Pg, but maybe it
changed. It would be interesting to know.

Also, Pg does not have RAM based open source symetric clustering which
is required to handle large data sets.

Regards,

JPS.

Post by Åukasz Nowak
Hello,

Post by Muhamad Reza
Hi,
I know that ERP5 use Zope + MySQL as their database systems.
Nonetheless, Is it possibly ERP5 use PostgressSQL as database ?
If yes, How can I configure it ?

http://mail.nexedi.com/pipermail/erp5-dev/2007-June/001158.html
Regards,
Luke

_______________________________________________
Erp5-dev mailing list
Erp5-dev at erp5.org
http://mail.nexedi.com/mailman/listinfo/erp5-dev

Muhamad Reza

2009-09-18 09:56:57 UTC

Permalink

Hi,

Okay thank you. I'll try it.

Post by Jean-Paul Smets
Hi,
Thanks.
Please feel free to try and contribute (it will take you about 2 to 4
weeks of work to make it realy work - only a few SQL methods to change).
Last time we tried, inserts were 10 times slower with Pg, but maybe it
changed. It would be interesting to know.
Also, Pg does not have RAM based open source symetric clustering which
is required to handle large data sets.
Regards,
JPS.

Post by Åukasz Nowak
Hello,

Post by Muhamad Reza
Hi,
I know that ERP5 use Zope + MySQL as their database systems.
Nonetheless, Is it possibly ERP5 use PostgressSQL as database ?
If yes, How can I configure it ?

http://mail.nexedi.com/pipermail/erp5-dev/2007-June/001158.html
Regards,
Luke

_______________________________________________
Erp5-dev mailing list
Erp5-dev at erp5.org
http://mail.nexedi.com/mailman/listinfo/erp5-dev

--
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 29 02 44 25
ERP5 Enterprise: Free / Open Source ERP for Critical Applications
http://www.erp5.com
ERP5 Express: Hosted Open Source ERP for small companies
http://www.myerp5.com
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com
_______________________________________________
Erp5-dev mailing list
Erp5-dev at erp5.org
http://mail.nexedi.com/mailman/listinfo/erp5-dev

Regards,

Reza
--
exodream - beyond a dream
Everyone has rights to get what they expect.

----Free Software is better than Open Source----
Why ? See www.gnu.org/philosophy/free-software-for-freedom.html

Join Free Software Foundation at
https://my.fsf.org/associate/support_freedom/join_fsf?
Take all of advantages by Joining FSF. Join Now !!

i n f i n i t y . s o l u t i o n (www.infi-nity.com) - pt. vikasa infinity
anugrah
bsd city sektor 14 - ruko golden madrid g/9 - tangerang 15321 - indonesia
t: +62 (21) 5316 4796 f: +62 (21) 5316 4797 m:+62 816 956207
Contact me at + 62 878 3229 5036
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20090918/0db77f9f/attachment.htm>