GSA timezone list doesn't reflect Postgresql allowed value

[xazzzz]

Expected behavior

After changing timezone on the user settings, we should be able to re log without problem

Actual behavior

If I change the timezone to "Canada/Eastern", save, logout, and try to reconnect, I get

GMP error during authentication

Steps to reproduce

Go to user settings and change the timezone to "Canada/Eastern"
Save settings
Logout
Try to login

Fix

Timezone list should be pull from then table "pg_timezone_names"

GVM versions

gsa: 24.3.0

gvm: 26.0.0

Environment

Operating system:

Linux greenbone 6.8.0-63-generic #66-Ubuntu SMP PREEMPT_DYNAMIC Fri Jun 13 20:25:30 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=24.04
DISTRIB_CODENAME=noble
DISTRIB_DESCRIPTION="Ubuntu 24.04.2 LTS"

Installation method / source: source installation

Logfiles

sql_exec_internal: PQexec failed: ERROR: invalid value for parameter "TimeZone": "Canada/Eastern"
(7)
sql_exec_internal: SQL: SET SESSION TIME ZONE 'Canada/Eastern';
sqlv: sql_exec_internal failed
gvmd: Serving client(+0x137df0) [0x6469c0bc6df0]
BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6