Re: [GENERAL] Ingres to Postgres migration

2014-04-30 Thread Michael Bostock
Wow, thanks for the swift response and a lot of detailed advice! I will look further into what you have suggested and see what bits I can take forward with our migration. Thanks a lot, Mike On 30 April 2014 15:14, Andy Colson wrote: > On 4/30/2014 8:34 AM, Jeff Johnston wrote: > >> We moved fr

Re: [GENERAL] Ingres to Postgres migration

2014-04-30 Thread Andy Colson
On 4/30/2014 8:34 AM, Jeff Johnston wrote: We moved from Oracle to PostgreSQL recently and just used the \copy command with csv files. To get the data out of oracle we wrote a small php script to connect to Oracle and then generate the csv files. The way it works is each csv file represented a da

Re: [GENERAL] Ingres to Postgres migration

2014-04-30 Thread Jeff Johnston
We moved from Oracle to PostgreSQL recently and just used the \copy command with csv files. To get the data out of oracle we wrote a small php script to connect to Oracle and then generate the csv files. The way it works is each csv file represented a database table. The copy command is amazingly f

[GENERAL] Ingres to Postgres migration

2014-04-30 Thread Michael Bostock
Hi, We are using an old version of Ingres (3.0.1) and I have been asked to investigate the possibility of migrating to PostgreSQL (9.3.4). I was just wondering if there is any general advice you can give me or if there are any details/tools that will help with the migration. Thanks, Mike