Board.KolibriOS.org

Official KolibriOS board
It is currently Wed May 22, 2019 6:02 pm

All times are UTC+03:00




Post new topic  This topic is locked, you cannot edit posts or make further replies.  [ 132 posts ]  Go to page Previous 15 6 7 8 9 Next
Author Message
PostPosted: Thu Aug 25, 2011 6:48 pm 
Offline
User avatar

Joined: Tue Aug 25, 2009 4:45 pm
Posts: 794
Hm. we stuck on the database conversion. from MySQL to PostgreSQL. All other is OK.


Top
   
 
PostPosted: Thu Aug 25, 2011 8:01 pm 
MySQL install is a big problem?


Top
   
 
PostPosted: Thu Aug 25, 2011 8:20 pm 
Offline
User avatar

Joined: Tue Aug 25, 2009 4:45 pm
Posts: 794
that is not good way, bcoz already have a lot of services on PgSQL and it is much more faster.


Top
   
 
PostPosted: Fri Aug 26, 2011 3:23 pm 
Offline
User avatar

Joined: Tue Jan 24, 2006 8:50 am
Posts: 249
Try this.


Top
   
 
PostPosted: Wed Aug 31, 2011 5:17 pm 
Offline
Just Flooding

Joined: Sat Jan 06, 2007 2:30 pm
Posts: 269
Erm. About a half of a year before i've tried to migrate to PgSQL from MySQL (DB was used for some local billing system, intranet forum and some sql experiments). No, it's not faster at all. Pg is a heavy enterprise thing. It supports some interesting features out-of-the-box and may be it's more reliable, but it's not fast, no way.

This may help:
Quote:
-- mysql2pgsql.perl
-- http://gborg.postgresql.org/project/mysql2pgsql/
-- (c) 2001 - 2007 Jose M. Duarte, Joseph Speigle

It's possible that you'll have to edit the output of the script manually a bit, but these fixes would be very minor.
This was the best one among those i've tried to use.


Last edited by Nable on Wed Aug 31, 2011 9:34 pm, edited 2 times in total.

Top
   
 
PostPosted: Wed Aug 31, 2011 6:15 pm 
Offline
User avatar

Joined: Tue Aug 25, 2009 4:45 pm
Posts: 794
It depends from the tasks. And for big databases and for clastering/replication - faster. much more faster.


Top
   
 
PostPosted: Mon Sep 05, 2011 8:04 am 
Offline
Kernel Developer
User avatar

Joined: Mon Mar 20, 2006 10:44 am
Posts: 557
с трансфером из одной БД и другую (мускул/постгре/и т.д.) хорошо справляется NavCat можно взять 30и дневную пробную версию Premium.


Top
   
 
PostPosted: Mon Sep 05, 2011 8:28 am 
Offline
User avatar

Joined: Tue Aug 25, 2009 4:45 pm
Posts: 794
Спасибо, попробуем! http://www.navicat.com/


Top
   
 
PostPosted: Wed Sep 14, 2011 10:01 pm 
Offline
Kernel Developer
User avatar

Joined: Thu Sep 03, 2009 1:52 pm
Posts: 1619
The site has been moved to the new server. The following resources are available:
http://kolibrios.org = http://www.kolibrios.org (with http) - main page
ftp, svn on kolibrios.org, all users are preserved
http://websvn.kolibrios.org for web lookup in svn repository
http://builds.kolibrios.org - data of autobuild
http://ftp.kolibrios.org - http access for ftp data
http://wiki.kolibrios.org - wiki
http://board.kolibrios.org - this board.


Top
   
 
PostPosted: Wed Sep 14, 2011 10:22 pm 
Offline
User avatar

Joined: Tue May 08, 2007 12:44 am
Posts: 346
Jabber bot has been left.

_________________
Разработчик языка программирования Кантор


Top
   
 
PostPosted: Thu Sep 15, 2011 9:04 am 
Offline

Joined: Mon Sep 24, 2007 11:11 am
Posts: 2814
search.php?author_id=290&sr=posts
Quote:
Общая ошибка
SQL ERROR [ postgres ]

ERROR: syntax error at or near "." LINE 1: SELECT SQL_CALC_FOUND_ROWS p.post_id ^ []

Произошла ошибка SQL при выборке на этой странице. Пожалуйста, сообщите администратору, если ошибка будет повторяться.


Top
   
 
PostPosted: Thu Sep 15, 2011 2:13 pm 
Offline
Kernel Developer
User avatar

Joined: Thu Sep 03, 2009 1:52 pm
Posts: 1619
Board settings were moved without changes, and search has used MySQL-specific engine. I have fixed this setting.


Top
   
 
PostPosted: Thu Sep 15, 2011 3:29 pm 
Thank you very much! For all! :)

З.Ы. Стоило все же предупредить, что в такой то день состоится окончательный переход и ресурсы будут недоступны какое-то время. Я было подумал что опять сервер упал.


Top
   
 
PostPosted: Thu Sep 15, 2011 4:14 pm 
SVN не пашет, что Windows c TortoiseSVN:
Quote:
Can't connect to host 'kolibrios.org': No connection could be made because the target machine actively refused it.

что Linux с eSvn:
Quote:
Can't connect to host 'kolibrios.org': В соединении отказано.


Top
   
 
PostPosted: Thu Sep 15, 2011 4:19 pm 
Offline
Kernel Developer
User avatar

Joined: Thu Sep 03, 2009 1:52 pm
Posts: 1619
SVN должен работать. Может, изменения в DNS не доехали? ping kolibrios.org в качестве IP что показывает? svn info svn://46.4.23.4 показывает информацию?

_________________
Сделаем мир лучше!


Top
   
 
Display posts from previous:  Sort by  
Post new topic  This topic is locked, you cannot edit posts or make further replies.  [ 132 posts ]  Go to page Previous 15 6 7 8 9 Next

All times are UTC+03:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited