Network installation

Network installation overview

See article Network installation overview

PostgreSQL network installation

1. Install and run the PostgreSQL server. Installation instructions can be found at http://www.postgresql.org
2. Download following SQL scripts:
   • media:pgsql_struct.sql
   • media:pgsql_dict.sql
3. Create a database (for example with name "eacts") and connect to it. Run those two SQL scripts on this database.
4. Configure your PostgreSQL server so it accepts connections from network. Create a database user and give him privileges to read and write in all tables in the database.
5. Download the JDBC driver
6. Copy the driver jar file into the lib/ext subdirectory of your Java JRE directory. For example: {{{C:\Program Files\Java\jre1.5.0_02\lib\ext}}}
7. Download and run the latest version of the DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.
8. Go to the software preferences directory

.EactsCongenitalDatabase

located in the user home directory (please note the dot character at the beginning of the directory name). Edit the {{{ecdbc.properties}}} file and set two variables: dbdriver and dburl. The user name and the password are to be set inside the dburl variable.

dbdriver=org.postgresql.Driver
dburl=jdbc:postgresql://server address/eacts?user=your_user&password=your_users_password

When you configure another client, you perform steps 5-8 from the instructions. In the server address give the IP adress (or a DNS name if appropiate) of computer with PostgreSQL server. Please note, that:

• PostgreSQL server must be enabled to accept TCP/IP connections from network
• Proper TCP port (PostgreSQL's default is 5432) must be opened if the server is protected by a firewall
• dburl must be in one (perhaps very long) line, together with "?user=...&password=...".