From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: Unending DB migration
Date: Sat, 21 Apr 2012 01:48:50 +0200
Message-ID: <jmsskr$phh$1@dough.gmane.org> (raw)
In-Reply-To: <CAK1h3NoEESan7pOyHukyZSM9oL1S6Y0w=qVqnBP-YWDj2pVqWQ@mail.gmail.com>
References: <CAK1h3NoEESan7pOyHukyZSM9oL1S6Y0w=qVqnBP-YWDj2pVqWQ@mail.gmail.com>
ЇЯЅHAÐ wrote on 17.04.2012 01:27:
> Hi,
>
> We are trying to migrate from Postgres to Oracle, although our DB is gigantic
> but we started on Mar 14th 2012 & its still running with an average of 400000 records per day
>
> How can we check what is going wrong.
> Any memory leak, CPU issue or anything.
If you are migrating *to* Oracle, then you should probably ask this question in an Oracle forum.
Or is it the reading of the old data that is that slow?
But anyway: without a lot more information about *how* you do the migration nobody will be able to help you
Which program(s) do you use to migrate the data?
What type of connection do you have between the two servers?
What exactly is slow (inserting into Oracle, selecting from Postgres?)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: spam_eater@gmx.net
Subject: Re: Unending DB migration
In-Reply-To: <jmsskr$phh$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox