Data Directory Configuration via PgSmart Web

The Data Directory (PGDATA) is the absolute path where the data — among other files — of a specific PostgreSQL instance is stored.

Typically, for each instance, a directory is created under /var/lib/pgsql/VV, where VV is the major version of PostgreSQL.

On the same machine, multiple instances of the same PostgreSQL version — or even different versions — can be initialized, each with its own Data Directory and connection Port.

Data directories for instances can be configured using the Add Instance option.

Instructions

1. In the side menu, select the Banco de Dados option.
2. Select the desired Environment from the dropdown in the top bar.
   If there are registered instances, cards will be shown for each one.

Figure 1 - Selecting the Binaries option

Add a Data Directory

1. To add a data directory:
   1.1 Click Adicionar.
   1.2 In the Controle da Instância tab, select Adicionar Instância.
   1.3 Select the Agent where the data directory will be added.
   1.4 Enter the data directory to be included.
   1.5 Enter the Alias.
   1.6 Click Adicionar.

   

   Figure 2 - Add Instance option
   

   Figure 3 - Register new instance data directory
   

   Figure 4 - New instance data directory
   

   Figure 5 - New instance data directory

Remove a Data Directory

1. To remove a data directory:
   1.1 Right-click on the card you wish to delete.
   1.2 Click Remover.

   

   Figure 6 - Remove instance data directory

Add

Remove