Upgrading to 11.1: What's with the pgdata.12.4 folder on my Data Store Machine?

[jcarlson]

I updated our portal to 11.1 with no significant issues, which was great! However, I noticed that in my Data Store machine's files, there is now a folder called pgdata.12.4 that takes up the same amount of space as my pgdata folder, but the contents of the folder haven't changed since the upgrade took place.

I get the impression that maybe it should have been removed during the upgrade, but I'm not sure.

What is this folder for?

Is it safe to delete it?

[Scott_Tansley · Accepted solution]

Hey, when you upgrade a relational Data Store it doesn't just upgrade the database.  The process 'duplicates' it and then upgrades the duplicate.  This actually gives you a safe rollback, and it's nice to have.

When you are confident that you have a good upgrade and the Data Store is solid then you can use the following tool:

https://enterprise.arcgis.com/en/portal/latest/administer/windows/data-store-utility-reference.htm#E...

This will go through and remove any older database relics.

Hope this helps.

[jcarlson]

It does help! Thank you very much! I assumed the safe rollback was what's in the /backup directory, but I can see how this would be good to have for upgrading the postgres version.

[Scott_Tansley]

You would be amazed how many people don't set backup/webgisdr.  This is a last resort, but a good one.  A client recently asked me to help them rollback to yesterday.  They had a four-day backup cycle and it was three days old... 😞  I always take VM snapshots in addition to anything else.  The big thing I've seen at 11.1 is that people are finally using the data store, so it's bigger now than at previous versions, so the issue you raise is becoming more pronounced....

[AYUSHYADAV]

Hi,
We have ArcGIS Enterprise in Dritibuted HA configuration comprised of 12 machines, which includes:-
1. Two Portal machines
2. Two Hosting Server machines
3. Two ArcGIS Datastores machines (relational and tilecache both)
4. Two Image Server machines
5. Two Federated server machines
6. Two Webdaptor machines

While upgrading the environment from v11.1 to 11.3, we didn't encounter any issues with any of the components. However, after the upgrade, we observed that data were missing from from the hosted feature layers. Upon further investigation when we checked the data folder inside the ArcGIS datastore directory. We found there were two folders having names:-
1. pgdata - new one - size is around 350 GB
2. pgdata.14.5 - old one - size is 1.16 TB
It seems that the whole data didn't get copied during the backup process due to which we lost the data from the hosted feature services.
I just wanted to know how we can recover the data from the old pgdata.14.5 directory.
Thanks
Ayush