9. PostgreSQL configuration

9.1. PostgreSQL configuration files

By default, the PostgreSQL configuration files are stored in the /home/mfbase/var/pgsql directory.

You may change this location in the [postgresql] section of the/home/mfbase/config/config.ini file:

[postgresql]
# data_dir={{MFMODULE_RUNTIME_HOME}}/var/pgsql

Caution

When you run the mfbase.init command, the PostgreSQL configuration is reset to the default configuration.

See also

PostgreSQL Database File Layout documentation

PostgreSQL Client Authentication

PostgreSQL Server Configuration

9.2. Metwork PostgreSQL template database

metwork Postgresql database template is the default for creating new databases. This template name is defined in the [postgresql]section /home/mfbase/config/config.ini file and may be changed:

[postgresql]
# dbname=metwork

9.3. Metwork PostgreSQL administrative account

The default MFBASE administrative account (metwork/metwork) is defined in the [postgresql]section /home/mfbase/config/config.ini file and may be changed:

[postgresql]
# administrative account
# username=metwork
# password=metwork

9.4. Metwork PostgreSQL default locale

The default MFBASE locale is C which means the system behaves as if it had no locale support. This setting is defined in the [postgresql]section /home/mfbase/config/config.ini file and may be changed:

[postgresql]
# locale=C

See also

PostgreSQL Locale Support documentation

9.5. Metwork PostgreSQL default port

The default MFBASE port is 7432 and is defined in the [postgresql]section /home/mfbase/config/config.ini file and may be changed:

[postgresql]
# port=7432

9.6. Metwork PostgreSQL Logging

Refer to PostgreSQL logs files