The PostgreSQL database server automatically writes information about its operation to the system log. This log can be used to identify various issues, such as the causes of incorrect behavior. The location of the log varies depending on the operating system on which you are running Flexi.

Let's take a look at where to find the log on each operating system.

In the Start menu, select Windows Administrative Tools. Then, in the menu that appears, select Event Viewer - Windows Logs - Application.

The full path is therefore:

Computer Management -> Event Viewer -> Windows Logs -> Application

Open the Terminal application and enter the command sudo su - and enter your password. The database log is then located at:

/Library/Application\ Support/FlexiBee/Data/pg_log/startup.log

However, it is not accessible by default in this location, so it can be copied to another location.

The command to copy the log to the Documents folder, from where it can be read and sent:

All logs are stored in the directory /var/log/ and for the PostgreSQL database server you will find it in the subdirectory /var/log/postgresql/.

/var/log/postgresql/postgresql-9.6-flexi.log

(the highlighted pgSQL version in bold may differ)

The log can be found in the directory /var/lib/pgsql/pg_log/.