Dual-mode design
1. Objective
-
In order to support both the PG mode and Oracle-compatible mode, IvorySQL allows specifying the -m parameter during initdb to obtain either a PG mode database or an Oracle-compatible mode database.
-
If the -m parameter is not specified, it defaults to Oracle-compatible mode.
-
If the -m parameter is specified as pg, the database will no longer be compatible with Oracle syntax.
2. Function
-
Initdb -m initialization requires judgment of different modes, among which oracle mode requires the execution of SQL statements postgres_oracle.bki. The default is Oracle compatibility mode, and the process is as follows:
-
Startup: When starting, it determines whether it is an Oracle compatibility mode based on the initialization mode;
Description:
database_mode: Used to indicate initialization mode;
database_mode=DB_PG，PG mode, and cannot be switched;
database_mode=DB_ORACLE， oracle compatibility mode;