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 1ulVMR-001jtE-DS for pgsql-admin@arkaria.postgresql.org; Mon, 11 Aug 2025 16:26:59 +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 1ulVMP-0029VV-Kr for pgsql-admin@arkaria.postgresql.org; Mon, 11 Aug 2025 16:26:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ulVMP-0029V9-6e for pgsql-admin@lists.postgresql.org; Mon, 11 Aug 2025 16:26:57 +0000 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ulVMM-0003H1-34 for pgsql-admin@lists.postgresql.org; Mon, 11 Aug 2025 16:26:57 +0000 Received: by mail-oo1-xc29.google.com with SMTP id 006d021491bc7-61997c8e2a1so2663427eaf.1 for ; Mon, 11 Aug 2025 09:26:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754929613; x=1755534413; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=LocSLIcsyghQNmCi5BbEHgvdPq1rMigfpizPOz6ShqI=; b=ZrZkVoQ8tzFxwMAJYw68MicMMKtYXY2jqsITSzn8qSTbe+GDGnxMiUyhKMUGBtQYEq SDueI1VwhwbrlOdchx694nOJGclsxFNXjRzFLJWRQ0MH3DQB++pc0tglEK2DsprQ7Zve XSlyaSExaQB6T8kgdBBB6JQgugr2K6YgvznBC51PfApyBaKfjgIoRs7s3F2eloab9kqX f2bUtxW1d/FMah8HxoPnLxRnZiVGeJv2mR5UdaeAmf/m8IEddLuJDCFyAt5nQ/Lm7pSF 0+lmsYuKXV+2m4M5kYbf72HCcZjxW+lGDaAhojW3GR1qcxtIXrsrdGmyHFZo3hY6F9KD 3qrg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754929613; x=1755534413; h=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=LocSLIcsyghQNmCi5BbEHgvdPq1rMigfpizPOz6ShqI=; b=phnu+rDgmvRl6XvtPnBYHpPvTSs6Jq33Z4twnIcBNO/h+2iYDx0M3yORBT/7SnECKL oYOP88cRZtAy3q6FsxvaFiDJl3EzyfC6JoBpvukQ2Yc8FLTHkbK5CYUeH7VJ/pEUbXUm JrkSA6WsQ0gPmF/ICC94lDj5zF6Rm4w4j/apVTvMq0w/gue0TgwgjtKDwzlLTQf99Swv PLh91aScqQlEUAUxb4mt5hvUg+NWjRdf7Gh22PZfnVjEME4gNMMWGpLLlkTySZSgoINS fHNmrUpmL+pEfRwkBtrO/TnHInNkKHY483TDXT3KlUoyV9XblofuWhwg3du/UtGczX6/ NltQ== X-Gm-Message-State: AOJu0YxBuhVBKhbuZqN8+TOqte51aZVTv15GdCI4DfmH423aB2CbaZg7 mKZEYSaXf9+i4Q+8P6bVkr9t0sv2S7hfNThj4uyL/YGrmwQLxnKyxkB1dESKxUquus9gRkq4s6p BYrdMW22/IJRW+b2Tzwc3m9tK+BR+JVRFBw== X-Gm-Gg: ASbGncuFmGdp9MyohmkLjOhBunElxH5dfQ2wfDmhpBVdYvA4A+snPCH9GTdnfZwo/TF ixdyjRhy1Dlzc36RcOKV9tRG3hcRvp/6BB0pBB9RHdfQCfAg/Q5RsFQSG8ysBsHGpogiZbPqjto Du4+RqqZrbR3vozQ+Yals0qQjeDfJRNaDsnvCOvUTFg1pJWsEDJne/5HRr/n/E0u20hNzqdosHl Z8vZwVh X-Google-Smtp-Source: AGHT+IFQEfv3v7lxKhav1kFK1B8gA03Aeyd41X8uBk1W2kxFPMvohuVgTe7+qBaqdta/Tda7zhLqtArL9ONMJjPVI+4= X-Received: by 2002:a05:6820:810:b0:61b:9c4b:4fe9 with SMTP id 006d021491bc7-61bb6407540mr142869eaf.1.1754929613124; Mon, 11 Aug 2025 09:26:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 11 Aug 2025 12:26:42 -0400 X-Gm-Features: Ac12FXzSjwcKller2L66TOOqTG-4jFw5yPAA9Yi823PZa81t27AzD4wkMxdg-Co Message-ID: Subject: Re: Post Oracle to Postgres migartion To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000032371c063c196475" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000032371c063c196475 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Create as little as possible before loading data. (The more indices there are on a table, the longer it takes to insert a record; having FK constraints means not only having to perform the check, but the records might not exist in the referenced table, etc, etc) On Mon, Aug 11, 2025 at 12:16=E2=80=AFPM Raj = wrote: > When using Ora2pg after taking dump of objects...while restoring which > objects should I start first and can somebody help me with list of sequen= ce > 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 >>> 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 >>> *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 an= d >>> 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, vacu= um >>> analyze etc >>> >>> --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000032371c063c196475 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Create as little=C2=A0as possible before=C2=A0loading= data.=C2=A0 (The more indices there are on a table, the longer it takes to= insert a record; having FK constraints means not only having to perform th= e check, but the records might not exist in the referenced table, etc, etc)=

On Mon, Aug 11, 2025 at 12:16=E2=80=AFPM Raj <rajeshkumar.dba09@gmail.com&= gt; wrote:
When using Ora2pg after taking dump of objects...while restori= ng which objects should I start first and can somebody help me with list of= sequence of objects to be restored?


<= div class=3D"gmail_quote">
On Fri, 1 A= ug 2025, 02:48 Raj, <rajeshkumar.dba09@gmail.com> wrote:
Thank you All. I= n my env, darold himself is already doing migration,=C2=A0 I just wanted to= be ready with post migration steps .

<= div dir=3D"ltr" class=3D"gmail_attr">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.abdulwahab@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


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--00000000000032371c063c196475--