Thread: EDB to Postgres Migration

EDB to Postgres Migration

From
KK CHN
Date:
List, 

Recently I happened to have  managed a few  EDB instances running on the EDB-10 version . 

I am looking for an option for migrating all these EDB instances  to Postgres Community edition.

1. What  major steps / actions involved ( in  bird's eye view ) for a successful migration  to postgres community edition . ( From EDB 10 to Postgres 14 ) 

2. What major challenges are involved?  (or any hurdles ?)


Please enlighten me with your experience..

Any reference  links most welcome ..

PS: -  The EDB instances are live and in production.. I can get a down time ( 5  to 15 Minutes Maximum)  Or can live  porting and upgrading to postgres 14  is possible  with minimal downtime ?

Request your  guidance,
Krishane. 

Re: EDB to Postgres Migration

From
Laurenz Albe
Date:
On Thu, 2023-07-13 at 11:58 +0530, KK CHN wrote:
> Recently I happened to have  managed a few  EDB instances running on the EDB-10 version . 
>
> I am looking for an option for migrating all these EDB instances  to Postgres Community edition.

If you are not using any of EDB's special featurs, a simple pg_upgrade could work.

Otherwise, things can become tricky.

Test well.

Yours,
Laurenz Albe