Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ulVCI-001gwN-Ge for pgsql-admin@arkaria.postgresql.org; Mon, 11 Aug 2025 16:16:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ulVCF-0024Y8-0q for pgsql-admin@arkaria.postgresql.org; Mon, 11 Aug 2025 16:16:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ulVCE-0024Vp-E1 for pgsql-admin@lists.postgresql.org; Mon, 11 Aug 2025 16:16:26 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ulVCC-0002mo-05 for pgsql-admin@lists.postgresql.org; Mon, 11 Aug 2025 16:16:25 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-55ba26abd62so5178882e87.1 for ; Mon, 11 Aug 2025 09:16:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754928983; x=1755533783; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=fy/An5nU1QvXw5+vsIlgRzfvFEJ5pzUJN70STL5AkHc=; b=B9oxujW5x6CkBt4ML+aWrTaMy4iILJnp47wIx8piK825vw4hg4eMVuWISjE36B7K66 n5J05fMpEGHedMZKr/B31LoIlDHGsj6MmTlCAHqzAPFp9m941PGKqfOQjXWNYi+q2FKA TqDBSCcGfKKxK5hZpb+IL9CHBvKRAKcAxxwQJQCBDBIFJ0qtrFOTT8lBTVo6/fyxZGs1 pruewlkStz2OCdi7RCiJbzJsQwib3edQHX/FaJCAaegIbeTsoXCdranrSw5vOrzX6VX+ z4UViAEIKswEh52fib4n7lm1Z+SU7yGcLzc1YzUxnBHvVKlTznpzOGRuBpwNqzhL24eb wbCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754928983; x=1755533783; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=fy/An5nU1QvXw5+vsIlgRzfvFEJ5pzUJN70STL5AkHc=; b=GtQADqSmLnyJNJBDBTOPqZCgHocn9i0w7frVR415hZpwt2UNH8b6tMMgZgONCT9+09 SNo8Rib8L4GUCZWATUkXN/R5hWbfRPKGv1abvUALvEcetOfpXQBQEBFsRFV51F7YbZqW OhDwdTl/3zzYar0fE/2nGihi8VcldPCE2LaDO51uai9RV+N0hubjKWL6WtCaOinIawOG IY1a6kqPV3Q1lSWDjSpLfGkEod00akx+yogwftVIHQeEiF2P52po8JzksEE0SZeGfc8i j7YnUSDUJoIgsQtyBk0XwgPoDipPRdwDQBVDPmg3Qp5v15KrQz0w2YVL6ChMsqK/FRN8 p7kQ== X-Forwarded-Encrypted: i=1; AJvYcCW+B9zLaefFuc/0sRkOiw+T/VB9GEpyDJcziq3tJ2m8b16KU4RTGfzMRC4XLfAOQx4Z0b+X1Qzc76PmPQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YxjyUt1KQLXwrRTCDyHwko1lrWpc1cjQWkJ1+XKD8SqxbkRlWTp SonPsbOKRwFBi3ygnq4/4xwuZLcZpat6AS6zDcd5uigizkj2Mk6RR9BaiZ5FC94Jjn0L1R2qDY9 bYHPFPczd/AA8ydMNOcz7F3UfHdcyClA= X-Gm-Gg: ASbGncvinPBwy2EmBzPbfvvs9woCfJ2KVT/GxZ88R9NHrNpDrbzvy1N+OpumVEpFwAD G1gUeGBwX4WqJWjkWyBV+C0Bf1WlJ+s8xwI4isY1GVlGkGpELe29cqVJjZ3h3j1PfssMlz3GvkC 5JhOLO1ozMQ4HP52flH6VJFJ91rt3mkvv6Uwql+8UBFRfKibgvr4JtWZR/hqtcx2EYh3BaY7yHo XmpI7G8 X-Google-Smtp-Source: AGHT+IEvY4q0ahQ8gBGPeNRpG8bvnEqtGFAoNts2d4CAH0fnz2LgUjDeSSJGTNc8isLKHJbmO9D2b8pHnMPdfCj+4JI= X-Received: by 2002:a05:6512:159f:b0:553:5176:48a with SMTP id 2adb3069b0e04-55cd7597400mr111461e87.21.1754928982420; Mon, 11 Aug 2025 09:16:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Raj Date: Mon, 11 Aug 2025 21:46:10 +0530 X-Gm-Features: Ac12FXzBq6Tx_DSmPSPPI13MTZ_mbzXjGYbTYHHaepp2JPt96GCKrwAZuPhgFQI Message-ID: Subject: Re: Post Oracle to Postgres migartion To: DINESH NAIR Cc: Kamal Lekan AbdulWahab , Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000009a740e063c193e28" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009a740e063c193e28 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable When using Ora2pg after taking dump of objects...while restoring which objects should I start first and can somebody help me with list of sequence of objects to be restored? On Fri, 1 Aug 2025, 02:48 Raj, wrote: > 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, > wrote: > >> Hi , >> >> >> >> >> That "etc" is everything except what you didn't explicitly list. =F0= =9F=98=89 >> >> >>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 targe= t 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 >> *Sent:* Thursday, July 31, 2025 7:47 PM >> *To:* Raj >> *Cc:* Pgsql-admin >> *Subject:* Re: Post Oracle to Postgres migartion >> >> You don't often get email from dba.abdulwahab@gmail.com. Learn why this >> is important >> Caution: This email was sent from an external source. Please verify the >> sender=E2=80=99s 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=E2=80=AFAM Raj 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, vacuu= m >> analyze etc >> >> --0000000000009a740e063c193e28 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
When using Ora2pg after taking dump of objects...while re= storing which objects should I start first and can somebody help me with li= st of sequence of objects to be restored?

=
On Fri, 1 Aug 2025, 02:48 Raj, <rajeshkumar.dba09@gmail.com> wrote:
=
Thank you All. In my env, = darold himself is already doing migration,=C2=A0 I just wanted to be ready = with post migration steps .

On Fri, 1 Aug 2025, 01:07 DINESH NAIR, <Dinesh_Nair@iitmpravartak.net> wrote:
Hi ,

=E2=80=82=E2=80=82=E2=80=82=E2=80=82
=C2=A0

=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82= =E2=80=82=E2=80=82=E2=80=82=E2=80=82>>=E2=80=82=E2=80=82That "etc" is everything except what you didn't explicitly list.= =C2=A0=F0=9F=98=89


>>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 ve= rification between source and target tables. Random data checks between sou= rce and target at row level.
  2. Applying primary key, constraints and indexes
  3. Applying triggers=C2=A0
  4. Then sequences migration=C2=A0
  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.abdul= wahab@gmail.com>
Sent: Thursday, July 31, 2025 7:47 PM
To: Raj <rajeshkumar.dba09@gmail.com><= br> Cc: Pgsql-admin <pgsql-admin@lists.postg= resql.org>
Subject: Re: Post Oracle to Postgres migartion
=C2=A0
Caution: This email was sent from a= n external source. Please verify the sender=E2=80=99s identity before click= ing links or opening attachments.
You can look at SEQUENCES if they are out of sync with val= ues in Oracle. Sometimes, they also affect auto-increment columns. Have you= checked and recreated all users accounts? Passwords do not copy over autom= atically.

On Thu, Jul 31, 2025 at 3:19=E2=80=AFAM Raj <rajeshkumar.dba09@gmail.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
--0000000000009a740e063c193e28--