Forums / General / How can I move database from mySQL to postgres ?

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

How can I move database from mySQL to postgres ?

Previous topic

General

Next topic

Author	Message
Tomasz Jakubowski	Friday 21 October 2005 1:48:41 pm I need move my site form mySQL to postgres. I deleted data from tables in existing postgres databese. To this table I insert data which I export from mysql (only INSERTs). Everything is showon on the site. When I try edit or create object then error message is: Fatal error: A database transaction in Exponential failed. The current execution was stopped to prevent further problems. You should contact the System Administrator of this site with the information on this page. The current transaction ID is TRANSID-3cc073021984ac9c0f4855d36044e8ac and has been logged. Please include the transaction ID and the current URL when contacting the system administrator. Could somebody help me ?
Łukasz Serwatka	Thursday 27 October 2005 12:48:23 am Hi Tomasz, Check in var/log/error.log (in Exponential root folder) which SQL query fails. PostgreSQL installation must have the digest> procedure available. Look here for more info. http://ez.no/products/ez_publish_cms/documentation/faq/database/what_is_the_reason_i_get_error_function_digest_character_varying_does_not_exist_on_postgresql Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Tomasz Jakubowski

Friday 21 October 2005 1:48:41 pm

I need move my site form mySQL to postgres.

I deleted data from tables in existing postgres databese. To this table I insert data which I export from mysql (only INSERTs).
Everything is showon on the site.
When I try edit or create object then error message is:

Fatal error: A database transaction in Exponential failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-3cc073021984ac9c0f4855d36044e8ac and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

Could somebody help me ?

Łukasz Serwatka

Thursday 27 October 2005 12:48:23 am

Hi Tomasz,

Check in var/log/error.log (in Exponential root folder) which SQL query fails. PostgreSQL installation must have the digest> procedure available.

Look here for more info.
http://ez.no/products/ez_publish_cms/documentation/faq/database/what_is_the_reason_i_get_error_function_digest_character_varying_does_not_exist_on_postgresql

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog