Database Program Reinstallation


GymMaster Database Program Reinstallation

If you are re-installing GymMaster, or you already have installed the database program ‘PostgreSQL’, there are a few things to do first:

  • We highly recommend that previous instances of Postgresql be uninstalled fully before proceeding.

    To remove Postgresql database program:

  • Before making any changes, please backup GymMaster from within GymMaster.

    In the event of not being able to start the Gymmaster interface, do the following to backup the database manually:

 

  • Start -> Run -> cmd
  • Type in and then press enter:
  • cd C:\postgres\bin
  • Type in then press enter:
  • pg_dumpall.exe -U postgres >> C:\backupname.sql
  • It will request a password a number of times. Contact GymMaster support to request this password.
  • Safety check – Open the Windows file explorer, navigate to C:\, and check the size of the backupname.sql file just created. Should be greater than zero.

 

Once the backup file is verified, now you can fully uninstall the program.

  • Start -> Control Panel -> Administrative Tools -> Services.
  • Scroll down to find and highlight “postgres” or similarly worded.
  • ‘Stop’ the service. Double-click the name to open the properties. Set to ‘disabled’. Close the properties window.
  • Start -> Control Panel -> Programs and Features.
  • Scroll down to find and highlight “postgres” or similarly worded. Right-click to uninstall.

When completed:

  • Start -> right-click Computer -> Properties -> Advanced System Settings -> User Profiles -> Settings button.
  • Select and delete any ‘postgres’ user account.
  • ‘OK’ to close all windows.

Now, you are ready to reinstall the database program.