An unlimited number of databases can be created in the same cluster. To create a database:
Go to the Configuration tab.
...
By default,
...
This will create a new database.
You must host the database on multiple servers. The first server you added will be the main server (Primary), the rest are backup servers (Standby). The first time the primary server starts, it initiates the database. Standby servers make a verbatim copy of the DB on the primary server.
To add a database server:
- Click the button.
Select Server (1).
Note title Attention! The database server must be hosted on computers with the same architecture (x 86, x 64).
If the computers in the cluster have different architectures, pick for the DB servers the computers with the most common architecture in the cluster.
- If the primary Server is not available within a specified time frame (field Takeover time, 3), then by default (setting Auto takeover, 2) one of the standby Servers (the first have a chance to) becomes automatically the primary server. In this case the former primary Server assumes a standby role.
Disable the setting Auto takeover (2) to be able to designate this Server as a primary server entirely manually. - Click the Engage button (4).
The DB server has been added.
Click to control the DB server. The following operations are allowed:
- Server Stop/Start (1).
Designate as a primary server (2).
Note title Attention! This operation is available only for servers with the disabled Auto takeover setting. After this operation the Server will be designated as a primary server with all other servers getting the Retired status, so that they cannot be started. A server in this status can either be deleted and re-created again, or designated as a primary server.
Delete Server (3).
Info title Note The primary server cannot be deleted.
...
the database is created automatically when the cluster is initialized, and its agents are launched on the master Servers.
The database is located in the C:\pgdata folder and uses port 49998.
To manage database agents, do the following:
- Go to the Configuration tab.
- Click DB Agents.
The icon next to the Server indicates the current status of the agent.
Icon
Status
Launch expected
Launched
Stopped
- Click to stop or launch the agent, and select the required action.