Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration Oracle multitenant database to PostgreSQL ? - Mailing list pgsql-hackers

From Thomas Kellerer
Subject Re: Migration Oracle multitenant database to PostgreSQL ?
Date
Msg-id a53064e1-9f66-5231-a32f-8cbf3a4be59f@gmx.net
Whole thread Raw
In response to Migration Oracle multitenant database to PostgreSQL ?  (ROS Didier <didier.ros@edf.fr>)
Responses Re: Migration Oracle multitenant database to PostgreSQL ?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: ROS Didier
Date:
Subject: Migration Oracle multitenant database to PostgreSQL ?
Next
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: POC: postgres_fdw insert batching