Skip to main content
Version Next

Database Instance Initialization

Before performing any activity, it is necessary to initialize the cluster, or instance — a group of databases managed by a single PostgreSQL Database Management System master process.

In file system terms, the cluster is a directory under which all data and metadata will be stored. This area is called the instance data directory or PGDATA.

note

In this option, PgSmart executes the PostgreSQL initdb command, passing the main options required to create a cluster.

note

PgSmart creates a drop-in file for each initialized instance, using the port number in the file name. This file contains the environment variables needed to run the database service. PgSmart also includes and enables the database service in systemd.

Prerequisites
  • Before initializing the database instance, it is necessary to install the Database Service. For more information, see Database Service Installation.

  1. Select the desired Environment from the dropdown in the top bar.

  2. Select the Banco de dados option in the side menu. The installed Database Services will be displayed as cards.

  3. Click Adicionar.

  4. In the Instance Control dialog box, select Initialize Instance.

  5. Select the Agent where the instance will be installed.

  6. Enter the Major Version.

  7. Enter the instance Data Directory.

  8. Enter the instance Transaction Log Directory (WALDIR).

  9. Enter the Default Character Encoding (ENCODING).

  10. Enter the default Regional Representation for dates and monetary values (LOCALE).

  11. Enter the instance Connection Port.

  12. Select the Network Interfaces through which access will occur (LISTEN_ADDRESSES).

  13. Click Adicionar.

    Figure 1 – Initialize Instance – select option
    Figure 1 – Initialize Instance – select option
    Figure 2 -Initialize Instance – select optiono
    Figure 2 -Initialize Instance – select optiono
    Figure 3 -Initialize Instance – details
    Figure 3 -Initialize Instance – details