MEDOC - Multi Experiment Data & Operation Center » Netdrms_9.1.1

h1. Netdrms 9.1.1  

h2. Posgres 9.4.13 

h3. Install additional modules

We need dblink for triggers between db 

<pre>

root@sdo1:~# cd /usr/share/postgresql/9.4/extension

root@sdo1:/usr/share/postgresql/9.4/extension# ls -al  dblink--1.1.sql

-rw-r--r-- 1 root root 5831 Aug 10 14:53 dblink--1.1.sql

</pre>

h4. ias_sdo

<pre>

root@sdo1:/usr/share/postgresql/9.4/extension# psql ias_sdo -p5432 -U postgres < dblink--1.1.sql

Use "CREATE EXTENSION dblink" to load this file.

root@sdo1:/usr/share/postgresql/9.4/extension# 

root@sdo1:/usr/share/postgresql/9.4/extension# 

root@sdo1:/usr/share/postgresql/9.4/extension# 

root@sdo1:/usr/share/postgresql/9.4/extension# psql ias_sdo -U postgres 

psql (9.4.13)

Type "help" for help.

ias_sdo=# CREATE EXTENSION dblink ;

ERROR:  extension "dblink" already exists

ias_sdo=# \q

</pre>

Seems ok !

h4. ias_sdo_sums 

<pre>

root@sdo1:/usr/share/postgresql/9.4/extension# psql ias_sdo_sums -p5434 -U postgres < dblink--1.1.sql 

Use "CREATE EXTENSION dblink" to load this file.

root@sdo1:/usr/share/postgresql/9.4/extension# psql ias_sdo_sums -p5434 -U postgres 

psql (9.4.13)

Type "help" for help.

ias_sdo_sums=#  CREATE EXTENSION dblink ;

ERROR:  extension "dblink" already exists

ias_sdo_sums=# \q

</pre>

Seems ok too !

h4. ias_sdo_monitor 

<pre>

root@sdo1:/usr/share/postgresql/9.4/extension# psql ias_sdo_monitor -p5436 -U postgres < dblink--1.1.sql 

Use "CREATE EXTENSION dblink" to load this file.

root@sdo1:/usr/share/postgresql/9.4/extension# psql ias_sdo_monitor -p5436 -U postgres

psql (9.4.13)

Type "help" for help.

ias_sdo_monitor=# CREATE EXTENSION dblink ;

ERROR:  extension "dblink" already exists

</pre>

Ok too!