PostgreSQL network installation - Revision history

HubertCzobodzinski at 03:55, 21 April 2025

2025-04-21T03:55:04Z

HubertCzobodzinski at 15:30, 28 February 2025

2025-02-28T15:30:39Z

HubertCzobodzinski: New links to sql files.

2023-02-09T01:33:58Z

New links to sql files.

HubertCzobodzinski at 13:02, 21 June 2019

2019-06-21T13:02:11Z

HubertCzobodzinski at 19:09, 30 June 2017

2017-06-30T19:09:26Z

HubertCzobodzinski at 22:31, 19 March 2017

2017-03-19T22:31:58Z

HubertCzobodzinski: db name

2017-03-19T22:31:28Z

db name

HubertCzobodzinski: db versions

2017-03-19T22:30:47Z

db versions

HubertCzobodzinski at 15:29, 31 December 2010

2010-12-31T15:29:27Z

HubertCzobodzinski: Downloading and installing jdbc driver isn't necessary any longer.

2008-05-27T11:29:42Z

Downloading and installing jdbc driver isn't necessary any longer.

@@ Line 3: / Line 3: @@
 ##Download following SQL scripts (right-click and choose "Save target as"):
-##*[https://cloud.magnum2.pl/index.php/s/e9BRaXRdtr8D26c postgresql_struct.sql]
+##*[https://cloud.magnum2.pl/index.php/s/t5pb6zC6fdkL8GH postgresql_struct.sql]
-##*[https://cloud.magnum2.pl/index.php/s/qadjiHGyMzkrqAW postgresql_dict.sql]
+##*[https://cloud.magnum2.pl/index.php/s/JRDWpngSXwJ2i8F postgresql_dict.sql]
 ##Create a database (for example with name "eacts") and connect to it. Run those two SQL scripts on this database.

@@ Line 2: / Line 2: @@
 ##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any PostgreSQL version starting from 8.x, but we recommend to use latest available release.
 ##Download following SQL scripts (right-click and choose "Save target as"):
-##*[https://www-m2.magnum2.pl/cloud/index.php/s/33AZeASYsQSdJY5 postgresql_struct.sql]
-##*[https://www-m2.magnum2.pl/cloud/index.php/s/RBxmL66ND3FfjsH postgresql_dict.sql]
+##*[https://cloud.magnum2.pl/index.php/s/e9BRaXRdtr8D26c postgresql_struct.sql]
 ##Create a database (for example with name "eacts") and connect to it. Run those two SQL scripts on this database.
 ##Configure your PostgreSQL server so it accepts connections from network. <br> The configuration file is named: <pre>postgresql.conf</pre>You need to add following line: <pre>listen_addresses = '*'</pre> Second file that needs to be modified is: <pre>pg_hba.conf</pre>You need to add a line: <pre>host all all 192.168.3.0/24 md5</pre> Change 192.168.3.0/24 into your own network block, in format of X.X.X.X/Y where X.X.X.X is address of your network and Y is the number of bits in your netmask. In this example, the network is 192.168.3.0 - 192.168.3.255.

@@ Line 2: / Line 2: @@
 ##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any PostgreSQL version starting from 8.x, but we recommend to use latest available release.
 ##Download following SQL scripts (right-click and choose "Save target as"):
-##*[http://www.eactscongenitaldb.org/viewcvs/*checkout*/ecdbc/trunk/pl/magnum2/ecdbc/database/sql/postgresql_struct.sql?root=ecbdc postgresql_struct.sql]
+##*[https://www-m2.magnum2.pl/cloud/index.php/s/33AZeASYsQSdJY5 postgresql_struct.sql]
-##*[http://www.eactscongenitaldb.org/viewcvs/*checkout*/ecdbc/trunk/pl/magnum2/ecdbc/database/sql/postgresql_dict.sql?root=ecbdc postgresql_dict.sql]
+##*[https://www-m2.magnum2.pl/cloud/index.php/s/RBxmL66ND3FfjsH postgresql_dict.sql]
 ##Create a database (for example with name "eacts") and connect to it. Run those two SQL scripts on this database.
 ##Configure your PostgreSQL server so it accepts connections from network. <br> The configuration file is named: <pre>postgresql.conf</pre>You need to add following line: <pre>listen_addresses = '*'</pre> Second file that needs to be modified is: <pre>pg_hba.conf</pre>You need to add a line: <pre>host all all 192.168.3.0/24 md5</pre> Change 192.168.3.0/24 into your own network block, in format of X.X.X.X/Y where X.X.X.X is address of your network and Y is the number of bits in your netmask. In this example, the network is 192.168.3.0 - 192.168.3.255.

@@ Line 1: / Line 1: @@
 #'''Server installation and configuration'''
-##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any 8.x or 9.x PostgreSQL version, but we recommend to use latest available release.
+##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any PostgreSQL version starting from 8.x, but we recommend to use latest available release.
 ##Download following SQL scripts (right-click and choose "Save target as"):
 ##*[http://www.eactscongenitaldb.org/viewcvs/*checkout*/ecdbc/trunk/pl/magnum2/ecdbc/database/sql/postgresql_struct.sql?root=ecbdc postgresql_struct.sql]

@@ Line 1: / Line 1: @@
 #'''Server installation and configuration'''
-##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any 8.x or 9.x PostgreSQL version, but we reccomend to use latest available release.
+##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any 8.x or 9.x PostgreSQL version, but we recommend to use latest available release.
 ##Download following SQL scripts (right-click and choose "Save target as"):
 ##*[http://www.eactscongenitaldb.org/viewcvs/*checkout*/ecdbc/trunk/pl/magnum2/ecdbc/database/sql/postgresql_struct.sql?root=ecbdc postgresql_struct.sql]

@@ Line 9: / Line 9: @@
 ##Create a database user and give him privileges to read and write in all tables in the database.
 #'''Client installation and configuration'''
 ##[[Download]] and run the latest version of the [[EACTS Database Software]]. When a dialog appears type in your hospital code (three capital letters) and choose the default database path.
 ##Go to the software preferences directory <pre>.EactsCongenitalDatabase</pre> 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. <pre>dbdriver=org.postgresql.Driver</pre> <pre>dburl=jdbc:postgresql://srv_addr/eacts?user=your_user&password=your_users_password</pre> Change '''srv_addr''' into your server's address (like 192.168.0.12 or server.myhospital.org), and give your user's name and password.