Hi! I’m trying to restore arcgis enterpise server, data store and portal on different server using backup taken from another server. New server uses the same configuration and credentials as it is on current running server.
For some reason restore fails on portal restoring (server and data store components were restored successfully). The error I’m getting is the following:
{"error":{"code":500,"details":null,"message":"Failed to import site. Failed to update the federated servers. Failed to update the database.."}}
I checked the pg logs and found that the utility trying to connect to PG database using "arcgis". I connected to this database and I saw that this used doesn’t exist, so I created it manually.
After running restore it failed again with the same error message, but now there was this error in postgres logs:
no pg_hba.conf entry for host "::1", user "arcgis", database "arcgis", SSL off.
I tried to put required config in pg_hba.conf file, also I tried to use allowconnection.bat script to allow connection for this user but it still fails.
Any ideas how to fix this issue?