Re: Post Oracle to Postgres migartion

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Raj <[email protected]>
To: DINESH NAIR <[email protected]>
Cc: Kamal Lekan AbdulWahab <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Post Oracle to Postgres migartion
Date: Fri, 1 Aug 2025 02:48:44 +0530
Message-ID: <CAJk5Atao0y5ctNFv3oeq0fsemL+44KsucUqY2CEQstP5DF=V7g@mail.gmail.com> (raw)
In-Reply-To: <PN4P287MB4381DBD6FDC7B959956CA9F09C27A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>
References: <CAJk5Atb+2r430wJqONZLLYvR0ZWcQ8qPc1uuoqZGao_O2wLrrA@mail.gmail.com>
	<CA+B9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ@mail.gmail.com>
	<PN4P287MB4381DBD6FDC7B959956CA9F09C27A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>

Thank you All. In my env, darold himself is already doing migration,  I
just wanted to be ready with post migration steps .

On Fri, 1 Aug 2025, 01:07 DINESH NAIR, <[email protected]>
wrote:

> Hi ,
>
>
>
> >> That "etc" is everything except what you didn't explicitly list. 😉
>
> >>Did you create all the same indices and triggers?
> >> Did you convert all NUMERIC and NUMERIC(38,0) to BIGINT in Ora2pg?
>
> Best practice followed for migration :
>
>
>    1. First perform table data migration. Row count verification between
>    source and target tables. Random data checks between source and target at
>    row level.
>    2. Applying primary key, constraints and indexes
>    3. Applying triggers
>    4. Then sequences migration
>    5. Database configuration: configuration of postgres.config ,
>    shared_buffers, max_connections, configuring maintenace jobs
>    6. Setting user roles and permissions
>
>
>
>
> Regards
>
> Dinesh Nair
>
>
> ------------------------------
> *From:* Kamal Lekan AbdulWahab <[email protected]>
> *Sent:* Thursday, July 31, 2025 7:47 PM
> *To:* Raj <[email protected]>
> *Cc:* Pgsql-admin <[email protected]>
> *Subject:* Re: Post Oracle to Postgres migartion
>
> You don't often get email from [email protected]. Learn why this
> is important <https://aka.ms/LearnAboutSenderIdentification;
> Caution: This email was sent from an external source. Please verify the
> sender’s identity before clicking links or opening attachments.
> You can look at SEQUENCES if they are out of sync with values in Oracle.
> Sometimes, they also affect auto-increment columns. Have you checked and
> recreated all users accounts? Passwords do not copy over automatically.
>
> On Thu, Jul 31, 2025 at 3:19 AM Raj <[email protected]> wrote:
>
> Hi All,
>
> Post Oracle to Postgres Migration using Ora2pg, as a dba what activites we
> may have to perform apart from checking count of objects, rows, vacuum
> analyze etc
>
>

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Post Oracle to Postgres migartion
  In-Reply-To: <CAJk5Atao0y5ctNFv3oeq0fsemL+44KsucUqY2CEQstP5DF=V7g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox