Connector Configuration for PostgreSQL fails to connect
I am trying to configure the PostgreSQL connector on my FortiSOAR setup to connect to the FSR DB however, it fails with below error:
[root@fortisoar csadmin]# sudo -u postgres psql
Password for user postgres:
psql (16.8)
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
---------------+------------+----------+-----------------+------------+------------+------------+-----------+-----------------------
connectors | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
das | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
data_archival | cyberpgsql | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
gateway | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
notifier | cyberpgsql | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
postgres | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
postman | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
sealab | cyberpgsql | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
template0 | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
venom | cyberpgsql | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
(11 rows)
postgres=# \c venom
You are now connected to database "venom" as user "postgres".
venom=#