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

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 eZ publish 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 eZ publish 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 eZ publish 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 eZ publish 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