Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Image Removed

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:

  1. Click the Image Removed button.
  2. Select Server (1).
    Image Removed

    Note
    titleAttention!

    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.

  3. 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.
  4. Click the Engage button (4).

The DB server has been added. 

Image Removed

Click Image Removed to control the DB server. The following operations are allowed:

  1. Server Stop/Start (1).
  2. Designate as a primary server (2).

    Note
    titleAttention!

    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.

  3. Delete Server (3).

    Info
    titleNote

    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:

  1. Go to the Configuration tab.
  2. Click DB Agents.
    Image Added
  3. The icon next to the Server indicates the current status of the agent. 

    Icon

    Status

    Image Added

    Launch expected

    Image Added

    Launched

    Image Added

    Stopped


  4. Click Image Added to stop or launch the agent, and select the required action.
    Image Added