Thanks Jamie. The Cisco online documentation is implicitly quiet about supporting SSL/TLS for PostgreSQL but mentions about the other two MS-SQL and Oracle. I am finding errors trying to connect to the latest PostgreSQL DB v13 "STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like E'users' and n.nspname like E'public') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum ERROR: column c.relhasoids does not exist at character 245. The Cisco CUPS 12.5 documentation recommends to use up to PostgreSQL ver. 10.7, however I could only find PostgreSQL 10.5 x64 for Windows server 2019. Postgres recommends to use PostgreSQL ver. 11 or higher for Windows 2019 servers. What version should I download to support CUPs data export to external PostgreSQL database to be installed on x64bit Windows 2019. My last question is which database is Cisco recommending based on Jabber users, for example recommendation to use Postgres for 2000 or less Jabber users generating maximum of 20 chat messages a day (depending on a customers budget) or use MS-SQL / Oracle as the external database for 2000 or more Jabber users generating a maximum of 100 chat messages per day. Your guidance is much appreciated and have a great day a head.
