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

256
1
Jump to solution
11-30-2023 04:17 PM
EricJohnson-HDR
New Contributor

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.

Tags (1)
1 Solution

Accepted Solutions
GeoJosh
Esri Contributor

Hi Eric,

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

  1. Make a backup of <PostgresInstallDir>/<version>/data
  2. Make a back up of the ArcGIS Monitor configuration store
  3. Reinstall Postgres on the new disk
  4. Restore the /data backup in the new installation
  5. 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

View solution in original post

1 Reply
GeoJosh
Esri Contributor

Hi Eric,

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

  1. Make a backup of <PostgresInstallDir>/<version>/data
  2. Make a back up of the ArcGIS Monitor configuration store
  3. Reinstall Postgres on the new disk
  4. Restore the /data backup in the new installation
  5. 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