PostgreSQL¶

PostgreSQL is a popular open source relational database.

Binero cloud enables you to provision PostgreSQL as a standalone installation or with replication.

If you select with replication, a auxiliary instance will be setup that will copy all writes. This server is good for database reads (to reduce load on the primary server) and in case of an issue with the primary server, the auxiliary instance can become the new primary.

• Give your service a name and optionally a description.

• Select your SSH-key.

• Under Secondary node availability zone dropdown, you are able to select which availability zone to place the auxiliary node in (if you choose to replicate). You can choose to use the same zone as the primary node or you can select another zone if you want to build a geographically distributed application.

• Under Alternate network, you select the network that the auxiliary server should connected to.

• Select your instance flavor. We recommend sticking with the default.

• Select the volume size for the instance. You can extend this volume later, see the Extend a persistent volume article.

• Under Primary node availability zone, select the availability zone to run your primary instance in.

• Under Primary network, you select the network that the primary server should connected to.

• Under Secondary nodes, you select the amount of auxiliary servers you want. If you select zero, no replication will be setup.

• Press Create. You will get further details on how to connect to the service.