Database

Carbonio requires the availability of a Postgres database to be installed. It is possible to install the Postgres database in a separate structure (as long as service access is ensured) or to directly use a Postgres database offered by a cloud service provider.

Obviously, a Postgres node may be installed in the same infrastructure that supports the Carbonio nodes. The measures to take in this situation are outlined below.

Carbonio’s PostgreSQL installation relies on a variety of databases to store and monitor all of the things it needs to manage. The core database may be set up in a few steps.

We begin by creating a strong password for PostgreSQL’s administrator account.

When prompted, enter your desired password: it will be saved in a variable called $DB_ADM_PWD and may be used throughout the operation. It is vital to note that the password is only available to the current terminal’s user (root). It is not accessible to anybody else, and it is removed after you log out.

Remember to update the password with a strong password of your choice and keep it somewhere secure (ideally using a password manager), since you will need it for the rest of the procedure and maybe in the future. This password will be represented by the string DB_ADM_PWD.

The next stage is to build the database.

You may erase the variable–and the password it stores–at any time with the command below, but keep in mind that you’ll need it in the following step.

Finally, run these instructions to allow other nodes to access the databases that will be stored on this node.