[forinti]

You could connect Oracle to Postgresql using HA and from Postgresql to Oracle using FDW.

If your client was paying Oracle already, he should take steps to move away from it, not setup himself up for paying licences forever.

I cringe at having to call Oracle Support. It takes forever and they make you send a ton of files before someone even looks at it.

[simonebrunozzi]

> he should take steps to move away from it

Unless - as it often happens - someone in high places need to keep justifying a business decision taken 1-2-3 years before.

[zozbot234]

That's what we call throwing good money after bad. Besides, PostgreSQL has actually come a long way since 3 years ago or so. It's not a slow-moving project, especially for this space.

[user5994461]

How often do developers recompile postgresql? How often do developers go through the hassle of upgrading databases versions? Whatever postgresql may have done recently, it won't be used and available in the common distro until a while later.

Bear in mind that minor versions in postgresql are breaking changes. It does not follow semver.

[pritambaral]

> Bear in mind that minor versions in postgresql are breaking changes. It does not follow semver.

1. This hasn't been true since three releases ago (i.e., PG 10).

2. Before PG10, X.Y _was_ the major version of PostgreSQL, Y was _not_ the minor version. It has never broken backwards compatibility without a major version change.

3. PostgreSQL is much, _much_ older than semver.

[ken]

I don't know anyone who compiles their own Postgres at all.

AWS is a pretty common "distro" (of sorts). Postgres 12.2 was released 2020-02-13, and AWS RDS supported it on 2020-03-31. You don't have to wait very long to use this.

[outworlder]

> How often do developers recompile postgresql?

Uh, never? I mean, there may be cases where you might need to do that, but I don't want to use a PG built by JoeRandoMacbook somewhere. It's better to use PGDG.

> How often do developers go through the hassle of upgrading databases versions?

As often as they have to. Most places don't upgrade all that often.

[mjw1007]

I don't know what things are like in the RPM world, but for Debian each new PostgreSQL version is packaged at apt.postgresql.org as soon as it's released, by the same people, and to the same high standard, as the packages that go in the stable release.

(Also, since Postgresql 10 they changed the numbering scheme so that the major version changes for each 'breaking' release.)

[forinti]

I've gone through Oracle and Postgresql upgrades. It is dead easy to compile Postgresql.

Our last Oracle migration lasted about 2 weeks. When it was over, I decided to upgrade Postgresql too. Including compiling it, it didn't take an hour.

[henryfjordan]

Many of the cloud providers make it relatively easy to upgrade and might even force you to do so after a while (so they can drop support for old versions).

[makoz]

Which minor versions have you seen with breaking changes? Or are you talking about the way Postgres version things

[takacsroland]

Yes forinti, it is true, I agree.