Tool for shifting tables from Mysql to Postgresql

Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). Can someone Please tell me tool for it that makes it easier. I am able to done it through FW tools in Windows System but i want to achieve it in Linux ( CentOS

Re: Tool for shifting tables from Mysql to Postgresql

2011/3/1 Adarsh Sharma adarsh.sha...@orkash.com: Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). [...] invalid byte sequence for encoding UTF8: 0xe3ba27 HINT:  This error can also happen if the byte sequence does

Re: Tool for shifting tables from Mysql to Postgresql

By default Postgresql database encoding in UTF8. It seems to me by seeing error that database encoding in mysql is different from it. -- Cheers, Dhaval Jaiswal On 01/03/2011 3:57 PM, Adarsh Sharma wrote: Dear all, I want to convert some tables from Mysql database to Postgresql

Mysql to Postgresql

Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Can anyone kindly describe me the way to do this. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives:

Re: Mysql to Postgresql

2011/2/22 Adarsh Sharma adarsh.sha...@orkash.com: Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Have a look at: mysqldump --compatible=postgresql command:

mysql vs postgresql -- is this list accurate?

no, i don't want to start a flame war, i just want some feedback on a current list of mysql drawbacks WRT postgresql. in the context of a fully open-source, java based ECM product, there is a FAQ entry that summarizes why the developers would prefer their users to use postgresql as opposed

Re: mysql vs postgresql -- is this list accurate?

On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), Robert P. J. Day rpj...@crashcourse.ca wrote: no, i don't want to start a flame war, i just want some feedback on a current list of mysql drawbacks WRT postgresql. in the context of a fully open-source, java based ECM product, there is a FAQ entry

Re: MySQL versus PostgreSQL for GPS Data

-. - There won't be more than 86400 * 365 rows per table -one GPS position every second along one year-. - There won't be more than 10 simultaneously read-only queries. The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? I think

Re: MySQL versus PostgreSQL for GPS Data

