Re: Migrating Informix to PostgreSQL

Victor Dario Martinez wrote: >Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL. > >Any info will very very important . > >Thanks !! > >sending to informix-list > > Hi, we are evaluating going from SE to Postgres. So far the biggest gotcha was having to use transactions, and the biggest gotcha with that was commiting work to the database closes all open cursors. How complicated are your database needs? -- Scott Burns Mirrabooka Systems Tel +61 7 3857 7899 Fax +61 7 3857 1368

Scott Burns wrote: > Victor Dario Martinez wrote: > >>Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL. >> >>Any info will very very important . >> >>Thanks !! >> >>sending to informix-list >> >> > Hi, > we are evaluating going from SE to Postgres. So far the biggest > gotcha was having to use transactions, and the biggest gotcha with that > was commiting work to the database closes all open cursors. So you haven't got to the performance testing part yet? -- Strewth! Stick a sock in it, Sheila!

My Name Is Bruce and I'm A Sock Puppet wrote: > > >So you haven't got to the performance testing part yet? > > > It's not really an issue. At our busiest site we would have maybe one database update to a single record every few seconds for most of the day. We have a period of reporting in the morning which prints to a dot matrix printer. I'm expecting Postgres to be faster than a dot matrix. End of week/season/year can take a while but we're still talking seconds under SE. Postgres can take minutes if it likes - copying the data offsite over the WAN is the real time hog. We have deployed Postgres twice in a limited capacity to sites with far less traffic and experienced no performance issues. Now compare that with the hoops we needed to jump through to get SE to run on RHEL3 or RH9, tack on a 50% hike in support and think about how many people are likely to be familiar with Postgres in 5 years as opposed to Informix. It's really going to come down to why Victor is looking to change, and performance may not be the reason. -- Scott Burns Mirrabooka Systems Tel +61 7 3857 7899 Fax +61 7 3857 1368

Guys; There is Informix compatibility patch for PG and ecpg compiler: http://gborg.postgresql.org/project/pginformix/projdisplay.php There is allready patched code available from: http://informix.fastcrypt.com/ Older RPM's: http://informix.postgresintl.com/ We are using them as part of Aubit 4GL compiler project. There is at least one company that is using them in production situation. HTH, Andrej Falout ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---