On 10/8/26 8:56 AM, kavya chandren wrote:
Hi Adrian,
Intention is to get away from Oracle and get committed to Open source
Postgresql.
Alright I understand.
Not sure what your timeline and resources are, but I would start with a
test setup using a subset of the existing Oracle setup and work against
that to do an initial determination of the challenges.
On Thu, Oct 8, 2026 at 8:20 PM Adrian Klaver <[email protected]
<mailto:[email protected]>> wrote:
On 10/8/26 12:05 AM, kavya chandren wrote:
> Hi,
>
> We have an oracle deployment running in 300+ TB. Apart from
migration
> challenges, do we foresee any operational challenges? I have not
heard
> of something huge prior. This would be highly helpful in planning
further.
Why the change?
Is this a pricing issue or are you looking to get something else out of
the migration?
>
> Few challenges which caught my attention include,
>
> 1. Backup, restore of such a large database
> 2. Recovery of a broken database (A lost replica)
> 3. Fixing a standby that lags a lot
> 4. Triggering a PITR with any backup tools
> 5. Maintenance at times
> 6. Finding equivalents of oracle items (which is common during any
> oracle to postgres migration)
>
> I dont see any limits in database/ objects as specified in https://
> www.postgresql.org/docs/current/limits.html <http://
www.postgresql.org/docs/current/limits.html> <https://
www.postgresql.org/ <https://www.postgresql.org/>
> docs/current/limits.html>
>
> Thanks and Regards,
> Kavya
--
Adrian Klaver
[email protected] <mailto:[email protected]>
--
Adrian Klaver
[email protected]
