Project

General

Profile

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!