Move the PostgreSQL database
If you are upgrading from a previous version that did not support locating the database on a separate server from AX Server or you need to replace the physical database server, move the database and reconfigure the properties files.
Prerequisites
- Install a PostgreSQL instance on the new database server machine. For more information, see Install the PostgreSQL database server
- Ensure that all users are logged out and cannot log back in to any Analytics Exchange applications
- Backup the Analytics Exchange database. For more information, see Backing up and restoring PostgreSQL
Move the database
- On the new database server machine, stop the Analytics Exchange Database service.
- On the new database server machine, in the pgsql96\data folder, delete all sub-folders.
Caution
Do not delete any of the files in the pgsql96\data folder. These files store database configuration information.
- On the old database server machine, in the pgsql96\data folder, copy all sub-folders and move them to the pgsql96\data folder of the new machine.
Postrequisites
On each application server where the ACL Analytics Exchange Service is running, update the database connection settings. For more information, see Change PostgreSQL connection settings.
