topic Re: WebGIS DR restore creating PostgreSQL with each restore in ArcGIS Enterprise Portal Questions

WebGIS DR restore creating PostgreSQL with each restore

Anonymous User — Thu, 13 Oct 2022 20:09:25 GMT

We are operating an on-prem, federated, 10.9.1 Portal with a 'primary' and 'secondary' environments. We use WebGIS DR to create a backup of the primary, and use it to restore the secondary (daily). (When necessary we fail over from the primary to the secondary when required via Netscaler and Host file changes.)

The colleague who initially setup our WebGIS DR configuration left. We have noticed that each restore to our secondary creates a PostgreSQL db folder in the Portal server install root on the secondary (which in our case is D:\arcgisportal\. I cannot find where this is configured anywhere in the webgisdr.properties (which is stored in D:\propfiles in our environment). Is there a WebGIS DR default setting that specifies the root \arcgisportal\ directory? More importantly, can we simply delete all of these old PostgreSQL directories? They're only a few hundred mb each, but are a bit of a nuisance. Thanks

Justin

Re: WebGIS DR restore creating PostgreSQL with each restore

JonathanQuinn — Thu, 13 Oct 2022 20:15:14 GMT

You can delete them manually for now; at 11.0 they're cleaned up automatically after the restore completes.

Re: WebGIS DR restore creating PostgreSQL with each restore

Anonymous User — Thu, 13 Oct 2022 20:18:32 GMT

Thanks Jonathan, good to know.

Somewhat related, and I think I found the answer in another thread several years old, but in the same root \arcgisportal\ diretory is an 'upgrade-backup' folder. That's safe to delete as well, correct? (Our upgrade from 10.8.1 to 10.9.1 was completed back in March 2022)

Thanks again

Re: WebGIS DR restore creating PostgreSQL with each restore

JonathanQuinn — Thu, 13 Oct 2022 20:19:48 GMT

Yes, if you're confident you won't need your 10.8.1 data anymore, you can delete it.

Re: WebGIS DR restore creating PostgreSQL with each restore

Anonymous User — Thu, 13 Oct 2022 20:26:12 GMT

They're actually triggering returns in our organization's vulnerability reports