Hi,
I am trying to federate arcgis 10.8.1 server with the portal.
I can see that the server is federated with portal and shows the green tick.
But the server doesn’t appear under hosting server drop down.
I checked that the datastore is healthy and configured with the server.
I see this message every 5 min.
"The database server was found to be stopped. Re-starting it."
win event log:
The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
pg_ctl: could not start server
Examine the log output.
The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
pg_ctl: another server might be running; trying to start server anyway
Portal Logs:
2023-09-21 13:44:54 AEST: [3968]: [1-1] LOG: database system was shut down at 2023-09-21 13:41:25 AEST
2023-09-21 13:44:54 AEST: [3896]: [5-1] LOG: database system is ready to accept connections
2023-09-21 14:43:55 AEST: [12568]: [1-1] ERROR: relation "hsu_okm79.sde_logfiles" does not exist at character 29
2023-09-21 14:43:55 AEST: [12568]: [2-1] STATEMENT: SELECT logfile_data_id FROM hsu_okm79.SDE_logfiles LIMIT 0
2023-09-21 14:43:55 AEST: [12568]: [3-1] ERROR: relation "pg_temp_5.sde_logfiles" does not exist at character 29
2023-09-21 14:43:55 AEST: [12568]: [4-1] STATEMENT: SELECT logfile_data_id FROM pg_temp_5.SDE_logfiles LIMIT 0
2023-09-21 14:43:55 AEST: [12568]: [5-1] ERROR: relation "hsu_okm79.sde_logfiles" does not exist at character 29
2023-09-21 14:43:55 AEST: [12568]: [6-1] STATEMENT: SELECT logfile_data_id FROM hsu_okm79.SDE_logfiles LIMIT 0
OS: Windows server 2019
ArcGIS 10.8.1 Enterprise
Can someone help on how to get this resolved and get the server appear under hosting server please?
Thanks