As default Collect Earth is setup to use SQLite as the database that stores the collected data.
In order to use a server-based solution (PostgreSQL) so that several PCs running Collect Earth can share the same data, the user must set up the database connection.
Install PostgreSQL server in a computer that can be reached by the other PCs, whether through the internet or within the intranet.
After you install PostgreSQL run the pgAdmin III application that should also have been installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database at first)
You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it
Step 1 : Create "collectearth" login roles
Step 1.A : Set long name "collectearth"
Step 1.B : Set the privileges for the user
Step 2: Create database.
Step 2,A: Call it also "collectearth" and set "collectearth" as the owner
Step 2.B : In the " privileges" grant "collectearth" full control of the database
Step 3: Create a schema within your new database and call it "collect" , Very important to keep this name as other names will provoke an exception!
Configure the Database
By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( check for more info here )
Go the folder where the PostgreSQL has been installed.
By default it should be :
Open the file called pg_hba.conf and append this line to the list of accepted connections :
This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : see the documentation )
Now on the same folder open the file postgresql.conf and change the line where it say
At this stage you need to restart PostgreSQL. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer.
SET UP COLLECT EARTH
Now you should open Collect Earth and got to the main menu Tools->Properties and then go to the operation mode tab.
In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address. You can see the current IP address of your computer on the same dialog (see image)
You should check that the connection is working by clicking on the smartly titled "Test Connection" button!!
Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data.
NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server.
FINALLY - CONFIGURE THE CEP FILE
If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file)
You will need to substitue these lines (of course with your own data for the IP, DB username and DB password)