We have configure the DC - DR in soar, and after enabling the DR, i'm facing below error.

fatal: [Secodnry_DR_HOST]: FAILED! => {"changed": true, "cmd": "psql -d co3 -c \"UPDATE monapp.configvars SET cvar_enabled=true, cvar_desc='', cvar_value='1', cvar_type='B' WHERE cvar_name='elastic_server.init_schema' \"", "delta": "0:00:00.006902", "end": "2024-04-11 14:27:17.299267", "msg": "non-zero return code", "rc": 2, "start": "2024-04-11 14:27:17.292365", "stderr": "psql: error: connection to server on socket \"/var/run/postgresql/.s.PGSQL.5432\" failed: FATAL:  database \"co3\" does not exist\nDETAIL:  The database subdirectory \"pg_tblspc/16385/PG_14_202107181/16386\" is missing.", "stderr_lines": ["psql: error: connection to server on socket \"/var/run/postgresql/.s.PGSQL.5432\" failed: FATAL:  database \"co3\" does not exist", "DETAIL:  The database subdirectory \"pg_tblspc/16385/PG_14_202107181/16386\" is missing."], "stdout": "", "stdout_lines": []}


fatal: [Primary_DC_HOST: FAILED! => {"changed": true, "cmd": "ssh -o NumberOfPasswordPrompts=0 -q resfilesync@Secodnry_DR_HOST exit", "delta": "0:00:00.158779", "end": "2024-04-12 09:57:27.165243", "msg": "non-zero return code", "rc": 255, "start": "2024-04-12 09:57:27.006464", "stderr": "", "stderr_lines": [], "stdout": "", "stdout_lines": []}

the output of the command
sudo cat /usr/share/co3/conf/co3.properties

resDrMode=TRANSITIONING

any idea to fix this issue.