Wiki » History » Version 1
Version 1/14
-
Next ยป -
Current version
Pablo Alingery, 28/09/2017 10:44
Netdrms 9.1.1¶
Posgres 9.4.13¶
Install additional modules¶
We need dblink for triggers between db
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
ias_sdo¶
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
Seems ok !
ias_sdo_sums¶
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
Seems ok too !
ias_sdo_monitor¶
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
Ok too!