Technical Tip: How to check PostgreSQL version in FortiAnalyzer

[jasonhong]

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 ----------------- 15.10 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.