Firebird 2.0
Administrators
Manual

Overview of Firebird configuration

A Firebird server is configured through two files, firebird.conf and aliases.conf. Both are located in the Firebird root directory.

  • firebird.conf
    In this file a number of configuration parameters can be set. Because of its 'self-tuning' design, Firebird has a relatively small number of configuration parameters whose default settings are right for most use cases.

  • aliases.conf
    In this file symbolic names for database files can be defined, decoupling the client's connection information from actual server file locations.

The settings in these files are global to the server, i.e. They apply to all databases accessed through this server from all clients.

Location of the configuration files

Because several ways exist to tell the server where to find a value for this attribute, developers and system administrators should be aware of the precedence trail that the server follows at startup, to determine it correctly:

For Windows servers and clients the precedence path is:

  1. The FIREBIRD environment variable

  2. The RootDirectory parameter in the configuration file

  3. The registry setting HKLM\ SOFTWARE\Firebird Project\Firebird Server\Instances\DefaultInstance, field DefaultInstance.

  4. The directory one level above the one where the server binary is located

The embedded server uses the following order on Windows:

  1. The FIREBIRD environment variable

  2. The RootDirectory parameter in the configuration file

  3. The directory where embedded library is located

On Posix systems the classic and embedded server use:

  1. FIREBIRD environment variable

  2. RootDirectory parameter in firebird.conf

  3. Default installation path

And on Posix systems the superserver uses the following order:

  1. The FIREBIRD environment variable

  2. The RootDirectory parameter in the configuration file

  3. The directory one level above the one where the server binary is located (retrieved via symlink "/proc/self/exe", if supported)

  4. Default installation path (/opt/firebird)

The location where the config files are found is also the initial “root directory”. The root directory is the basis for several system file paths. The root directory can be set to another path through the RootDirectory configuration parameter.

You can edit the configuration file while the server is running. To activate configuration changes, it is necessary to stop and restart the server.


goto index next page

Legal information