Community
Select to view content in your preferred language

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

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

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
by Esri Regular Contributor
Esri Regular Contributor
‎12-04-2023 06:19 AM

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
by Esri Regular Contributor
Esri Regular Contributor
‎12-04-2023 06:19 AM

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