Disk Groups/Storage Management for a Large Database in PostgreSQL

2024-01-22 Thread Amit Sharma
Hi, We are building new VMs for PostgreSQL v15 on RHEL 8.x For a large database of 15TB-20TB. I would like to know from the experts that is it a good idea to create LVMs to manage storage for the database? Or are there any other better options/tools for disk groups in PostgreSQL, similar to ASM

Re: Disk Groups/Storage Management for a Large Database in PostgreSQL

2024-01-23 Thread Amit Sharma
management like add, resize or remove disks while PostgreSQL services are up? Is equal data distribution a challenge on LVM/ZFS disks? Thanks Amit On Tue, Jan 23, 2024 at 9:49 AM Scot Kreienkamp < scot.kreienk...@la-z-boy.com> wrote: > El lun, 22 ene 2024 18:44, Amit Sharma escribió: > >

Ora2pg Delta Migration: Oracle to PostgreSQL

2024-05-02 Thread Amit Sharma
Hello, Has anyone tried delta/incremental data migration for Oracle to PostgreSQL using Ora2pg? Or what are the best options to run delta migration for Oracle to PostgreSQL? Thanks Amit

Re: Ora2pg Delta Migration: Oracle to PostgreSQL

2024-05-03 Thread Amit Sharma
n can help in specifying >> filter (where clause). >> >> Regards, >> Ikram >> >> >> On Fri, May 3, 2024 at 8:12 AM Ron Johnson >> wrote: >> >>> On Thu, May 2, 2024 at 8:28 PM Amit Sharma wrote: >>> >>>> Hello, >&