Technical Tip: How to check PostgreSQL version in FortiAnalyzer
| Description | This article describes how to check the PostgreSQL version in FortiAnalyzer. |
| Scope | FortiAnalyzer. |
| Solution | To display the active PostgreSQL version, run the following CLI command:
execute sql-query-generic "SELECT current_setting('server_version');"
Example output:
execute sql-query-generic "SELECT current_setting('server_version');" current_setting
This output confirms which version of PostgreSQL is currently in use.
Note: This check is especially useful to determine if the PostgreSQL database version is updated during a firmware version upgrade on FortiAnalyzer. |