Answer: In order to access a database from 2 or more computers with HM2 please complete the following steps.
Note: This should only be attempted if you're comfortable doing advanced networking tasks with a computer. It's also your own responsibility to backup and protect your own data and computer. This is not something we can assist you with and if it causes your database to become disconnected or damaged you will need to reinstall postgresql and reestore your database backup.
Prerequisites:
1. PostgreSQL installed on a network server, accessible from all computers.
2. Network share to access files from all computers:
- Windows server: use the standard network file access
- Linux server: install Samba on the Linux server or use one of the windows PCs as file server.
- Virtual machines: use a “shared folder”
- The network share must have the same folder/name on all computers. If you use a database parent folder c:\.... on one of your PCs for the network database this will not work. You have to access the local database via network share also. For this you can use the subst command, or create a new network share to a local folder, before creating the network database with the new database parent folder
Steps:
1. Configure the HM2 database connection so that it can access the postgreSQL server from the computer. You need to edit at least the IP address.
2. Verify the database connection with the “Test Connection” button.
3. The database parent folder must be a folder on a network share which can be accessed from all computers (using the same network share!). Displayed below is an example of a V: network drive.
- Path to DB parent MUST be in ''Z:\\path_to_folder'' but not ''\\server\path_to_folder''.
4. Generate the database and test it
5: On the additional computers, create a 'dummy' database with the database parent folder pointing to a network share
6. After completion, the original network database will be displayed in the database list.
7. Select the original database as the default database.
8. Delete the 'dummy' database.