Migration Oracle multitenant database to PostgreSQL ?

ROS Didier schrieb am 24.11.2020 um 09:09:

I would like to know if it is possible to migrate Oracle multitenant
database (with multiple PDB) to PostgreSQL ?

Postgres' databases are very similar to Oracle's PDBs.

Probably the biggest difference is, that you can't shutdown
a single database as you can do with a PDB.

Database users in Postgres are like Oracle's "common users", they are
global for the whole instance (aka "cluster" in Postgres' terms). There
are no database specific users.

Thomas

On Tue, Nov 24, 2020 at 09:22:26AM +0100, Thomas Kellerer wrote:

ROS Didier schrieb am 24.11.2020 um 09:09:

I would like to know if it is possible to migrate Oracle multitenant
database (with multiple PDB) to PostgreSQL ?

Postgres' databases are very similar to Oracle's PDBs.

Probably the biggest difference is, that you can't shutdown
a single database as you can do with a PDB.

I guess you could lock users out of a single database by changing
pg_hba.conf and doing reload.

Database users in Postgres are like Oracle's "common users", they are
global for the whole instance (aka "cluster" in Postgres' terms). There
are no database specific users.

Good to know.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee