On 5/8/19 8:39 AM, Sandeep Saxena wrote:
Hi All,
In our company we are looking to migrate oracle db to postgres , now
since we dont have any expertise in Postgres in our organization so we
are planning to go
with AWS aurora or EDB postgres so that we have helping hand in
migration(in dev and dba) while we get mature in postgres ... do you
guys think after 1-2 years if required it will be easy to move from EDB
or Aurora to Open source Postgres assuming we dont use AWS services OR
Not sure how you can use Aurora without AWS?
would you suggest to move to Community version from the start by taking
support/consultancy from other companies like 2nd quadrant and etc?
I would say move directly to the community version, save yourself a
second transition cycle. Sign up with one the Postgres support companies
and/or use these lists.
All our developers are experienced in pl/sql so I assume it will be
easier to learn PL/pgsql ,isnt that right? so far only things i dont
like about PL/pgsql that validation of program units doesnt happen until
you run it ... though i did find extension plpgsql_check to achieve that
to some extent.
Regards,
Sandeep
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
