Re: Post Oracle to Postgres migartion

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, <Dinesh_Nair(at)iitmpravartak(dot)net>
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 <dba(dot)abdulwahab(at)gmail(dot)com>
> *Sent:* Thursday, July 31, 2025 7:47 PM
> *To:* Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
> *Cc:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: Post Oracle to Postgres migartion
>
> You don't often get email from dba(dot)abdulwahab(at)gmail(dot)com(dot) 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 <rajeshkumar(dot)dba09(at)gmail(dot)com> 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
>
>