| From: | "Dilan Arumainathan" <dilan_a(at)impark(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Database migration |
| Date: | 2003-07-16 22:52:32 |
| Message-ID: | CFEJJBOGEDDKJMNKNGAPEEOMEDAA.dilan_a@impark.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
I am trying to migrate a database from Oracle to Postgresql. I am using the
PgAdmin database migration wizard (1.5.60-Dev) to do this. Using ODBC I am
able to migrate small tables but I have a few tables that have over 10
million rows that are failing. I know the reason as I am getting an
"Snapshot too old" error from Oracle but am unable to come up with a
workaround. I prefer using the wizard as it takes care of nulls etc. which I
might have to handle if I went the dump and load route. Can someone give me
an idea on getting around this (other than preventing updates to Oracle).
Also, is there a way to turn off WAL while loading bulk data.
thanks
dilan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-16 23:21:28 | Re: Database migration |
| Previous Message | Andrew Biagioni | 2003-07-16 22:37:52 | Re: [HACKERS] problems with pg_restore |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-16 23:21:28 | Re: Database migration |
| Previous Message | Tom Lane | 2003-07-16 22:52:18 | Re: postmaster startup failure |