topic Moving/changing the disk the Monitor Postgres SQL DB is installed on in ArcGIS Monitor Questions

Moving/changing the disk the Monitor Postgres SQL DB is installed on

EricJohnson-HDR — Fri, 01 Dec 2023 00:17:37 GMT

Recent install of 2023 Monitor and upgraded to .2 last week. Needing to relocate the disk the DB lives on. Its at 270GB and only 2 months of data. I would like to relocate to a new disk, if that is an option.

We have not yet determined how long we want to keep the metrics data but see the option to reduce the retention now, nice add there.

Thanks.

Re: Moving/changing the disk the Monitor Postgres SQL DB is installed on

GeoJosh — Mon, 04 Dec 2023 14:19:24 GMT

Hi Eric,

On the Postgres side, all you need is the /data directory.

Make a backup of <PostgresInstallDir>/<version>/data
Make a back up of the ArcGIS Monitor configuration store
Reinstall Postgres on the new disk
Restore the /data backup in the new installation
If the new disk is on the same machine as the old one, no further action is necessary. If migrating to a new disk on a new machine, re-register the database in ArcGIS Monitor.

Josh