pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnending DB migration
5+ messages / 5 participants
[nested] [flat]
* Unending DB migration
@ 2012-04-16 23:27 ЇЯЅHAÐ <irshad.nazir@gmail.com>
0 siblings, 4 replies; 5+ messages in thread
From: ЇЯЅHAÐ @ 2012-04-16 23:27 UTC (permalink / raw)
To: pgsql-admin
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.
Please help me fix it
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unending DB migration
@ 2012-04-19 15:20 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: ЇЯЅHAÐ <irshad.nazir@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Devrim GÜNDÜZ @ 2012-04-19 15:20 UTC (permalink / raw)
To: ЇЯЅHAÐ <irshad.nazir@gmail.com>; +Cc: pgsql-admin
On Mon, 2012-04-16 at 16:27 -0700, ЇЯЅHAÐ wrote:
>
>
> We are trying to migrate from Postgres to Oracle,
Hmm.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unending DB migration
@ 2012-04-19 15:33 Peter Steinheuser <psteinheuser@myyearbook.com>
parent: ЇЯЅHAÐ <irshad.nazir@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Peter Steinheuser @ 2012-04-19 15:33 UTC (permalink / raw)
To: ЇЯЅHAÐ <irshad.nazir@gmail.com>; +Cc: pgsql-admin
Need more info.
How is Postgres setup, what version.
How are you migrating?
How is Oracle setup, what version.
Etc.
2012/4/16 ЇЯЅHAÐ <irshad.nazir@gmail.com>
> 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.
>
> Please help me fix it
>
>
>
--
Peter Steinheuser
psteinheuser@myyearbook.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unending DB migration
@ 2012-04-20 23:21 Walter Hurry <walterhurry@lavabit.com>
parent: ЇЯЅHAÐ <irshad.nazir@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Walter Hurry @ 2012-04-20 23:21 UTC (permalink / raw)
To: pgsql-admin
On Mon, 16 Apr 2012 16:27:38 -0700, ЇЯЅHAÐ wrote:
> 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
400,000? That's pathetic. Why didn't you just use Postgres's "copy to"
CSVS and then Oracle's SQL*Loader?
How big is "gigantic"?
> How can we check what is going wrong.
> Any memory leak, CPU issue or anything.
>
> Please help me fix it Hi,<br><br>We are trying to migrate from Postgres
> to Oracle, although our DB is gigantic<br>but we started on Mar 14th
> 2012 & its still running with an average of 400000 records per
> day<br><br>How can we check what is going wrong.<br>
> Any memory leak, CPU issue or anything.<br><br clear="all">Please help
> me fix it<br><br><br>
Please don't post in HTML.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unending DB migration
@ 2012-04-20 23:48 Thomas Kellerer <spam_eater@gmx.net>
parent: ЇЯЅHAÐ <irshad.nazir@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Thomas Kellerer @ 2012-04-20 23:48 UTC (permalink / raw)
To: pgsql-admin
ЇЯЅ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?)
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2012-04-20 23:48 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-04-16 23:27 Unending DB migration ЇЯЅHAÐ <irshad.nazir@gmail.com>
2012-04-19 15:20 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2012-04-19 15:33 ` Peter Steinheuser <psteinheuser@myyearbook.com>
2012-04-20 23:21 ` Walter Hurry <walterhurry@lavabit.com>
2012-04-20 23:48 ` Thomas Kellerer <spam_eater@gmx.net>
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