Migrating Informix to PostgreSQL

Victor Dario Martinez

unread,

Sep 30, 2004, 1:01:38 PM9/30/04

to

Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.

Any info will very very important .

Thanks !!

sending to informix-list

Obnoxio The Clown

unread,

Sep 30, 2004, 1:50:37 PM9/30/04

to

Victor Dario Martinez said:
> Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
> Any info will very very important .

Start looking for another job.

--
Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"I'm trying to see things your way, but I can't get my head up my ass"
- JCH

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco

http://www.catb.org/~esr/faqs/smart-questions.html
sending to informix-list

Scott Burns

unread,

Sep 30, 2004, 7:12:56 PM9/30/04

to

Victor Dario Martinez wrote:

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

My Name Is Bruce and I'm A Sock Puppet

unread,

Sep 30, 2004, 7:13:50 PM9/30/04

to

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!

Scott Burns

unread,

Sep 30, 2004, 7:36:56 PM9/30/04

to

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.

Andrej Falout

unread,

Oct 1, 2004, 9:58:40 AM10/1/04

to

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 =---

Jean Sagi

unread,

Oct 1, 2004, 10:23:13 AM10/1/04

to

;)

-----Original Message-----
From: "Neil Truby" <neil....@ardenta.com>
To: inform...@iiug.org
Date: Thu, 30 Sep 2004 22:45:17 +0100
Subject: Re: Migrating Informix to PostgreSQL

"Victor Dario Martinez" <dmar...@siu.edu.ar> wrote in message
news:cjhie1$da6$1...@news.xmission.com...

>
> Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
> Any info will very very important .
>
> Thanks !!
>
> sending to informix-list

http://www.jobcentreplus.gov.uk

Jean Sagi
jean...@myrealbox.com
jean...@yahoo.com

sending to informix-list

Jean Sagi

unread,

Oct 1, 2004, 10:24:21 AM10/1/04

to

;) ;)

-----Original Message-----
From: "My Name Is Bruce and I'm A Sock Puppet" <god...@downundah.com>
To: inform...@iiug.org
Date: Thu, 30 Sep 2004 22:54:28 +0100
Subject: 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 !!

http://dir.yahoo.com/Regional/Countries/Argentina/Business_and_Economy
Shopping_and_Services/Employment/

--
Strewth! Stick a sock in it, Sheila!

Adam Tauno WIlliams

unread,

Oct 1, 2004, 12:16:47 PM10/1/04

to

> 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.

Your right. Our groupware system (OpenGroupware) uses a PostrgeSQL
back-end; and it handles **WAY** more transactions than that without
any problems whatsoever.

PostgreSQL just sucks for LARGE databases because it lacks table
spaces. It also lacks anything resembling real administrative tools.

But you do need to learn it, and tune it, like any other database (which
can be MUCH harder, minus those aforementioned tools).

sending to informix-list

Walter Haslbeck

unread,

Oct 1, 2004, 3:25:02 PM10/1/04

to

Adam Tauno WIlliams <ad...@morrison-ind.com> wrote:

> PostgreSQL just sucks for LARGE databases because it lacks table
> spaces. It also lacks anything resembling real administrative tools.

If the lack of table spaces is really your problem, just wait
for the upcomming 8.0 (beta3 is out now), which supports
this feature.

Walter

Mark D. Stock

unread,

Sep 30, 2004, 5:50:44 PM9/30/04

to

Victor Dario Martinez wrote:
> Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
> Any info will very very important .

I know a couple of tools that tried to migrate Informix to PostgreSQL....,
but that's another story. ;-)

I don't know of any tools to do the migration for you. The PostgreSQL SQL
is a cross between Informix & Oracle, but leans heavily to the Informix
side if you use object relational SQL, because it's basically the same. I
think a little bit of sed and awk will get the job done quite quickly. As
for SPL, that is very different, but then aren't they all.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mds...@MydasSolutions.com |//////// /|
| http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list

Scott Burns

unread,

Oct 3, 2004, 7:25:17 PM10/3/04

to

Andrej Falout wrote:

>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
>
>
>
>

Thanks for that link. I've thought of two more issues over the
weekend but hopefully your link will help:

1) ecpg will not allow you to prepare a statement until you have a
database open. This means you cannot determine database at runtime
unless you use the core C function to do it.

2) ecpg does not allow arrays of host variables. My boss noticed this
so I'm not too sure of any extra details.

Neil Truby

unread,

Sep 30, 2004, 5:45:17 PM9/30/04

to

"Victor Dario Martinez" <dmar...@siu.edu.ar> wrote in message
news:cjhie1$da6$1...@news.xmission.com...
>

http://www.jobcentreplus.gov.uk

My Name Is Bruce and I'm A Sock Puppet

unread,

Sep 30, 2004, 5:54:28 PM9/30/04

to

Victor Dario Martinez wrote:

>
> Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
> Any info will very very important .
>
> Thanks !!

http://dir.yahoo.com/Regional/Countries/Argentina/Business_and_Economy

Mike Aubury

unread,

Oct 7, 2004, 10:29:19 AM10/7/04

to

If you're going via 4GL then Aubit4GL takes care of both of these issues (as
well as a lot more - for example, putting in the 'AS' for column aliases
and re-writing UPDATE statements in ANSI syntax) .

We've already successfully migrated a large system from Informix SE to
Postgres with just a few 4gl source code changes..

This example program :

main
define lv_arr array[10] of char(1)
define lv_mydb char(64)
let lv_mydb=arg_val(1)

database lv_mydb
create table bibble( a integer)
insert into bibble values(1)

select a into lv_arr[4] from bibble

display lv_arr[4]
end main

Compiles and runs fine with Aubit4GL talking to a postgres database via ecpg

If doing it directly in esqlc/ecpg -

1) the variable in a database statement - you don't prepare it you
'connect'
EXEC SQL CONNECT TO $s AS 'sessionname';

2) Select into a variable then copy it to the array afterwards.