Forums / Install & configuration / Migration from MySQL to PostgreSQL

Migration from MySQL to PostgreSQL

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Ken Nguyen

Friday 05 November 2010 8:20:48 am

Hello,

I have an eZ publish Website which is using MySQL db.

I would like to know if it's possible to migrate MySQL to PostgreSQL.

Thanks in advance.

Heath

Friday 05 November 2010 6:06:03 pm

Hello Kenneth,

Welcome to the eZ Community.

eZ Publish does support PostgreSQL.

But the conversion of an eZ Publish Mysql Db

to a PostgreSQL is not really an eZ Publish specific question.

Re: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL

Cheers,

Heath

Brookins Consulting | http://brookinsconsulting.com/
Certified | http://auth.ez.no/certification/verify/380350
Solutions | http://projects.ez.no/users/community/brookins_consulting
eZpedia community documentation project | http://ezpedia.org

Gaetano Giunta

Saturday 06 November 2010 6:25:51 am

There are also some php scripts in eZP that can be of use: ezsqldumpschema.php and ezsqlinsertschema.php. Using the two of them, you should be able to migrate an existing eZ database from mysql to postgresql and viceversa.

Principal Consultant International Business
Member of the Community Project Board

eZ debug

Timing: Jan 30 2025 00:46:06
Script start
Timing: Jan 30 2025 00:46:06
Module start 'content'
Timing: Jan 30 2025 00:46:06
Module end 'content'
Timing: Jan 30 2025 00:46:06
Script end

Main resources:

Total runtime0.2083 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.0058 588.0547180.8281
Module start 'content' 0.00580.0084 768.882893.8516
Module end 'content' 0.01430.1939 862.7344521.8125
Script end 0.2082  1,384.5469 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00351.6726200.0002
Check MTime0.00140.6845200.0001
Mysql Total
Database connection0.00070.333710.0007
Mysqli_queries0.159076.35591410.0011
Looping result0.00130.60421390.0000
Template Total0.193492.910.1934
Template load0.00090.456110.0009
Template processing0.192592.423310.1925
Override
Cache load0.00060.294310.0006
Sytem overhead
Fetch class attribute can translate value0.00100.461510.0010
XML
Image XML parsing0.00020.109010.0002
General
dbfile0.00904.3033200.0004
String conversion0.00000.001930.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.0001 secs