public inbox for [email protected]help / color / mirror / Atom feed
Post Oracle to Postgres migartion 7+ messages / 4 participants [nested] [flat]
* Post Oracle to Postgres migartion @ 2025-07-31 10:18 Raj <[email protected]> 0 siblings, 2 replies; 7+ messages in thread From: Raj @ 2025-07-31 10:18 UTC (permalink / raw) To: Pgsql-admin <[email protected]> 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 ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Post Oracle to Postgres migartion @ 2025-07-31 13:26 Ron Johnson <[email protected]> parent: Raj <[email protected]> 1 sibling, 0 replies; 7+ messages in thread From: Ron Johnson @ 2025-07-31 13:26 UTC (permalink / raw) To: Pgsql-admin <[email protected]> On Thu, Jul 31, 2025 at 6: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 > 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? -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster! ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Post Oracle to Postgres migartion @ 2025-07-31 14:17 Kamal Lekan AbdulWahab <[email protected]> parent: Raj <[email protected]> 1 sibling, 1 reply; 7+ messages in thread From: Kamal Lekan AbdulWahab @ 2025-07-31 14:17 UTC (permalink / raw) To: Raj <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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 > ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Post Oracle to Postgres migartion @ 2025-07-31 19:37 DINESH NAIR <[email protected]> parent: Kamal Lekan AbdulWahab <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: DINESH NAIR @ 2025-07-31 19:37 UTC (permalink / raw) To: Kamal Lekan AbdulWahab <[email protected]>; Raj <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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]<mailto:[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 ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Post Oracle to Postgres migartion @ 2025-07-31 21:18 Raj <[email protected]> parent: DINESH NAIR <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Raj @ 2025-07-31 21:18 UTC (permalink / raw) To: DINESH NAIR <[email protected]>; +Cc: Kamal Lekan AbdulWahab <[email protected]>; Pgsql-admin <[email protected]> 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 > > ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Post Oracle to Postgres migartion @ 2025-08-11 16:16 Raj <[email protected]> parent: Raj <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Raj @ 2025-08-11 16:16 UTC (permalink / raw) To: DINESH NAIR <[email protected]>; +Cc: Kamal Lekan AbdulWahab <[email protected]>; Pgsql-admin <[email protected]> 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, <[email protected]> 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, <[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 >> >> ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Post Oracle to Postgres migartion @ 2025-08-11 16:26 Ron Johnson <[email protected]> parent: Raj <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Ron Johnson @ 2025-08-11 16:26 UTC (permalink / raw) To: Pgsql-admin <[email protected]> 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 PM Raj <[email protected]> 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 sequence > of objects to be restored? > > > On Fri, 1 Aug 2025, 02:48 Raj, <[email protected]> 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, <[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 >>> >>> -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster! ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2025-08-11 16:26 UTC | newest] Thread overview: 7+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-07-31 10:18 Post Oracle to Postgres migartion Raj <[email protected]> 2025-07-31 13:26 ` Ron Johnson <[email protected]> 2025-07-31 14:17 ` Kamal Lekan AbdulWahab <[email protected]> 2025-07-31 19:37 ` DINESH NAIR <[email protected]> 2025-07-31 21:18 ` Raj <[email protected]> 2025-08-11 16:16 ` Raj <[email protected]> 2025-08-11 16:26 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox