Incompatibility
In Fujitsu Enterprise Postgres 15, the name of the "target server" specified by the connection switching function will be changed from "TargetServerType" to "TargetSessionAttributes", and the specified value will also be changed.
Action method
If the target server is specified, change the target server and specified value as follows.
Fujitsu Enterprise Postgres version | FUJITSU Enterprise Postgres 9.6 or earlier | FUJITSU Enterprise Postgres 10/11/12 | FUJITSU Enterprise Postgres 13/14 | Fujitsu Enterprise Postgres 15 | |
|---|---|---|---|---|---|
Keywords to specify in the connection string | target_server | TargetServerType | TargetServerType | TargetSessionAttributes | |
Server selection order | Primary Server | primary(*1) | master(*1) | primary(*1) | read-write(*1) primary(*2) |
Standby Server | - | slave(*2) | standby(*2) | standby read-only(*2) | |
Prefer Primary Server | - | - | - | prefer-primary | |
Prefer Standby Server | prefer_standby | preferSlave | preferStandby | prefer-standby | |
Any | - | any | any | any | |
*1: A primary server whose default transaction mode is read-only are not selected.
*2: A primary server whose default transaction mode is read-only is also selected.
