Re: [GENERAL] Migrating from MySQL

2010-06-26 Thread John R Pierce
On 06/26/10 11:22 PM, RP Khare wrote: I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should I go with the original community PGSQL edition or EnterpriseDB edition? thats entirely up to your preferences and needs.Personally, I think that the standard PostgreSQL wou

Re: [GENERAL] Migrating from MySQL

2010-06-26 Thread Alex Hunsaker
On Sun, Jun 27, 2010 at 00:22, RP Khare wrote: > I want to migrate a production MySQL database to PostgreSQL. Is there any > free tool that works effectively? I'd start here: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL -- Sent via pgsql-general mailing li

[GENERAL] Migrating from MySQL

2010-06-26 Thread RP Khare
I want to migrate a production MySQL database to PostgreSQL. Is there any free tool that works effectively? I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should I go with the original community PGSQL edition or EnterpriseDB edition? Regards, Rohit Prakash

Re: [GENERAL] Any problem with the Long Integer type?

2010-06-26 Thread Pavel Stehule
2010/6/27 Joshua D. Drake : > On 6/26/2010 1:25 PM, Pavel Stehule wrote: >> >> Hello >> >> 2010/6/26: >> >>> >>> About four five years ago, I had received a few of emails about the data >>> type problems on this mailing list. I believe that the problem was about a >>> performance issue. Is any prob

Re: [GENERAL] Any problem with the Long Integer type?

2010-06-26 Thread Joshua D. Drake
On 6/26/2010 1:25 PM, Pavel Stehule wrote: Hello 2010/6/26: About four five years ago, I had received a few of emails about the data type problems on this mailing list. I believe that the problem was about a performance issue. Is any problem withe the Long Integer type in the late releas

Re: [GENERAL] Any problem with the Long Integer type?

2010-06-26 Thread Pavel Stehule
Hello 2010/6/26 : > > About four five years ago, I had received a few of emails about the data type > problems on this mailing list. I believe that the problem was about a > performance issue. Is any problem withe the Long Integer type in the late > releases? There is no reason why Long can b

[GENERAL] Any problem with the Long Integer type?

2010-06-26 Thread wei725
About four five years ago, I had received a few of emails about the data type problems on this mailing list. I believe that the problem was about a performance issue. Is any problem withe the Long Integer type in the late releases? Thanks, - w -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] pl-perl for 64 bits in Solaris 9

2010-06-26 Thread Felipe de Jesús Molina Bravo
2010/6/25 John R Pierce > On 06/25/10 9:28 PM, Felipe de Jesús Molina Bravo wrote: > >> original perl is 5.6. so i installed perl 5.8.9 for 64 bit and the >> error is the same... maybe my error is with the compiler, it is "gcc" >> (3.4.6). is it possible? >> > > where did this 64bit 5.8.9 c

Re: [GENERAL] PG dump and restore

2010-06-26 Thread Thom Brown
On 26 June 2010 00:59, Dennis C wrote: > OK well the gunzip seemed to "do the trick," but I don't recall before > having to do anything other than run the pg_restore command.  Anyway, thanks > to everyone for all your help! > > > On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver > wrote: >> >> On 0

[GENERAL] EDB editions

2010-06-26 Thread RP Khare
Hi, What is the difference between PGSQL provided by www.postgresql.org and www.enterprisedb.com? EnterpriseDB offers three variants: Simple PostgreSQLStandard Server, andAdvanced Server I want to migrate my production MySQL database to PostgreSQL. If I go for EnterpriseDB editions,