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

eZ debug

Timing: Jan 30 2025 00:57:03
Script start
Timing: Jan 30 2025 00:57:03
Module start 'content'
Timing: Jan 30 2025 00:57:03
Module end 'content'
Timing: Jan 30 2025 00:57:04
Script end

Main resources:

Total runtime0.1863 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0064 588.0547180.8203
Module start 'content' 0.00640.0088 768.875094.0234
Module end 'content' 0.01510.1710 862.8984522.6250
Script end 0.1862  1,385.5234 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00412.1799200.0002
Check MTime0.00170.9117200.0001
Mysql Total
Database connection0.00080.441410.0008
Mysqli_queries0.128168.78011410.0009
Looping result0.00150.78111390.0000
Template Total0.170591.510.1705
Template load0.00090.490110.0009
Template processing0.169691.040410.1696
Override
Cache load0.00060.330610.0006
Sytem overhead
Fetch class attribute can translate value0.00070.393010.0007
XML
Image XML parsing0.00030.182010.0003
General
dbfile0.01457.7622200.0007
String conversion0.00000.003130.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs