Re: Migrating Informix to PostgreSQL
Scott Burns said his company was evaluating moving from SE to PostgreSQL; the main gotcha was needing transactions, since committing closes all open cursors. Asked about performance, he said his sites' load is light and that SE support cost and platform hoops were the real drivers. Andrej Falout pointed to an Informix compatibility patch for PostgreSQL and an ecpg compiler. No firm conclusion.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 =---