. The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? I think it depends on exactly what you want to do with the data. MySQL has fairly poor support for spatial types but you can achieve a lot just manipulating normal data types. Postgres (which

MySQL versus PostgreSQL for GPS Data

DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? Thanks in advance Juan Karlos.

Re: MySQL versus PostgreSQL for GPS Data

is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? Thanks in advance Juan Karlos. __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List

Re: MySQL versus PostgreSQL for GPS Data

one year-. - There won't be more than 10 simultaneously read-only queries. The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? I think it depends on exactly what you want to do with the data. MySQL has fairly poor support for spatial types

Re: MySQL versus PostgreSQL for GPS Data

is the best for this kind of application? PostgreSQL or MySQL? I think it depends on exactly what you want to do with the data. MySQL has fairly poor support for spatial types but you can achieve a lot just manipulating normal data types. Postgres (which i know nothing about) appears to have

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong wrote: * Table 1: 80,000,000 rows - 9.5 GB * Table 2: 1,000,000,000 rows - 8.9 GB This is a generic star schema design for data warehousing. I have read that it is better if perhaps partitioning is implemented, where new data is added to a partitioned

RE: Data Warehousing and MySQL vs PostgreSQL

partitioning. Cheers - Andrew -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 6:44 PM To: mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL On 7/26/07, Andrew Armstrong wrote: * Table 1: 80,000,000 rows - 9.5 GB

Re: Data Warehousing and MySQL vs PostgreSQL

On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote: Hello, I am seeking information on best practices with regards to Data Warehousing and MySQL. I am considering moving to PostgreSQL. * Table 1: 80,000,000 rows - 9.5 GB * Table 2: 1,000,000,000 rows - 8.9 GB Just

Data Warehousing and MySQL vs PostgreSQL

Hello, I am seeking information on best practices with regards to Data Warehousing and MySQL. I am considering moving to PostgreSQL. I am currently using MySQL as the database of choice. I am now running into performance issues with regards to large tables. At the moment, I have the

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote: snip Information is deleted from this DW as well, after every five minutes. The data being recorded is time sensitive. As data ages, it may be deleted. Groups of samples are aggregated into a summary/aggregation sample prior to being deleted.

RE: Data Warehousing and MySQL vs PostgreSQL

: Re: Data Warehousing and MySQL vs PostgreSQL On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote: Hello, I am seeking information on best practices with regards to Data Warehousing and MySQL. I am considering moving to PostgreSQL. * Table 1: 80,000,000 rows - 9.5 GB

RE: Data Warehousing and MySQL vs PostgreSQL

Warehousing and MySQL vs PostgreSQL On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote: snip Information is deleted from this DW as well, after every five minutes. The data being recorded is time sensitive. As data ages, it may be deleted. Groups of samples are aggregated into a summary

Re: Data Warehousing and MySQL vs PostgreSQL

so much due to the large table size. -Original Message- From: Wallace Reis [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 1:02 AM To: Andrew Armstrong Cc: mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL On 7/26/07, Andrew Armstrong [EMAIL PROTECTED

RE: Data Warehousing and MySQL vs PostgreSQL

more concerned as to why inserts begin to slow down so much due to the large table size. -Original Message- From: Wallace Reis [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 1:02 AM To: Andrew Armstrong Cc: mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote: Do you have a suggestion to how this should be implemented? Data is aggregated over time and summary rows are created. I think that you didnt design correctly your DW. It should have just one very larger table (the fact table). Data should

RE: Data Warehousing and MySQL vs PostgreSQL

To: Andrew Armstrong Cc: 'Wallace Reis'; mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL Wallace is right, Data Warehousing shouldn't delete any data. MySQL isn't as robust as say, Oracle, for partitioning so you need to fudge things a little. I think partitioning

MySQL vs PostgreSQL

Hi, What do you think about MySQL vs PostgreSQL ? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL vs PostgreSQL

March 2005 8:20 PM To: mysql@lists.mysql.com Subject: MySQL vs PostgreSQL Hi, What do you think about MySQL vs PostgreSQL ? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing

Re: MySQL vs PostgreSQL

On Tue, 15 Mar 2005 18:49:38 +0900 ninjajs [EMAIL PROTECTED] wrote: What do you think about MySQL vs PostgreSQL ? Both are great products and have their ups and downs. On a MySQL list you will not get an un-biases answer to this question. If you really want to know what people on the MySQL

Re: mysql vs postgresql

At 05:45 PM 2/24/2005, you wrote: hi, just want to know the main benefits of mysql over postgresql. thanks, Payam Shabanian Payam, The differences between the products are narrowing, especially with MySQL 5.0 which is still in beta. If I could sum it up in 1 sentence then MySQL

Re: mysql vs postgresql

On Fri, 25 Feb 2005 11:21:26 -0600, mos wrote: http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/MySQL-PostgreSQL_features.html There is a reason this page was removed from the MySQL site: some of it was never correct in the first place, and the rest was severly outdated. Don't you

Re: mysql vs postgresql

On Fri, Feb 25, 2005 at 06:43:50PM +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Don't you think it is childish to link to documentation from 2003? I've never seen a child do anything like you describe. -Rich -- Rich Lafferty

Re: mysql vs postgresql

Hello. You should search in archives for such questions. For example see threads at: http://lists.mysql.com/mysql/160972 http://lists.mysql.com/mysql/170673 shabanip [EMAIL PROTECTED] wrote: hi, just want to know the main benefits of mysql over postgresql. thanks, Payam

mysql vs postgresql

hi, just want to know the main benefits of mysql over postgresql. thanks, Payam Shabanian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Running MySQL and PostgreSQL on the same hardware

Hi All, Does anyone have any experience of running MySQL and PostgreSQL on the same hardware? At the moment we have several reasonable fast servers (dual Xeon GHz, 1GB ram, 15,000rpm scsi disk) running MySQL in a replicated environment with high volumes of queries (high read:write ratio) and I

RE: Running MySQL and PostgreSQL on the same hardware

a month. Kevin Cowley RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 10:47 To: [EMAIL PROTECTED] Subject: Running MySQL and PostgreSQL on the same

RE: Running MySQL and PostgreSQL on the same hardware

10:53 To: Andrew Braithwaite; [EMAIL PROTECTED] Subject: RE: Running MySQL and PostgreSQL on the same hardware Andrew I've done it but only in a test environment. I actually had 3 different versions of Mysql running plus Postgres. Each of the Mysql's and Postgress were installed to /opt/database

RE: Running MySQL and PostgreSQL on the same hardware

Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:10 To: [EMAIL PROTECTED] Subject: RE: Running MySQL and PostgreSQL on the same hardware Thanks Kevin, I am comfortable with the software installs etc.. I was more concerned with hardware bottlenecks and OS

Re: MySQL vs. PostgreSQL -- speed test

Hi! First of all, if I decide to benchmark MySQL vs. PostgreSQL with my application, PostgreSQL will probably be faster. That does not mean that MySQL is generally slower or that I *want* it to look slower. That just means 1) I have no experience in tuning MySQL 2) My application was built

Re: MySQL vs. PostgreSQL -- speed test

MySQL has posted a very interesting comparison on their website. It appears to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some areas and MySQL was faster than PostgreSQL in most areas. For speed with all of that functionality, I'd be more inclined to look at DB2

MySQL vs. PostgreSQL -- speed test

Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL

Re: MySQL vs. PostgreSQL -- speed test

Marek Lewczuk wrote: For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. That's a bit of an overstatement! Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought

RE: MySQL vs. PostgreSQL -- speed test

If maximum speed is critical. It's easy to lose sight of the fact that speed is not the only criterion in choosing a DBMS. Features, stability, security, and so on can be just as important or more so. No single DBMS is going to win all the prizes; the trick is to find the one with

RE: MySQL vs. PostgreSQL -- speed test

which PostgreSQL version have you testet? If you want compare MySQL and PostgreSQL, than you have to use InnoDB tables. Tests with MyISAM make no sense. Out J2EE Application is working woth PostgreSQL 7.3.3 and MySQL 4.0.13 with InnoDB tables (we need transactions and referencial

RE: MySQL vs. PostgreSQL -- speed test

Very smart your opinion, I agree at all with you. -Mensaje original- De: Bruce Feist [mailto:[EMAIL PROTECTED] Enviado el: Monday, July 14, 2003 5:37 AM Para: MySQL List Asunto: Re: MySQL vs. PostgreSQL -- speed test Marek Lewczuk wrote: For everyone who thinks about moving from MySQL

RE: MySQL vs. PostgreSQL -- speed test

If maximum speed is critical. It's easy to lose sight of the fact that speed is not the only criterion in choosing a DBMS. Features, stability, security, and so on can be just as important or more so. No single DBMS is going to win all the prizes; the trick is to find the one with

RE: MySQL vs. PostgreSQL -- speed test

I agree with your opinion in 100%, but in my case I need DBMS with features like subselectes/utf-8/stored procedures but the speed is also very important issue. You might have to spend money! You are saying that there is DBMS with all this features and it is as fast as MySQL ? --

RE: MySQL vs. PostgreSQL -- speed test

I agree with your opinion in 100%, but in my case I need DBMS with features like subselectes/utf-8/stored procedures but the speed is also very important issue. You might have to spend money! You are saying that there is DBMS with all this features and it is as fast as MySQL ? I don't

Re: MySQL vs. PostgreSQL -- speed test

I agree with your opinion in 100%, but in my case I need DBMS with features like subselectes/utf-8/stored procedures but the speed is also very important issue. You might have to spend money! You are saying that there is DBMS with all this features and it is as fast as MySQL ? I don't

RE: MySQL vs. PostgreSql -- speed test

When I benchmarked PostgreSql against MySql for my application, MySql was 15 times faster, so 18% wouldn't make much difference for me! Andy -Original Message- From: Robson Oliveira [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 15:35 To: [EMAIL PROTECTED] Subject: Re: MySQL vs

Re: MySQL vs. PostgreSQL -- speed test

As a minor side issue, we did some _very limited_ testing with MS SQLServer 2000 using unicode v ascii queries. Using unicode, queries tended to run at about half the speed compare to using ascii. This was client server, so it is likely that the increased network traffic is to blame, but

MySQL vs. PostgreSQL recent article?

Hi, Does anybody know of any MySQL vs. PostgreSQL recent article? I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x Thanks in advance, Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL or PostgreSQL

Hi! I've just started working in Linux, but I'd like to know which database is better to use, MySQL or PostgreSQL. Which one would be better in the long run? -- Regards, Neil - Before posting, please check: http

Re: MySQL or PostgreSQL

As with most things, depends on what you want to do, what are the requirements ? Jerry - Original Message - From: InfoSysNCA [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 28, 2003 5:23 PM Subject: MySQL or PostgreSQL Hi! I've just started working in Linux, but I'd

RE: MySQL or PostgreSQL

:24 AM To: [EMAIL PROTECTED] Subject: MySQL or PostgreSQL Hi! I've just started working in Linux, but I'd like to know which database is better to use, MySQL or PostgreSQL. Which one would be better in the long run? -- Regards, Neil

RE: MySQL or PostgreSQL

. -Original Message- From: InfoSysNCA [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 11:24 AM To: [EMAIL PROTECTED] Subject: MySQL or PostgreSQL Hi! I've just started working in Linux, but I'd like to know which database is better to use, MySQL or PostgreSQL. Which one would be better

Re: MySQL or PostgreSQL

Neil, Hi! I've just started working in Linux, but I'd like to know which database is better to use, MySQL or PostgreSQL. Which one would be better in the long run? I guess about anyone on this list will scream Postgre is better, but let me make an exception. Some people consider Postgre

MySQL vs. PostgreSQL [was Re: What sites?]

Philip Johannessen wrote: Im currently in a debate with someone who prefers PostgreSQL. He says that MySQL is unstable etc. Can you please give me examples of some well known sites built on MySQL so I can tell him that MySQL rocks? PostgreSQL: Unless something has changed in the more recent