-
Notifications
You must be signed in to change notification settings - Fork 10
Expand file tree
/
Copy pathREADME.PGSQL
More file actions
37 lines (27 loc) · 824 Bytes
/
README.PGSQL
File metadata and controls
37 lines (27 loc) · 824 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
From Chris Caputo <ccaputo@alt.net>:
Before running targetmaker, create your rtg database and add the following
to it:
--
CREATE TABLE router (
rid SERIAL NOT NULL,
name char(120) NOT NULL default '',
pop char(10) NOT NULL default '',
popid smallint NOT NULL default '0'
);
CREATE INDEX router_idx ON router (rid);
CREATE TABLE interface (
id SERIAL NOT NULL,
name char(255) NOT NULL default '',
rid int NOT NULL default '0',
speed bigint default NULL,
description char(255) default NULL,
status boolean default true
);
CREATE INDEX interface_idx ON interface (id);
--
Be sure to change DB_TYPE in targetmaker.cfg as follows:
$DB_TYPE = "Postgres";
And adjust rtg.conf as follows:
DB_Driver librtgpgsql.so
Threads 1
(I only tested single-threaded mode.)