diff options
Diffstat (limited to 'sql/nms.sql')
| -rw-r--r-- | sql/nms.sql | 1399 |
1 files changed, 163 insertions, 1236 deletions
diff --git a/sql/nms.sql b/sql/nms.sql index cab4fbd..18291d1 100644 --- a/sql/nms.sql +++ b/sql/nms.sql @@ -3,6 +3,25 @@ -- SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +-- +-- Name: nms; Type: DATABASE; Schema: -; Owner: postgres +-- + +CREATE DATABASE nms WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8'; + + +ALTER DATABASE nms OWNER TO postgres; + +\connect nms + +SET statement_timeout = 0; +SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; @@ -91,7 +110,7 @@ ALTER FUNCTION public.add_new_element(sample_state, sample) OWNER TO postgres; -- Name: get_current_datarate(); Type: FUNCTION; Schema: public; Owner: nms -- -CREATE OR REPLACE FUNCTION get_current_datarate() RETURNS SETOF datarate +CREATE FUNCTION get_current_datarate() RETURNS SETOF datarate LANGUAGE sql AS $$ SELECT switch,port, @@ -303,17 +322,55 @@ CREATE TABLE dhcp ( ALTER TABLE public.dhcp OWNER TO nms; --- Name: seen_mac; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- +-- Name: linknet_ping; Type: TABLE; Schema: public; Owner: nms; Tablespace: -- -CREATE TABLE seen_mac ( - mac macaddr NOT NULL, - address inet NOT NULL, - seen timestamp with time zone DEFAULT now() NOT NULL +CREATE TABLE linknet_ping ( + linknet integer NOT NULL, + updated timestamp with time zone DEFAULT now() NOT NULL, + latency1_ms double precision, + latency2_ms double precision ); -ALTER TABLE public.seen_mac OWNER TO nms; +ALTER TABLE public.linknet_ping OWNER TO nms; + +-- +-- Name: linknets; Type: TABLE; Schema: public; Owner: nms; Tablespace: +-- + +CREATE TABLE linknets ( + linknet integer NOT NULL, + switch1 integer NOT NULL, + addr1 inet NOT NULL, + switch2 integer NOT NULL, + addr2 inet NOT NULL +); + + +ALTER TABLE public.linknets OWNER TO nms; + +-- +-- Name: linknets_linknet_seq; Type: SEQUENCE; Schema: public; Owner: nms +-- + +CREATE SEQUENCE linknets_linknet_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE public.linknets_linknet_seq OWNER TO nms; + +-- +-- Name: linknets_linknet_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nms +-- + +ALTER SEQUENCE linknets_linknet_seq OWNED BY linknets.linknet; + -- -- Name: mbd_log; Type: TABLE; Schema: public; Owner: nms; Tablespace: @@ -346,6 +403,32 @@ CREATE TABLE mldpolls ( ALTER TABLE public.mldpolls OWNER TO postgres; -- +-- Name: ping; Type: TABLE; Schema: public; Owner: nms; Tablespace: +-- + +CREATE TABLE ping ( + switch integer NOT NULL, + updated timestamp with time zone DEFAULT now() NOT NULL, + latency_ms double precision +); + + +ALTER TABLE public.ping OWNER TO nms; + +-- +-- Name: ping_secondary_ip; Type: TABLE; Schema: public; Owner: nms; Tablespace: +-- + +CREATE TABLE ping_secondary_ip ( + switch integer NOT NULL, + updated timestamp with time zone DEFAULT now() NOT NULL, + latency_ms double precision +); + + +ALTER TABLE public.ping_secondary_ip OWNER TO nms; + +-- -- Name: placements; Type: TABLE; Schema: public; Owner: nms; Tablespace: -- @@ -370,7 +453,7 @@ CREATE TABLE polls ( bytes_out bigint NOT NULL, errors_in bigint NOT NULL, errors_out bigint NOT NULL, - official_port boolean NOT NULL DEFAULT false + official_port boolean DEFAULT false NOT NULL ); ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100; @@ -405,6 +488,19 @@ CREATE TABLE portnames ( ALTER TABLE public.portnames OWNER TO nms; -- +-- Name: seen_mac; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE seen_mac ( + mac macaddr NOT NULL, + address inet NOT NULL, + seen timestamp with time zone DEFAULT now() NOT NULL +); + + +ALTER TABLE public.seen_mac OWNER TO postgres; + +-- -- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace: -- @@ -478,7 +574,6 @@ ALTER TABLE public.stemppoll_sequence OWNER TO nms; CREATE TABLE switches ( switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL, ip inet NOT NULL, - secondary_ip inet, sysname character varying NOT NULL, switchtype character varying NOT NULL, last_updated timestamp with time zone, @@ -486,7 +581,8 @@ CREATE TABLE switches ( priority integer DEFAULT 0 NOT NULL, poll_frequency interval DEFAULT '00:01:00'::interval NOT NULL, community character varying DEFAULT 'public'::character varying NOT NULL, - lldp_chassis_id character varying + lldp_chassis_id character varying, + secondary_ip inet ); @@ -546,1127 +642,11 @@ CREATE TABLE uplinks ( ALTER TABLE public.uplinks OWNER TO nms; -create table ping ( switch integer not null, updated timestamptz not null default current_timestamp, latency_ms float ); -create index updated_index on ping ( updated ); -alter table public.ping owner to nms; - -create table ping_secondary_ip ( switch integer not null, updated timestamptz not null default current_timestamp, latency_ms float ); -create index updated_index3 on ping_secondary_ip ( updated ); -alter table public.ping_secondary_ip owner to nms; - -create table linknets ( linknet serial not null, switch1 integer not null, addr1 inet not null, switch2 integer not null, addr2 inet not null ); -alter table public.linknets owner to nms; +-- +-- Name: linknet; Type: DEFAULT; Schema: public; Owner: nms +-- -create table linknet_ping ( linknet integer not null, updated timestamptz not null default current_timestamp, latency1_ms float, latency2_ms float ); -create index updated_index2 on linknet_ping ( updated ); -alter table public.linknet_ping owner to nms; - --- --- Data for Name: ap_poll; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY ap_poll (switch, model, last_poll) FROM stdin; -\. - - --- --- Data for Name: backup_polls; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY backup_polls ("time", switch, port, bytes_in, bytes_out, errors_in, errors_out) FROM stdin; -\. - - --- --- Data for Name: cpuloadpoll; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY cpuloadpoll (id, "time", switch, entity, value) FROM stdin; -\. - - --- --- Name: cpuloadpoll_id_seq; Type: SEQUENCE SET; Schema: public; Owner: nms --- - -SELECT pg_catalog.setval('cpuloadpoll_id_seq', 1, false); - - --- --- Data for Name: dhcp; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY dhcp (switch, network, last_ack, owner_color) FROM stdin; -106 151.216.27.64/26 2013-03-31 07:53:24 #000000 -2 151.216.1.64/26 2013-03-31 07:54:48 #000000 -91 151.216.23.128/26 2013-03-31 08:04:58 #000000 -108 151.216.27.192/26 2013-03-31 08:17:17 #000000 -79 151.216.20.128/26 2013-03-31 08:20:27 #000000 -83 151.216.21.128/26 2013-03-31 08:24:38 #000000 -107 151.216.27.128/26 2013-03-31 08:30:13 #000000 -31 151.216.8.128/26 2013-03-31 08:44:47 #000000 -104 151.216.26.192/26 2013-03-31 08:45:11 #000000 -11 151.216.3.128/26 2013-03-31 08:52:07 #000000 -102 151.216.26.64/26 2013-03-31 08:55:46 #000000 -15 151.216.4.128/26 2013-03-31 08:58:05 #000000 -26 151.216.7.64/26 2013-03-31 09:13:42 #000000 -93 151.216.24.0/26 2013-03-31 09:14:03 #000000 -57 151.216.15.0/26 2013-03-31 09:30:18 #000000 -47 151.216.12.128/26 2013-03-31 09:31:12 #000000 -103 151.216.26.128/26 2013-03-31 09:37:39 #000000 -23 151.216.6.128/26 2013-03-31 09:45:17 #000000 -113 151.216.29.0/26 2013-03-31 09:45:35 #000000 -18 151.216.5.64/26 2013-03-31 09:45:49 #000000 -89 151.216.23.0/26 2013-03-31 09:45:57 #000000 -114 151.216.29.64/26 2013-03-31 09:46:29 #000000 -87 151.216.22.128/26 2013-03-31 09:48:38 #000000 -8 151.216.2.192/26 2013-03-31 09:53:10 #000000 -46 151.216.12.64/26 2013-03-31 09:57:09 #000000 -95 151.216.24.128/26 2013-03-31 09:58:08 #000000 -72 151.216.18.192/26 2013-03-31 09:59:29 #000000 -116 151.216.29.192/26 2013-03-31 10:01:14 #000000 -17 151.216.5.0/26 2013-03-31 10:01:27 #000000 -59 151.216.15.128/26 2013-03-31 10:12:07 #000000 -68 151.216.17.192/26 2013-03-31 10:14:20 #000000 -22 151.216.6.64/26 2013-03-31 10:14:22 #000000 -90 151.216.23.64/26 2013-03-31 10:15:18 #000000 -30 151.216.8.64/26 2013-03-31 10:15:46 #000000 -56 151.216.14.192/26 2013-03-31 10:18:37 #000000 -61 151.216.16.0/26 2013-03-31 10:21:12 #000000 -126 151.216.32.64/26 2013-03-31 10:21:49 #000000 -24 151.216.6.192/26 2013-03-31 10:22:31 #000000 -43 151.216.11.128/26 2013-03-31 10:26:03 #000000 -28 151.216.7.192/26 2013-03-31 10:26:04 #000000 -71 151.216.18.128/26 2013-03-31 10:28:44 #000000 -75 151.216.19.128/26 2013-03-31 10:29:05 #000000 -101 151.216.26.0/26 2013-03-31 10:29:46 #000000 -128 151.216.32.192/26 2013-03-31 10:30:46 #000000 -55 151.216.14.128/26 2013-03-31 10:32:26 #000000 -4 151.216.1.192/26 2013-03-31 10:33:55 #000000 -99 151.216.25.128/26 2013-03-31 10:33:56 #000000 -85 151.216.22.0/26 2013-03-31 10:34:46 #000000 -67 151.216.17.128/26 2013-03-31 10:36:17 #000000 -49 151.216.13.0/26 2013-03-31 10:36:21 #000000 -44 151.216.11.192/26 2013-03-31 10:36:34 #000000 -70 151.216.18.64/26 2013-03-31 10:37:05 #000000 -94 151.216.24.64/26 2013-03-31 10:37:17 #000000 -73 151.216.19.0/26 2013-03-31 10:37:28 #000000 -10 151.216.3.64/26 2013-03-31 10:37:36 #000000 -64 151.216.16.192/26 2013-03-31 10:37:39 #000000 -119 151.216.30.128/26 2013-03-31 10:39:58 #000000 -48 151.216.12.192/26 2013-03-31 10:40:55 #000000 -33 151.216.9.0/26 2013-03-31 10:41:16 #000000 -1 151.216.1.0/26 2013-03-31 10:42:04 #000000 -32 151.216.8.192/26 2013-03-31 10:42:50 #000000 -3 151.216.1.128/26 2013-03-31 10:43:20 #000000 -84 151.216.21.192/26 2013-03-31 10:43:29 #000000 -13 151.216.4.0/26 2013-03-31 10:43:35 #000000 -105 151.216.27.0/26 2013-03-31 10:43:50 #000000 -42 151.216.11.64/26 2013-03-31 10:44:06 #000000 -21 151.216.6.0/26 2013-03-31 10:45:30 #000000 -60 151.216.15.192/26 2013-03-31 10:46:00 #000000 -82 151.216.21.64/26 2013-03-31 10:46:49 #000000 -80 151.216.20.192/26 2013-03-31 10:48:02 #000000 -9 151.216.3.0/26 2013-03-31 10:48:12 #000000 -78 151.216.20.64/26 2013-03-31 10:49:10 #000000 -40 151.216.10.192/26 2013-03-31 10:49:12 #000000 -120 151.216.30.192/26 2013-03-31 10:49:56 #000000 -51 151.216.13.128/26 2013-03-31 10:51:12 #000000 -111 151.216.28.128/26 2013-03-31 10:51:49 #000000 -36 151.216.9.192/26 2013-03-31 10:52:01 #000000 -127 151.216.32.128/26 2013-03-31 10:52:05 #000000 -98 151.216.25.64/26 2013-03-31 10:52:09 #000000 -50 151.216.13.64/26 2013-03-31 10:52:31 #000000 -20 151.216.5.192/26 2013-03-31 10:52:47 #000000 -41 151.216.11.0/26 2013-03-31 10:53:03 #000000 -58 151.216.15.64/26 2013-03-31 10:53:06 #000000 -37 151.216.10.0/26 2013-03-31 10:53:13 #000000 -76 151.216.19.192/26 2013-03-31 10:54:00 #000000 -34 151.216.9.64/26 2013-03-31 10:54:04 #000000 -45 151.216.12.0/26 2013-03-31 10:54:13 #000000 -65 151.216.17.0/26 2013-03-31 10:54:45 #000000 -96 151.216.24.192/26 2013-03-31 10:55:15 #000000 -74 151.216.19.64/26 2013-03-31 10:55:25 #000000 -6 151.216.2.64/26 2013-03-31 10:56:28 #000000 -53 151.216.14.0/26 2013-03-31 10:56:42 #000000 -63 151.216.16.128/26 2013-03-31 10:57:06 #000000 -7 151.216.2.128/26 2013-03-31 10:57:08 #000000 -122 151.216.31.64/26 2013-03-31 10:57:10 #000000 -52 151.216.13.192/26 2013-03-31 10:57:23 #000000 -19 151.216.5.128/26 2013-03-31 10:57:31 #000000 -27 151.216.7.128/26 2013-03-31 10:57:52 #000000 -124 151.216.31.192/26 2013-03-31 10:58:10 #000000 -16 151.216.4.192/26 2013-03-31 10:58:22 #000000 -62 151.216.16.64/26 2013-03-31 10:58:38 #000000 -110 151.216.28.64/26 2013-03-31 10:58:42 #000000 -5 151.216.2.0/26 2013-03-31 10:58:43 #000000 -35 151.216.9.128/26 2013-03-31 10:58:43 #000000 -81 151.216.21.0/26 2013-03-31 10:58:43 #000000 -25 151.216.7.0/26 2013-03-31 10:58:51 #000000 -117 151.216.30.0/26 2013-03-31 10:59:19 #000000 -115 151.216.29.128/26 2013-03-31 10:59:53 #000000 -14 151.216.4.64/26 2013-03-31 11:00:05 #000000 -38 151.216.10.64/26 2013-03-31 11:00:19 #000000 -77 151.216.20.0/26 2013-03-31 11:00:36 #000000 -12 151.216.3.192/26 2013-03-31 11:01:02 #000000 -109 151.216.28.0/26 2013-03-31 11:02:23 #000000 -97 151.216.25.0/26 2013-03-31 11:02:25 #000000 -123 151.216.31.128/26 2013-03-31 11:02:43 #000000 -121 151.216.31.0/26 2013-03-31 11:02:52 #000000 -88 151.216.22.192/26 2013-03-31 11:03:11 #000000 -29 151.216.8.0/26 2013-03-31 11:03:45 #000000 -86 151.216.22.64/26 2013-03-31 11:03:50 #000000 -125 151.216.32.0/26 2013-03-31 11:04:08 #000000 -118 151.216.30.64/26 2013-03-31 11:04:37 #000000 -66 151.216.17.64/26 2013-03-31 11:05:14 #000000 -112 151.216.28.192/26 2013-03-31 11:05:34 #000000 -92 151.216.23.192/26 2013-03-31 11:06:12 #000000 -69 151.216.18.0/26 2013-03-31 11:07:12 #000000 -39 151.216.10.128/26 2013-03-31 11:07:35 #000000 -54 151.216.14.64/26 2013-03-31 11:08:33 #000000 -100 151.216.25.192/26 2013-03-31 11:08:35 #000000 -\. - - --- --- Data for Name: ipv4; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY ipv4 (mac, address, "time", age) FROM stdin; -\. - - --- --- Data for Name: ipv6; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY ipv6 (mac, address, "time", age, vlan) FROM stdin; -\. - - --- --- Data for Name: mbd_log; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY mbd_log (ts, game, port, description, active_servers) FROM stdin; -\. - - --- --- Data for Name: mldpolls; Type: TABLE DATA; Schema: public; Owner: postgres --- - -COPY mldpolls ("time", switch, mcast_group, count, raw_portlist) FROM stdin; -\. - - --- --- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY placements (switch, placement, zorder) FROM stdin; -1 (234,310),(220,226) 0 -2 (234,226),(220,184) 0 -3 (255,310),(241,226) 0 -4 (255,226),(241,170) 0 -5 (277,310),(263,226) 0 -6 (277,226),(263,156) 0 -7 (298,310),(284,226) 0 -8 (298,226),(284,142) 0 -9 (320,310),(306,226) 0 -10 (320,226),(306,142) 0 -11 (351,507),(337,423) 0 -12 (351,423),(337,339) 0 -13 (351,310),(337,226) 0 -14 (351,226),(337,142) 0 -15 (373,507),(359,423) 0 -16 (373,423),(359,339) 0 -17 (373,310),(359,226) 0 -18 (373,226),(359,142) 0 -19 (394,507),(380,423) 0 -20 (394,423),(380,339) 0 -21 (394,310),(380,226) 0 -22 (394,226),(380,142) 0 -23 (416,507),(402,423) 0 -24 (416,423),(402,339) 0 -25 (416,310),(402,226) 0 -26 (416,226),(402,142) 0 -27 (437,507),(423,423) 0 -28 (437,423),(423,339) 0 -29 (437,310),(423,226) 0 -30 (437,226),(423,142) 0 -31 (459,507),(445,423) 0 -32 (459,423),(445,339) 0 -33 (459,310),(445,226) 0 -34 (459,226),(445,142) 0 -35 (480,507),(466,423) 0 -36 (480,423),(466,339) 0 -37 (480,310),(466,226) 0 -38 (480,226),(466,142) 0 -39 (502,507),(488,423) 0 -40 (502,423),(488,339) 0 -41 (502,310),(488,226) 0 -42 (502,226),(488,142) 0 -43 (533,507),(519,423) 0 -44 (533,423),(519,339) 0 -45 (555,507),(541,423) 0 -46 (555,423),(541,339) 0 -47 (576,507),(562,423) 0 -48 (576,423),(562,339) 0 -49 (598,507),(584,423) 0 -50 (598,423),(584,339) 0 -51 (619,507),(605,423) 0 -52 (619,423),(605,339) 0 -53 (641,507),(627,423) 0 -54 (641,423),(627,339) 0 -55 (662,507),(648,423) 0 -56 (662,423),(648,339) 0 -57 (684,507),(670,423) 0 -58 (684,423),(670,339) 0 -59 (715,507),(701,423) 0 -60 (715,423),(701,339) 0 -61 (715,310),(701,226) 0 -62 (715,226),(701,142) 0 -63 (737,507),(723,423) 0 -64 (737,423),(723,339) 0 -65 (737,310),(723,226) 0 -66 (737,226),(723,142) 0 -67 (758,507),(744,423) 0 -68 (758,423),(744,339) 0 -69 (758,310),(744,226) 0 -70 (758,226),(744,142) 0 -71 (780,507),(766,423) 0 -72 (780,423),(766,339) 0 -73 (780,310),(766,226) 0 -74 (780,226),(766,142) 0 -75 (801,507),(787,423) 0 -76 (801,423),(787,339) 0 -77 (801,310),(787,226) 0 -78 (801,226),(787,142) 0 -79 (823,507),(809,423) 0 -80 (823,423),(809,339) 0 -81 (823,310),(809,226) 0 -82 (823,226),(809,142) 0 -83 (844,507),(830,423) 0 -84 (844,423),(830,339) 0 -85 (844,310),(830,226) 0 -86 (844,226),(830,142) 0 -87 (866,507),(852,423) 0 -88 (866,423),(852,339) 0 -89 (866,310),(852,226) 0 -90 (866,226),(852,142) 0 -91 (897,507),(883,423) 0 -92 (897,423),(883,339) 0 -93 (897,310),(883,226) 0 -94 (897,226),(883,142) 0 -95 (919,507),(905,423) 0 -96 (919,423),(905,339) 0 -97 (919,310),(905,226) 0 -98 (919,226),(905,142) 0 -99 (940,507),(926,423) 0 -100 (940,423),(926,339) 0 -101 (940,310),(926,226) 0 -102 (940,226),(926,142) 0 -103 (962,507),(948,423) 0 -104 (962,423),(948,339) 0 -105 (962,310),(948,226) 0 -106 (962,226),(948,142) 0 -107 (983,507),(969,423) 0 -108 (983,423),(969,339) 0 -109 (983,310),(969,226) 0 -110 (983,226),(969,142) 0 -111 (1005,507),(991,423) 0 -112 (1005,423),(991,339) 0 -113 (1005,310),(991,226) 0 -114 (1005,226),(991,142) 0 -115 (1026,507),(1012,423) 0 -116 (1026,423),(1012,339) 0 -117 (1026,310),(1012,226) 0 -118 (1026,226),(1012,142) 0 -119 (1048,507),(1034,423) 0 -120 (1048,423),(1034,339) 0 -121 (1048,310),(1034,226) 0 -122 (1048,226),(1034,142) 0 -123 (1069,507),(1055,423) 0 -124 (1069,423),(1055,339) 0 -125 (1069,310),(1055,226) 0 -126 (1069,226),(1055,142) 0 -127 (1091,493),(1077,423) 0 -128 (1091,423),(1077,339) 0 -130 (1180,530),(1150,500) 1 -131 (1280,330),(1250,300) 1 -134 (830,130),(800,100) 1 -135 (1130,340),(1100,310) 1 -140 (360,340),(330,310) 1 -141 (460,340),(430,310) 1 -142 (730,340),(700,310) 1 -143 (800,340),(770,310) 1 -144 (1000,340),(970,310) 1 -136 (160,340),(130,310) 1 -132 (680,80),(650,50) 1 -133 (680,130),(650,100) 1 -137 (430,600),(400,570) 1 -139 (730,600),(700,570) 1 -138 (630,600),(600,570) 1 -129 (780,600),(750,570) 1 -360 (866,507),(852,423) 0 -359 (844,226),(830,142) 0 -361 (866,423),(852,339) 0 -397 (1069,423),(1055,339) 0 -379 (962,226),(948,142) 0 -373 (940,423),(926,339) 0 -297 (416,423),(402,339) 0 -300 (437,507),(423,423) 0 -321 (576,423),(562,339) 0 -288 (373,507),(359,423) 0 -332 (715,507),(701,423) 0 -325 (619,423),(605,339) 0 -326 (641,507),(627,423) 0 -381 (983,423),(969,339) 0 -335 (715,226),(701,142) 0 -305 (459,423),(445,339) 0 -368 (919,507),(905,423) 0 -296 (416,507),(402,423) 0 -316 (533,507),(519,423) 0 -376 (962,507),(948,423) 0 -357 (844,423),(830,339) 0 -286 (351,310),(337,226) 0 -327 (641,423),(627,339) 0 -280 (298,310),(284,226) 0 -369 (919,423),(905,339) 0 -298 (416,310),(402,226) 0 -307 (459,226),(445,142) 0 -336 (737,507),(723,423) 0 -328 (662,507),(648,423) 0 -399 (1069,226),(1055,142) 0 -378 (962,310),(948,226) 0 -292 (394,507),(380,423) 0 -314 (502,310),(488,226) 0 -333 (715,423),(701,339) 0 -275 (234,226),(220,184) 0 -380 (983,507),(969,423) 0 -363 (866,226),(852,142) 0 -371 (919,226),(905,142) 0 -295 (394,226),(380,142) 0 -322 (598,507),(584,423) 0 -313 (502,423),(488,339) 0 -337 (737,423),(723,339) 0 -329 (662,423),(648,339) 0 -372 (940,507),(926,423) 0 -370 (919,310),(905,226) 0 -334 (715,310),(701,226) 0 -277 (255,226),(241,170) 0 -377 (962,423),(948,339) 0 -382 (983,310),(969,226) 0 -294 (394,310),(380,226) 0 -338 (737,310),(723,226) 0 -331 (684,423),(670,339) 0 -276 (255,310),(241,226) 0 -367 (897,226),(883,142) 0 -365 (897,423),(883,339) 0 -274 (234,310),(220,226) 0 -278 (277,310),(263,226) 0 -323 (598,423),(584,339) 0 -315 (502,226),(488,142) 0 -358 (844,310),(830,226) 0 -383 (983,226),(969,142) 0 -364 (897,507),(883,423) 0 -289 (373,423),(359,339) 0 -374 (940,310),(926,226) 0 -339 (737,226),(723,142) 0 -340 (758,507),(744,423) 0 -320 (576,507),(562,423) 0 -279 (277,226),(263,156) 0 -400 (1091,493),(1077,423) 0 -356 (844,507),(830,423) 0 -285 (351,423),(337,339) 0 -398 (1069,310),(1055,226) 0 -384 (1005,507),(991,423) 0 -302 (437,310),(423,226) 0 -391 (1026,226),(1012,142) 0 -394 (1048,310),(1034,226) 0 -318 (555,507),(541,423) 0 -341 (758,423),(744,339) 0 -319 (555,423),(541,339) 0 -342 (758,310),(744,226) 0 -395 (1048,226),(1034,142) 0 -304 (459,507),(445,423) 0 -401 (1091,423),(1077,339) 0 -343 (758,226),(744,142) 0 -385 (1005,423),(991,339) 0 -312 (502,507),(488,423) 0 -392 (1048,507),(1034,423) 0 -291 (373,226),(359,142) 0 -344 (780,507),(766,423) 0 -396 (1069,507),(1055,423) 0 -345 (780,423),(766,339) 0 -386 (1005,310),(991,226) 0 -306 (459,310),(445,226) 0 -355 (823,226),(809,142) 0 -293 (394,423),(380,339) 0 -346 (780,310),(766,226) 0 -283 (320,226),(306,142) 0 -347 (780,226),(766,142) 0 -387 (1005,226),(991,142) 0 -330 (684,507),(670,423) 0 -290 (373,310),(359,226) 0 -303 (437,226),(423,142) 0 -317 (533,423),(519,339) 0 -348 (801,507),(787,423) 0 -366 (897,310),(883,226) 0 -301 (437,423),(423,339) 0 -362 (866,310),(852,226) 0 -388 (1026,507),(1012,423) 0 -281 (298,226),(284,142) 0 -349 (801,423),(787,339) 0 -393 (1048,423),(1034,339) 0 -350 (801,310),(787,226) 0 -308 (480,507),(466,423) 0 -311 (480,226),(466,142) 0 -351 (801,226),(787,142) 0 -389 (1026,423),(1012,339) 0 -375 (940,226),(926,142) 0 -287 (351,226),(337,142) 0 -310 (480,310),(466,226) 0 -282 (320,310),(306,226) 0 -352 (823,507),(809,423) 0 -390 (1026,310),(1012,226) 0 -353 (823,423),(809,339) 0 -284 (351,507),(337,423) 0 -324 (619,507),(605,423) 0 -354 (823,310),(809,226) 0 -299 (416,226),(402,142) 0 -309 (480,423),(466,339) 0 -402 (460,340),(430,310) 1 -403 (730,340),(700,310) 1 -404 (800,340),(770,310) 1 -405 (360,340),(330,310) 1 -406 (1000,340),(970,310) 1 -407 (1130,310),(1076,296) 0 -408 (1190,310),(1136,296) 0 -409 (1130,290),(1076,276) 0 -410 (1190,290),(1136,276) 0 -411 (1130,270),(1076,256) 0 -412 (1190,270),(1136,256) 0 -413 (1130,250),(1076,236) 0 -414 (1190,250),(1136,236) 0 -415 (1164,230),(1076,216) 0 -416 (1164,210),(1076,196) 0 -417 (1164,190),(1076,176) 0 -\. - - --- --- Data for Name: polls; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY polls ("time", switch, port, bytes_in, bytes_out, errors_in, errors_out) FROM stdin; -\. - - --- --- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: nms --- - -SELECT pg_catalog.setval('polls_poll_seq', 1, false); - - --- --- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY portnames (switchtype, port, description) FROM stdin; -dlink3100 1 Ethernet Interface (port 1) -dlink3100 2 Ethernet Interface (port 2) -dlink3100 3 Ethernet Interface (port 3) -dlink3100 4 Ethernet Interface (port 4) -dlink3100 5 Ethernet Interface (port 5) -dlink3100 6 Ethernet Interface (port 6) -dlink3100 7 Ethernet Interface (port 7) -dlink3100 8 Ethernet Interface (port 8) -dlink3100 9 Ethernet Interface (port 9) -dlink3100 10 Ethernet Interface (port 10) -dlink3100 11 Ethernet Interface (port 11) -dlink3100 12 Ethernet Interface (port 12) -dlink3100 13 Ethernet Interface (port 13) -dlink3100 14 Ethernet Interface (port 14) -dlink3100 15 Ethernet Interface (port 15) -dlink3100 16 Ethernet Interface (port 16) -dlink3100 17 Ethernet Interface (port 17) -dlink3100 18 Ethernet Interface (port 18) -dlink3100 19 Ethernet Interface (port 19) -dlink3100 20 Ethernet Interface (port 20) -dlink3100 21 Ethernet Interface (port 21) -dlink3100 22 Ethernet Interface (port 22) -dlink3100 23 Ethernet Interface (port 23) -dlink3100 24 Ethernet Interface (port 24) -dlink3100 25 Ethernet Interface (port 25) -dlink3100 26 Ethernet Interface (port 26) -dlink3100 27 Ethernet Interface (port 27) -dlink3100 28 Ethernet Interface (port 28) -dlink3100 29 Ethernet Interface (port 29) -dlink3100 30 Ethernet Interface (port 30) -dlink3100 31 Ethernet Interface (port 31) -dlink3100 32 Ethernet Interface (port 32) -dlink3100 33 Ethernet Interface (port 33) -dlink3100 34 Ethernet Interface (port 34) -dlink3100 35 Ethernet Interface (port 35) -dlink3100 36 Ethernet Interface (port 36) -dlink3100 37 Ethernet Interface (port 37) -dlink3100 38 Ethernet Interface (port 38) -dlink3100 39 Ethernet Interface (port 39) -dlink3100 40 Ethernet Interface (port 40) -dlink3100 41 Ethernet Interface (port 41) -dlink3100 42 Ethernet Interface (port 42) -dlink3100 43 Ethernet Interface (port 43) -dlink3100 44 Ethernet Interface (port 44) -dlink3100 45 Ethernet Interface (port 45) -dlink3100 46 Ethernet Interface (port 46) -dlink3100 47 Ethernet Interface (port 47) -dlink3100 48 Ethernet Interface (port 48) -dlink3100 301 Ethernet Interface (port 301) -dlink3100 302 Ethernet Interface (port 302) -dlink3100 303 Ethernet Interface (port 303) -dlink3100 304 Ethernet Interface (port 304) -dlink3100 305 Ethernet Interface (port 305) -dlink3100 306 Ethernet Interface (port 306) -dlink3100 307 Ethernet Interface (port 307) -dlink3100 308 Ethernet Interface (port 308) -dlink3100 309 Ethernet Interface (port 309) -dlink3100 310 Ethernet Interface (port 310) -dlink3100 311 Ethernet Interface (port 311) -dlink3100 312 Ethernet Interface (port 312) -dlink3100 313 Ethernet Interface (port 313) -dlink3100 314 Ethernet Interface (port 314) -dlink3100 315 Ethernet Interface (port 315) -dlink3100 316 Ethernet Interface (port 316) -dlink3100 317 Ethernet Interface (port 317) -dlink3100 318 Ethernet Interface (port 318) -dlink3100 319 Ethernet Interface (port 319) -dlink3100 320 Ethernet Interface (port 320) -dlink3100 321 Ethernet Interface (port 321) -dlink3100 322 Ethernet Interface (port 322) -dlink3100 323 Ethernet Interface (port 323) -dlink3100 324 Ethernet Interface (port 324) -dlink3100 325 Ethernet Interface (port 325) -dlink3100 326 Ethernet Interface (port 326) -dlink3100 327 Ethernet Interface (port 327) -dlink3100 328 Ethernet Interface (port 328) -dlink3100 329 Ethernet Interface (port 329) -dlink3100 330 Ethernet Interface (port 330) -dlink3100 331 Ethernet Interface (port 331) -dlink3100 332 Ethernet Interface (port 332) -dlink3100 9000 Internal Interface (port 9000) -dlink3100 100000 vlan (port 100000) -\. - - --- --- Data for Name: squeue; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin; -\. - - --- --- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms --- - -SELECT pg_catalog.setval('squeue_group_sequence', 71, true); - - --- --- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms --- - -SELECT pg_catalog.setval('squeue_sequence', 3324, true); - - --- --- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms --- - -SELECT pg_catalog.setval('stemppoll_sequence', 1, false); - - --- --- Data for Name: switches; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY switches (switch, ip, sysname, switchtype, last_updated, locked, priority, poll_frequency, community) FROM stdin; -320 127.0.0.1 ap-e31-1 ciscoap 2013-03-31 14:03:35.163353+02 f 0 00:05:00 <removed> -380 127.0.0.1 ap-e67-1 ciscoap 2013-03-31 14:03:45.678972+02 f 0 00:05:00 <removed> -301 127.0.0.1 ap-e19-2 ciscoap 2013-03-31 14:04:15.974348+02 f 0 00:05:00 <removed> -89 151.216.23.2 e57-3 dlink3100 2013-03-31 14:09:08.899489+02 f 0 00:01:00 <removed> -32 151.216.8.194 e21-2 dlink3100 2013-03-31 14:09:19.750092+02 f 0 00:01:00 <removed> -407 151.216.50.2 creativiasw01 dlink3100 2013-03-31 14:09:29.799659+02 f 0 00:01:00 <removed> -121 151.216.31.2 e73-3 dlink3100 2013-03-31 14:09:39.03767+02 f 0 00:01:00 <removed> -3 151.216.1.130 e3-3 dlink3100 2013-03-31 14:10:38.32422+02 f 0 00:01:00 <removed> -57 151.216.15.2 e41-1 dlink3100 2013-03-31 14:10:46.324438+02 f 0 00:01:00 <removed> -97 151.216.25.2 e61-3 dlink3100 2013-03-31 14:10:56.366466+02 f 0 00:01:00 <removed> -108 151.216.27.194 e67-2 dlink3100 2013-03-31 14:11:06.409468+02 f 0 00:01:00 <removed> -65 151.216.17.2 e45-3 dlink3100 2013-03-31 14:11:16.450631+02 f 0 00:01:00 <removed> -416 151.216.50.11 creativiasw10 dlink3100 2013-03-31 14:11:29.776178+02 f 0 00:01:00 <removed> -22 151.216.6.66 e15-4 dlink3100 2013-03-31 14:11:40.601614+02 f 0 00:01:00 <removed> -30 151.216.8.66 e19-4 dlink3100 2013-03-31 14:11:49.857971+02 f 0 00:01:00 <removed> -18 151.216.5.66 e13-4 dlink3100 2013-03-31 14:12:00.689688+02 f 0 00:01:00 <removed> -43 151.216.11.130 e27-1 dlink3100 2013-03-31 14:12:10.733619+02 f 0 00:01:00 <removed> -24 151.216.6.194 e17-2 dlink3100 2013-03-31 14:12:19.983821+02 f 0 00:01:00 <removed> -4 151.216.1.194 e3-4 dlink3100 2013-03-31 14:12:30.025734+02 f 0 00:01:00 <removed> -31 151.216.8.130 e21-1 dlink3100 2013-03-31 14:09:05.474089+02 f 0 00:01:00 <removed> -47 151.216.12.130 e31-1 dlink3100 2013-03-31 14:12:40.068048+02 f 0 00:01:00 <removed> -92 151.216.23.194 e59-2 dlink3100 2013-03-31 14:09:15.523555+02 f 0 00:01:00 <removed> -33 151.216.9.2 e21-3 dlink3100 2013-03-31 14:09:25.573946+02 f 0 00:01:00 <removed> -20 151.216.5.194 e15-2 dlink3100 2013-03-31 14:09:35.626024+02 f 0 00:01:00 <removed> -133 151.216.127.5 wtfgw wtfgw 2013-03-31 14:09:35.670908+02 f 0 00:01:00 <removed> -28 151.216.7.194 e19-2 dlink3100 2013-03-31 14:09:45.955527+02 f 0 00:01:00 <removed> -67 151.216.17.130 e47-1 dlink3100 2013-03-31 14:09:58.029684+02 f 0 00:01:00 <removed> -26 151.216.7.66 e17-4 dlink3100 2013-03-31 14:10:08.127872+02 f 0 00:01:00 <removed> -102 151.216.26.66 e63-4 dlink3100 2013-03-31 14:10:16.136217+02 f 0 00:01:00 <removed> -125 151.216.32.2 e75-3 dlink3100 2013-03-31 14:10:26.181503+02 f 0 00:01:00 <removed> -130 151.216.127.1 telegw telegw 2013-03-31 14:07:58.60478+02 f 0 00:01:00 <removed> -412 151.216.50.7 creativiasw06 dlink3100 2013-03-31 14:09:09.699614+02 f 0 00:01:00 <removed> -128 151.216.32.194 e77-2 dlink3100 2013-03-31 14:09:27.615732+02 f 0 00:01:00 <removed> -408 151.216.50.3 creativiasw02 dlink3100 2013-03-31 14:09:37.667708+02 f 0 00:01:00 <removed> -417 151.216.50.12 creativiasw11 dlink3100 2013-03-31 14:09:47.935097+02 f 0 00:01:00 <removed> -127 151.216.32.130 e77-1 dlink3100 2013-03-31 14:09:56.039513+02 f 0 00:01:00 <removed> -376 127.0.0.1 ap-e65-1 ciscoap 2013-03-31 14:03:45.695637+02 f 0 00:05:00 <removed> -112 151.216.28.194 e69-2 dlink3100 2013-03-31 14:10:06.089831+02 f 0 00:01:00 <removed> -9 151.216.3.2 e9-3 dlink3100 2013-03-31 14:10:18.178421+02 f 0 00:01:00 <removed> -83 151.216.21.130 e55-1 dlink3100 2013-03-31 14:10:28.282289+02 f 0 00:01:00 <removed> -13 151.216.4.2 e11-3 dlink3100 2013-03-31 14:10:30.307108+02 f 0 00:01:00 <removed> -343 127.0.0.1 ap-e47-4 ciscoap 2013-03-31 14:04:46.367004+02 f 0 00:05:00 <removed> -45 151.216.12.2 e29-1 dlink3100 2013-03-31 14:10:39.315785+02 f 0 00:01:00 <removed> -297 127.0.0.1 ap-e17-2 ciscoap 2013-03-31 14:04:46.750319+02 f 0 00:05:00 <removed> -293 127.0.0.1 ap-e15-2 ciscoap 2013-03-31 14:05:06.492611+02 f 0 00:05:00 <removed> -350 127.0.0.1 ap-e51-3 ciscoap 2013-03-31 14:05:06.525983+02 f 0 00:05:00 <removed> -363 127.0.0.1 ap-e57-4 ciscoap 2013-03-31 14:05:16.625481+02 f 0 00:05:00 <removed> -368 127.0.0.1 ap-e61-1 ciscoap 2013-03-31 14:05:16.700464+02 f 0 00:05:00 <removed> -388 127.0.0.1 ap-e71-1 ciscoap 2013-03-31 14:05:26.787007+02 f 0 00:05:00 <removed> -304 127.0.0.1 ap-e21-1 ciscoap 2013-03-31 14:05:26.853688+02 f 0 00:05:00 <removed> -352 127.0.0.1 ap-e53-1 ciscoap 2013-03-31 14:05:26.887026+02 f 0 00:05:00 <removed> -323 127.0.0.1 ap-e33-2 ciscoap 2013-03-31 14:05:26.912028+02 f 0 00:05:00 <removed> -406 127.0.0.1 ap-distro4 ciscoap 2013-03-31 14:05:27.045455+02 f 0 00:05:00 <removed> -339 127.0.0.1 ap-e45-4 ciscoap 2013-03-31 14:05:27.053748+02 f 0 00:05:00 <removed> -393 127.0.0.1 ap-e73-2 ciscoap 2013-03-31 14:04:26.17466+02 f 0 00:05:00 <removed> -337 127.0.0.1 ap-e45-2 ciscoap 2013-03-31 14:04:26.191324+02 f 0 00:05:00 <removed> -384 127.0.0.1 ap-e69-1 ciscoap 2013-03-31 14:04:26.207988+02 f 0 00:05:00 <removed> -387 127.0.0.1 ap-e69-4 ciscoap 2013-03-31 14:04:26.224645+02 f 0 00:05:00 <removed> -371 127.0.0.1 ap-e61-4 ciscoap 2013-03-31 14:04:36.283297+02 f 0 00:05:00 <removed> -398 127.0.0.1 ap-e75-3 ciscoap 2013-03-31 14:04:46.333668+02 f 0 00:05:00 <removed> -351 127.0.0.1 ap-e51-4 ciscoap 2013-03-31 14:04:46.350332+02 f 0 00:05:00 <removed> -356 127.0.0.1 ap-e55-1 ciscoap 2013-03-31 14:04:46.383667+02 f 0 00:05:00 <removed> -389 127.0.0.1 ap-e71-2 ciscoap 2013-03-31 14:04:46.733636+02 f 0 00:05:00 <removed> -372 127.0.0.1 ap-e63-1 ciscoap 2013-03-31 14:05:06.509265+02 f 0 00:05:00 <removed> -328 127.0.0.1 ap-e39-1 ciscoap 2013-03-31 14:05:16.608766+02 f 0 00:05:00 <removed> -5 151.216.2.2 e5-3 dlink3100 2013-03-31 14:09:17.565638+02 f 0 00:01:00 <removed> -50 151.216.13.66 e33-2 dlink3100 2013-03-31 14:09:18.937921+02 f 0 00:01:00 <removed> -103 151.216.26.130 e65-1 dlink3100 2013-03-31 14:09:28.988094+02 f 0 00:01:00 <removed> -91 151.216.23.130 e59-1 dlink3100 2013-03-31 14:09:39.851074+02 f 0 00:01:00 <removed> -63 151.216.16.130 e45-1 dlink3100 2013-03-31 14:09:49.897376+02 f 0 00:01:00 <removed> -7 151.216.2.130 e7-3 dlink3100 2013-03-31 14:09:59.947741+02 f 0 00:01:00 <removed> -100 151.216.25.194 e63-2 dlink3100 2013-03-31 14:10:10.223204+02 f 0 00:01:00 <removed> -84 151.216.21.194 e55-2 dlink3100 2013-03-31 14:10:19.231795+02 f 0 00:01:00 <removed> -126 151.216.32.66 e75-4 dlink3100 2013-03-31 14:10:29.273823+02 f 0 00:01:00 <removed> -361 127.0.0.1 ap-e57-2 ciscoap 2013-03-31 14:04:16.074284+02 f 0 00:05:00 <removed> -312 127.0.0.1 ap-e25-1 ciscoap 2013-03-31 14:04:26.124587+02 f 0 00:05:00 <removed> -310 127.0.0.1 ap-e23-3 ciscoap 2013-03-31 14:04:26.141221+02 f 0 00:05:00 <removed> -308 127.0.0.1 ap-e23-1 ciscoap 2013-03-31 14:04:26.157994+02 f 0 00:05:00 <removed> -104 151.216.26.194 e65-2 dlink3100 2013-03-31 14:10:09.189552+02 f 0 00:01:00 <removed> -119 151.216.30.130 e73-1 dlink3100 2013-03-31 14:12:40.859661+02 f 0 00:01:00 <removed> -69 151.216.18.2 e47-3 dlink3100 2013-03-31 14:10:20.265181+02 f 0 00:01:00 <removed> -37 151.216.10.2 e23-3 dlink3100 2013-03-31 14:12:40.88249+02 t 0 00:01:00 <removed> -325 127.0.0.1 ap-e35-2 ciscoap 2013-03-31 14:06:47.598526+02 f 0 00:05:00 <removed> -52 151.216.13.194 e35-2 dlink3100 2013-03-31 14:10:36.22414+02 f 0 00:01:00 <removed> -399 127.0.0.1 ap-e75-4 ciscoap 2013-03-31 14:06:54.140511+02 f 0 00:05:00 <removed> -401 127.0.0.1 ap-e77-2 ciscoap 2013-03-31 14:05:06.475953+02 f 0 00:05:00 <removed> -109 151.216.28.2 e67-3 dlink3100 2013-03-31 14:10:40.349205+02 f 0 00:01:00 <removed> -123 151.216.31.130 e75-1 dlink3100 2013-03-31 14:10:49.357742+02 f 0 00:01:00 <removed> -332 127.0.0.1 ap-e43-1 ciscoap 2013-03-31 14:06:54.157133+02 f 0 00:05:00 <removed> -98 151.216.25.66 e61-4 dlink3100 2013-03-31 14:06:56.826042+02 f 0 00:01:00 <removed> -117 151.216.30.2 e71-3 dlink3100 2013-03-31 14:10:59.399785+02 f 0 00:01:00 <removed> -101 151.216.26.2 e63-3 dlink3100 2013-03-31 14:11:09.441726+02 f 0 00:01:00 <removed> -39 151.216.10.130 e25-1 dlink3100 2013-03-31 14:11:20.517295+02 f 0 00:01:00 <removed> -290 127.0.0.1 ap-e13-3 ciscoap 2013-03-31 14:05:16.592114+02 f 0 00:05:00 <removed> -345 127.0.0.1 ap-e49-2 ciscoap 2013-03-31 14:06:57.657385+02 f 0 00:05:00 <removed> -366 127.0.0.1 ap-e59-3 ciscoap 2013-03-31 14:06:57.665697+02 f 0 00:05:00 <removed> -392 127.0.0.1 ap-e73-1 ciscoap 2013-03-31 14:04:15.990948+02 f 0 00:05:00 <removed> -355 127.0.0.1 ap-e53-4 ciscoap 2013-03-31 14:05:16.658807+02 f 0 00:05:00 <removed> -86 151.216.22.66 e55-4 dlink3100 2013-03-31 14:11:30.559419+02 f 0 00:01:00 <removed> -277 127.0.0.1 ap-e3-4 ciscoap 2013-03-31 14:04:16.007613+02 f 0 00:05:00 <removed> -40 151.216.10.194 e25-2 dlink3100 2013-03-31 14:11:39.818373+02 f 0 00:01:00 <removed> -314 127.0.0.1 ap-e25-3 ciscoap 2013-03-31 14:04:16.024289+02 f 0 00:05:00 <removed> -289 127.0.0.1 ap-e13-2 ciscoap 2013-03-31 14:06:57.724049+02 f 0 00:05:00 <removed> -2 151.216.1.66 e1-4 dlink3100 2013-03-31 14:11:50.641091+02 f 0 00:01:00 <removed> -302 127.0.0.1 ap-e19-3 ciscoap 2013-03-31 14:06:57.732372+02 f 0 00:05:00 <removed> -99 151.216.25.130 e63-1 dlink3100 2013-03-31 14:11:59.899883+02 f 0 00:01:00 <removed> -344 127.0.0.1 ap-e49-1 ciscoap 2013-03-31 14:04:16.04092+02 f 0 00:05:00 <removed> -335 127.0.0.1 ap-e43-4 ciscoap 2013-03-31 14:06:57.799008+02 f 0 00:05:00 <removed> -279 127.0.0.1 ap-e5-4 ciscoap 2013-03-31 14:04:16.057621+02 f 0 00:05:00 <removed> -38 151.216.10.66 e23-4 dlink3100 2013-03-31 14:12:09.94159+02 f 0 00:01:00 <removed> -285 127.0.0.1 ap-e11-2 ciscoap 2013-03-31 14:06:57.824055+02 f 0 00:05:00 <removed> -404 127.0.0.1 ap-distro3 ciscoap 2013-03-31 14:06:57.832368+02 f 0 00:05:00 <removed> -21 151.216.6.2 e15-3 dlink3100 2013-03-31 14:12:20.775526+02 f 0 00:01:00 <removed> -131 151.216.127.3 camgw camgw 2013-03-31 14:08:59.442796+02 f 0 00:01:00 <removed> -415 151.216.50.10 creativiasw09 dlink3100 2013-03-31 14:09:49.089144+02 f 0 00:01:00 <removed> -23 151.216.6.130 e17-1 dlink3100 2013-03-31 14:12:30.817401+02 f 0 00:01:00 <removed> -140 151.216.127.17 distro0 distro0 2013-03-31 14:09:59.139467+02 f 0 00:01:00 <removed> -303 127.0.0.1 ap-e19-4 ciscoap 2013-03-31 14:05:27.020371+02 f 0 00:05:00 <removed> -348 127.0.0.1 ap-e51-1 ciscoap 2013-03-31 14:07:14.399896+02 f 0 00:05:00 <removed> -46 151.216.12.66 e29-2 dlink3100 2013-03-31 14:11:58.658094+02 f 0 00:01:00 <removed> -311 127.0.0.1 ap-e23-4 ciscoap 2013-03-31 14:07:14.433216+02 f 0 00:05:00 <removed> -6 151.216.2.66 e5-4 dlink3100 2013-03-31 14:12:08.075251+02 f 0 00:01:00 <removed> -61 151.216.16.2 e43-3 dlink3100 2013-03-31 14:12:18.115548+02 f 0 00:01:00 <removed> -281 127.0.0.1 ap-e7-4 ciscoap 2013-03-31 14:07:14.449892+02 f 0 00:05:00 <removed> -42 151.216.11.66 e25-4 dlink3100 2013-03-31 14:12:28.78394+02 f 0 00:01:00 <removed> -124 151.216.31.194 e75-2 dlink3100 2013-03-31 14:12:38.82574+02 f 0 00:01:00 <removed> -341 127.0.0.1 ap-e47-2 ciscoap 2013-03-31 14:07:14.49997+02 f 0 00:05:00 <removed> -394 127.0.0.1 ap-e73-3 ciscoap 2013-03-31 14:07:18.250168+02 f 0 00:05:00 <removed> -134 151.216.127.6 logistikkgw logistikkgw 2013-03-31 14:09:37.70706+02 f 0 00:01:00 <removed> -296 127.0.0.1 ap-e17-1 ciscoap 2013-03-31 14:05:16.642148+02 f 0 00:05:00 <removed> -342 127.0.0.1 ap-e47-3 ciscoap 2013-03-31 14:05:16.683807+02 f 0 00:05:00 <removed> -138 151.216.127.14 sponsorgw sponsorgw 2013-03-31 14:10:36.296979+02 f 0 00:01:00 <removed> -300 127.0.0.1 ap-e19-1 ciscoap 2013-03-31 14:05:26.753695+02 f 0 00:05:00 <removed> -74 151.216.19.66 e49-4 dlink3100 2013-03-31 14:10:48.366303+02 f 0 00:01:00 <removed> -90 151.216.23.66 e57-4 dlink3100 2013-03-31 14:10:50.391178+02 f 0 00:01:00 <removed> -364 127.0.0.1 ap-e59-1 ciscoap 2013-03-31 14:06:57.699034+02 f 0 00:05:00 <removed> -14 151.216.4.66 e11-4 dlink3100 2013-03-31 14:11:00.431572+02 f 0 00:01:00 <removed> -280 127.0.0.1 ap-e7-3 ciscoap 2013-03-31 14:05:26.803681+02 f 0 00:05:00 <removed> -357 127.0.0.1 ap-e55-2 ciscoap 2013-03-31 14:06:57.757379+02 f 0 00:05:00 <removed> -144 151.216.127.21 distro4 distro4 2013-03-31 14:11:18.492445+02 f 0 00:01:00 <removed> -19 151.216.5.130 e15-1 dlink3100 2013-03-31 14:11:19.483883+02 f 0 00:01:00 <removed> -307 127.0.0.1 ap-e21-4 ciscoap 2013-03-31 14:06:57.790715+02 f 0 00:05:00 <removed> -85 151.216.22.2 e55-3 dlink3100 2013-03-31 14:11:38.576512+02 f 0 00:01:00 <removed> -286 127.0.0.1 ap-e11-3 ciscoap 2013-03-31 14:05:26.837029+02 f 0 00:05:00 <removed> -369 127.0.0.1 ap-e61-2 ciscoap 2013-03-31 14:06:57.857392+02 f 0 00:05:00 <removed> -10 151.216.3.66 e9-4 dlink3100 2013-03-31 14:11:48.616108+02 f 0 00:01:00 <removed> -385 127.0.0.1 ap-e69-2 ciscoap 2013-03-31 14:07:07.916359+02 f 0 00:05:00 <removed> -288 127.0.0.1 ap-e13-1 ciscoap 2013-03-31 14:05:26.945339+02 f 0 00:05:00 <removed> -282 127.0.0.1 ap-e9-3 ciscoap 2013-03-31 14:07:07.924585+02 f 0 00:05:00 <removed> -358 127.0.0.1 ap-e55-3 ciscoap 2013-03-31 14:05:26.953679+02 f 0 00:05:00 <removed> -396 127.0.0.1 ap-e75-1 ciscoap 2013-03-31 14:07:14.333223+02 f 0 00:05:00 <removed> -374 127.0.0.1 ap-e63-3 ciscoap 2013-03-31 14:07:14.349887+02 f 0 00:05:00 <removed> -365 127.0.0.1 ap-e59-2 ciscoap 2013-03-31 14:05:26.978658+02 f 0 00:05:00 <removed> -276 127.0.0.1 ap-e3-3 ciscoap 2013-03-31 14:05:26.987059+02 f 0 00:05:00 <removed> -334 127.0.0.1 ap-e43-3 ciscoap 2013-03-31 14:05:27.012008+02 f 0 00:05:00 <removed> -382 127.0.0.1 ap-e67-3 ciscoap 2013-03-31 14:07:14.466569+02 f 0 00:05:00 <removed> -62 151.216.16.66 e43-4 dlink3100 2013-03-31 14:12:08.699458+02 f 0 00:01:00 <removed> -275 127.0.0.1 ap-e1-4 ciscoap 2013-03-31 14:07:14.483301+02 f 0 00:05:00 <removed> -36 151.216.9.194 e23-2 dlink3100 2013-03-31 14:12:18.742024+02 f 0 00:01:00 <removed> -51 151.216.13.130 e35-1 dlink3100 2013-03-31 14:12:28.217471+02 f 0 00:01:00 <removed> -324 127.0.0.1 ap-e35-1 ciscoap 2013-03-31 14:07:14.516632+02 f 0 00:05:00 <removed> -1 151.216.1.2 e1-3 dlink3100 2013-03-31 14:12:38.299693+02 f 0 00:01:00 <removed> -291 127.0.0.1 ap-e13-4 ciscoap 2013-03-31 14:05:47.253657+02 f 0 00:05:00 <removed> -381 127.0.0.1 ap-e67-2 ciscoap 2013-03-31 14:07:14.533237+02 f 0 00:05:00 <removed> -395 127.0.0.1 ap-e73-4 ciscoap 2013-03-31 14:05:47.261963+02 f 0 00:05:00 <removed> -298 127.0.0.1 ap-e17-3 ciscoap 2013-03-31 14:07:18.24186+02 f 0 00:05:00 <removed> -375 127.0.0.1 ap-e63-4 ciscoap 2013-03-31 14:05:26.770358+02 f 0 00:05:00 <removed> -402 127.0.0.1 ap-distro1 ciscoap 2013-03-31 14:05:47.286984+02 f 0 00:05:00 <removed> -278 127.0.0.1 ap-e5-3 ciscoap 2013-03-31 14:07:18.275213+02 f 0 00:05:00 <removed> -349 127.0.0.1 ap-e51-2 ciscoap 2013-03-31 14:05:26.820365+02 f 0 00:05:00 <removed> -390 127.0.0.1 ap-e71-3 ciscoap 2013-03-31 14:05:26.870368+02 f 0 00:05:00 <removed> -135 151.216.127.9 crewgw crewgw 2013-03-31 14:09:59.991016+02 f 0 00:01:00 <removed> -88 151.216.22.194 e57-2 dlink3100 2013-03-31 14:10:58.408324+02 f 0 00:01:00 <removed> -378 127.0.0.1 ap-e65-3 ciscoap 2013-03-31 14:05:26.920352+02 f 0 00:05:00 <removed> -64 151.216.16.194 e45-2 dlink3100 2013-03-31 14:11:08.451146+02 f 0 00:01:00 <removed> -141 151.216.127.18 distro1 distro1 2013-03-31 14:11:10.476036+02 f 0 00:01:00 <removed> -397 127.0.0.1 ap-e75-2 ciscoap 2013-03-31 14:06:57.690716+02 f 0 00:05:00 <removed> -142 151.216.127.19 distro2 distro2 2013-03-31 14:11:26.53242+02 f 0 00:01:00 <removed> -336 127.0.0.1 ap-e45-1 ciscoap 2013-03-31 14:05:37.128164+02 f 0 00:05:00 <removed> -370 127.0.0.1 ap-e61-3 ciscoap 2013-03-31 14:05:37.136492+02 f 0 00:05:00 <removed> -340 127.0.0.1 ap-e47-1 ciscoap 2013-03-31 14:06:57.765706+02 f 0 00:05:00 <removed> -137 151.216.127.12 resepsjongw resepsjongw 2013-03-31 14:11:28.534488+02 f 0 00:01:00 <removed> -71 151.216.18.130 e49-1 dlink3100 2013-03-31 14:11:36.567717+02 f 0 00:01:00 <removed> -319 127.0.0.1 ap-e29-2 ciscoap 2013-03-31 14:07:07.949621+02 f 0 00:05:00 <removed> -82 151.216.21.66 e53-4 dlink3100 2013-03-31 14:11:47.281839+02 f 0 00:01:00 <removed> -403 127.0.0.1 ap-distro2 ciscoap 2013-03-31 14:07:14.316549+02 f 0 00:05:00 <removed> -333 127.0.0.1 ap-e43-2 ciscoap 2013-03-31 14:07:14.366567+02 f 0 00:05:00 <removed> -305 127.0.0.1 ap-e21-2 ciscoap 2013-03-31 14:05:37.161496+02 f 0 00:05:00 <removed> -383 127.0.0.1 ap-e67-4 ciscoap 2013-03-31 14:05:37.169782+02 f 0 00:05:00 <removed> -35 151.216.9.130 e23-1 dlink3100 2013-03-31 14:11:57.324788+02 f 0 00:01:00 <removed> -329 127.0.0.1 ap-e39-2 ciscoap 2013-03-31 14:07:14.383235+02 f 0 00:05:00 <removed> -295 127.0.0.1 ap-e15-4 ciscoap 2013-03-31 14:07:14.416546+02 f 0 00:05:00 <removed> -322 127.0.0.1 ap-e33-1 ciscoap 2013-03-31 14:05:37.194794+02 f 0 00:05:00 <removed> -316 127.0.0.1 ap-e27-1 ciscoap 2013-03-31 14:07:18.075143+02 f 0 00:05:00 <removed> -317 127.0.0.1 ap-e27-2 ciscoap 2013-03-31 14:07:18.083421+02 f 0 00:05:00 <removed> -410 151.216.50.5 creativiasw04 dlink3100 2013-03-31 14:08:38.747626+02 f 0 00:01:00 <removed> -54 151.216.14.66 e37-2 dlink3100 2013-03-31 14:08:48.798532+02 f 0 00:01:00 <removed> -346 127.0.0.1 ap-e49-3 ciscoap 2013-03-31 14:07:18.116747+02 f 0 00:05:00 <removed> -16 151.216.4.194 e13-2 dlink3100 2013-03-31 14:08:59.398994+02 f 0 00:01:00 <removed> -132 151.216.127.4 stageboh stageboh 2013-03-31 14:11:19.519638+02 f 0 00:01:00 <removed> -353 127.0.0.1 ap-e53-2 ciscoap 2013-03-31 14:07:18.141775+02 f 0 00:05:00 <removed> -122 151.216.31.66 e73-4 dlink3100 2013-03-31 14:12:38.849023+02 t 0 00:01:00 <removed> -338 127.0.0.1 ap-e45-3 ciscoap 2013-03-31 14:07:18.175214+02 f 0 00:05:00 <removed> -327 127.0.0.1 ap-e37-2 ciscoap 2013-03-31 14:07:18.216828+02 f 0 00:05:00 <removed> -309 127.0.0.1 ap-e23-2 ciscoap 2013-03-31 14:07:24.68384+02 f 0 00:05:00 <removed> -330 127.0.0.1 ap-e41-1 ciscoap 2013-03-31 14:07:24.71716+02 f 0 00:05:00 <removed> -299 127.0.0.1 ap-e17-4 ciscoap 2013-03-31 14:07:24.733842+02 f 0 00:05:00 <removed> -379 127.0.0.1 ap-e65-4 ciscoap 2013-03-31 14:07:24.750498+02 f 0 00:05:00 <removed> -8 151.216.2.194 e7-4 dlink3100 2013-03-31 14:07:28.294572+02 f 0 00:01:00 <removed> -70 151.216.18.66 e47-4 dlink3100 2013-03-31 14:06:47.567226+02 f 0 00:01:00 <removed> -377 127.0.0.1 ap-e65-2 ciscoap 2013-03-31 14:07:28.367437+02 f 0 00:05:00 <removed> -60 151.216.15.194 e43-2 dlink3100 2013-03-31 14:06:57.634414+02 f 0 00:01:00 <removed> -292 127.0.0.1 ap-e15-1 ciscoap 2013-03-31 14:07:34.926035+02 f 0 00:05:00 <removed> -114 151.216.29.66 e69-4 dlink3100 2013-03-31 14:07:07.891609+02 f 0 00:01:00 <removed> -347 127.0.0.1 ap-e49-4 ciscoap 2013-03-31 14:07:34.959373+02 f 0 00:05:00 <removed> -116 151.216.29.194 e71-2 dlink3100 2013-03-31 14:07:38.453277+02 f 0 00:01:00 <removed> -411 151.216.50.6 creativiasw05 dlink3100 2013-03-31 14:07:17.968957+02 f 0 00:01:00 <removed> -87 151.216.22.130 e57-1 dlink3100 2013-03-31 14:07:48.503769+02 f 0 00:01:00 <removed> -113 151.216.29.2 e69-3 dlink3100 2013-03-31 14:07:58.545997+02 f 0 00:01:00 <removed> -287 127.0.0.1 ap-e11-4 ciscoap 2013-03-31 14:07:18.016788+02 f 0 00:05:00 <removed> -66 151.216.17.66 e45-4 dlink3100 2013-03-31 14:08:08.60963+02 f 0 00:01:00 <removed> -120 151.216.30.194 e73-2 dlink3100 2013-03-31 14:08:18.656104+02 f 0 00:01:00 <removed> -118 151.216.30.66 e71-4 dlink3100 2013-03-31 14:08:29.247615+02 f 0 00:01:00 <removed> -400 127.0.0.1 ap-e77-1 ciscoap 2013-03-31 14:07:34.859414+02 f 0 00:05:00 <removed> -139 151.216.127.16 eldregw eldregw 2013-03-31 14:12:28.253362+02 f 0 00:01:00 <removed> -76 151.216.19.194 e51-2 dlink3100 2013-03-31 14:12:38.382364+02 t 0 00:01:00 <removed> -405 127.0.0.1 ap-distro0 ciscoap 2013-03-31 14:07:34.876034+02 f 0 00:05:00 <removed> -359 127.0.0.1 ap-e55-4 ciscoap 2013-03-31 14:07:18.041795+02 f 0 00:05:00 <removed> -373 127.0.0.1 ap-e63-2 ciscoap 2013-03-31 14:07:18.050126+02 f 0 00:05:00 <removed> -354 127.0.0.1 ap-e53-3 ciscoap 2013-03-31 14:07:34.892675+02 f 0 00:05:00 <removed> -386 127.0.0.1 ap-e69-3 ciscoap 2013-03-31 14:07:18.108439+02 f 0 00:05:00 <removed> -326 127.0.0.1 ap-e37-1 ciscoap 2013-03-31 14:07:34.909368+02 f 0 00:05:00 <removed> -284 127.0.0.1 ap-e11-1 ciscoap 2013-03-31 14:07:34.942715+02 f 0 00:05:00 <removed> -391 127.0.0.1 ap-e71-4 ciscoap 2013-03-31 14:07:18.150127+02 f 0 00:05:00 <removed> -362 127.0.0.1 ap-e57-3 ciscoap 2013-03-31 14:07:34.976095+02 f 0 00:05:00 <removed> -318 127.0.0.1 ap-e29-1 ciscoap 2013-03-31 14:07:18.183518+02 f 0 00:05:00 <removed> -110 151.216.28.66 e67-4 dlink3100 2013-03-31 14:07:38.444965+02 f 0 00:01:00 <removed> -274 127.0.0.1 ap-e1-3 ciscoap 2013-03-31 14:07:18.208538+02 f 0 00:05:00 <removed> -53 151.216.14.2 e37-1 dlink3100 2013-03-31 14:07:48.49557+02 f 0 00:01:00 <removed> -107 151.216.27.130 e67-1 dlink3100 2013-03-31 14:07:58.554186+02 f 0 00:01:00 <removed> -315 127.0.0.1 ap-e25-4 ciscoap 2013-03-31 14:07:24.650503+02 f 0 00:05:00 <removed> -360 127.0.0.1 ap-e57-1 ciscoap 2013-03-31 14:07:24.667163+02 f 0 00:05:00 <removed> -78 151.216.20.66 e51-4 dlink3100 2013-03-31 14:08:09.146709+02 f 0 00:01:00 <removed> -414 151.216.50.9 creativiasw08 dlink3100 2013-03-31 14:06:47.558957+02 f 0 00:01:00 <removed> -294 127.0.0.1 ap-e15-3 ciscoap 2013-03-31 14:07:24.700488+02 f 0 00:05:00 <removed> -25 151.216.7.2 e17-3 dlink3100 2013-03-31 14:07:28.311147+02 f 0 00:01:00 <removed> -75 151.216.19.130 e51-1 dlink3100 2013-03-31 14:06:57.617774+02 f 0 00:01:00 <removed> -93 151.216.24.2 e59-3 dlink3100 2013-03-31 14:08:19.189476+02 f 0 00:01:00 <removed> -11 151.216.3.130 e11-1 dlink3100 2013-03-31 14:08:28.698108+02 f 0 00:01:00 <removed> -55 151.216.14.130 e39-1 dlink3100 2013-03-31 14:08:39.297705+02 f 0 00:01:00 <removed> -367 127.0.0.1 ap-e59-4 ciscoap 2013-03-31 14:07:28.334102+02 f 0 00:05:00 <removed> -80 151.216.20.194 e53-2 dlink3100 2013-03-31 14:07:07.875693+02 f 0 00:01:00 <removed> -321 127.0.0.1 ap-e31-2 ciscoap 2013-03-31 14:07:28.342401+02 f 0 00:05:00 <removed> -94 151.216.24.66 e59-4 dlink3100 2013-03-31 14:07:17.985368+02 f 0 00:01:00 <removed> -283 127.0.0.1 ap-e9-4 ciscoap 2013-03-31 14:07:28.375765+02 f 0 00:05:00 <removed> -48 151.216.12.194 e31-2 dlink3100 2013-03-31 14:08:49.348586+02 f 0 00:01:00 <removed> -68 151.216.17.194 e47-2 dlink3100 2013-03-31 14:08:58.847409+02 f 0 00:01:00 <removed> -331 127.0.0.1 ap-e41-2 ciscoap 2013-03-31 14:07:18.008451+02 f 0 00:05:00 <removed> -129 151.216.127.2 nocgw nocgw 2013-03-31 14:11:36.609335+02 f 0 00:01:00 <removed> -306 127.0.0.1 ap-e21-3 ciscoap 2013-03-31 14:07:28.400753+02 f 0 00:05:00 <removed> -313 127.0.0.1 ap-e25-2 ciscoap 2013-03-31 14:07:28.409069+02 f 0 00:05:00 <removed> -136 151.216.127.11 gamegw gamegw 2013-03-31 14:06:54.076054+02 f 0 00:01:00 <removed> -81 151.216.21.2 e53-3 dlink3100 2013-03-31 14:07:04.184831+02 f 0 00:01:00 <removed> -105 151.216.27.2 e65-3 dlink3100 2013-03-31 14:07:14.28811+02 f 0 00:01:00 <removed> -56 151.216.14.194 e39-2 dlink3100 2013-03-31 14:07:26.952794+02 f 0 00:01:00 <removed> -72 151.216.18.194 e49-2 dlink3100 2013-03-31 14:07:36.993533+02 f 0 00:01:00 <removed> -27 151.216.7.130 e19-1 dlink3100 2013-03-31 14:07:45.003682+02 f 0 00:01:00 <removed> -17 151.216.5.2 e13-3 dlink3100 2013-03-31 14:07:57.079313+02 f 0 00:01:00 <removed> -59 151.216.15.130 e43-1 dlink3100 2013-03-31 14:08:07.12975+02 f 0 00:01:00 <removed> -79 151.216.20.130 e53-1 dlink3100 2013-03-31 14:08:15.230508+02 f 0 00:01:00 <removed> -12 151.216.3.194 e11-2 dlink3100 2013-03-31 14:08:25.273211+02 f 0 00:01:00 <removed> -413 151.216.50.8 creativiasw07 dlink3100 2013-03-31 14:08:35.321636+02 f 0 00:01:00 <removed> -15 151.216.4.130 e13-1 dlink3100 2013-03-31 14:08:45.372088+02 f 0 00:01:00 <removed> -106 151.216.27.66 e65-4 dlink3100 2013-03-31 14:08:57.465785+02 f 0 00:01:00 <removed> -29 151.216.8.2 e19-3 dlink3100 2013-03-31 14:09:07.516177+02 f 0 00:01:00 <removed> -34 151.216.9.66 e21-4 dlink3100 2013-03-31 14:12:40.090712+02 t 0 00:01:00 <removed> -49 151.216.13.2 e33-1 dlink3100 2013-03-31 14:07:06.867675+02 f 0 00:01:00 <removed> -44 151.216.11.194 e27-2 dlink3100 2013-03-31 14:07:16.909469+02 f 0 00:01:00 <removed> -96 151.216.24.194 e61-2 dlink3100 2013-03-31 14:07:24.56102+02 f 0 00:01:00 <removed> -73 151.216.19.2 e49-3 dlink3100 2013-03-31 14:07:34.777763+02 f 0 00:01:00 <removed> -115 151.216.29.130 e71-1 dlink3100 2013-03-31 14:07:47.037305+02 f 0 00:01:00 <removed> -95 151.216.24.130 e61-1 dlink3100 2013-03-31 14:07:55.137659+02 f 0 00:01:00 <removed> -409 151.216.50.4 creativiasw03 dlink3100 2013-03-31 14:08:05.18812+02 f 0 00:01:00 <removed> -111 151.216.28.130 e69-1 dlink3100 2013-03-31 14:08:17.239454+02 f 0 00:01:00 <removed> -77 151.216.20.2 e51-3 dlink3100 2013-03-31 14:08:27.313458+02 f 0 00:01:00 <removed> -58 151.216.15.66 e41-2 dlink3100 2013-03-31 14:08:37.363767+02 f 0 00:01:00 <removed> -41 151.216.11.2 e25-3 dlink3100 2013-03-31 14:08:47.415311+02 f 0 00:01:00 <removed> -143 151.216.127.20 distro3 distro3 2013-03-31 14:08:55.423637+02 f 0 00:01:00 <removed> -\. - - --- --- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: nms --- - -SELECT pg_catalog.setval('switches_switch_seq', 417, true); - - --- --- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY switchtypes (switchtype, ports) FROM stdin; -dlink3100 1-44,46-48 -dlink3100full 1-48 -ciscoap -nocgw 1-114 -telegw 1-94,99-102 -camgw 1-52,55 -stageboh 1-52,55 -wtfgw 1-52,55 -logistikkgw 1-52,55 -crewgw 1-52,55 -gamegw 1-52,55 -resepsjongw 10101-10110 -sponsorgw -eldregw 1-5 -distro0 1-201 -distro1 1-201 -distro2 1-201 -distro3 1-201 -distro4 1-201 -\. - - --- --- Data for Name: temppoll; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY temppoll (id, "time", switch, temp) FROM stdin; -\. - - --- --- Data for Name: uplinks; Type: TABLE DATA; Schema: public; Owner: nms --- - -COPY uplinks (switch, coreswitch, blade, port) FROM stdin; -274 140 6 1 -275 140 6 2 -276 140 6 3 -277 140 6 4 -278 140 6 5 -279 140 6 6 -280 140 6 7 -281 140 6 8 -282 140 6 9 -283 140 6 10 -284 141 6 1 -285 141 6 2 -286 140 6 11 -287 140 6 12 -288 141 6 3 -289 141 6 4 -290 140 6 13 -291 140 6 14 -292 141 6 5 -293 141 6 6 -294 140 6 15 -295 140 6 16 -296 141 6 7 -297 141 6 8 -298 140 6 17 -299 140 6 18 -300 141 6 9 -301 141 6 10 -302 140 6 19 -303 140 6 20 -304 141 6 11 -305 141 6 12 -306 140 6 21 -307 140 6 22 -308 141 6 13 -309 141 6 14 -310 140 6 23 -311 140 6 24 -312 141 6 15 -313 141 6 16 -314 140 6 25 -315 140 6 26 -316 141 6 17 -317 141 6 18 -318 141 6 19 -319 141 6 20 -320 141 6 21 -321 141 6 22 -322 142 6 1 -323 141 6 23 -324 142 6 2 -325 142 6 3 -326 142 6 4 -327 142 6 5 -328 142 6 6 -329 142 6 7 -330 142 6 8 -331 142 6 9 -332 142 6 10 -333 142 6 11 -334 143 6 1 -335 143 6 2 -336 142 6 12 -337 142 6 13 -338 143 6 3 -339 143 6 4 -340 142 6 14 -341 142 6 15 -342 143 6 5 -343 143 6 6 -344 142 6 16 -345 142 6 17 -346 143 6 7 -347 143 6 8 -348 142 6 18 -349 142 6 19 -350 143 6 9 -351 143 6 10 -352 142 6 20 -353 142 6 21 -354 143 6 11 -355 143 6 12 -356 142 6 22 -357 142 6 23 -358 143 6 13 -359 143 6 14 -360 142 6 24 -361 142 6 25 -362 143 6 15 -363 143 6 16 -364 144 6 1 -365 144 6 2 -366 143 6 17 -367 143 6 18 -368 144 6 3 -369 144 6 4 -370 143 6 19 -371 143 6 20 -372 144 6 5 -373 144 6 6 -374 144 6 7 -375 144 6 8 -376 144 6 9 -377 144 6 10 -378 144 6 11 -379 144 6 12 -380 144 6 13 -381 144 6 14 -382 144 6 15 -383 144 6 16 -384 144 6 17 -385 144 6 18 -386 144 6 19 -387 144 6 20 -388 144 6 21 -389 144 6 22 -390 144 6 23 -391 144 6 24 -392 144 6 25 -393 144 6 26 -394 144 6 27 -395 144 6 28 -396 144 6 29 -397 144 6 30 -398 144 6 31 -399 144 6 32 -400 144 6 33 -401 144 6 34 -402 141 6 48 -403 142 6 47 -404 143 6 48 -405 140 6 48 -406 144 6 48 -\. +ALTER TABLE ONLY linknets ALTER COLUMN linknet SET DEFAULT nextval('linknets_linknet_seq'::regclass); -- @@ -1678,19 +658,11 @@ ALTER TABLE ONLY cpuloadpoll -- --- Name: ipv4_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: +-- Name: seen_mac_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- -ALTER TABLE ONLY ipv4 - ADD CONSTRAINT ipv4_pkey PRIMARY KEY (mac, address, "time"); - - --- --- Name: ipv6_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY ipv6 - ADD CONSTRAINT ipv6_pkey PRIMARY KEY (mac, address, "time"); +ALTER TABLE ONLY seen_mac + ADD CONSTRAINT seen_mac_pkey PRIMARY KEY (mac, address, seen); -- @@ -1724,6 +696,20 @@ CREATE INDEX polls_time ON polls USING btree ("time"); -- +-- Name: seen_mac_addr_family; Type: INDEX; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE INDEX seen_mac_addr_family ON seen_mac USING btree (family(address)); + + +-- +-- Name: seen_mac_seen; Type: INDEX; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE INDEX seen_mac_seen ON seen_mac USING btree (seen); + + +-- -- Name: switches_ap_poll; Type: INDEX; Schema: public; Owner: nms; Tablespace: -- @@ -1759,17 +745,24 @@ CREATE INDEX temppoll_search ON temppoll USING btree (switch, id); -- --- Name: time_idx; Type: INDEX; Schema: public; Owner: nms; Tablespace: +-- Name: updated_index; Type: INDEX; Schema: public; Owner: nms; Tablespace: -- -CREATE INDEX time_idx ON ipv6 USING btree ("time"); +CREATE INDEX updated_index ON ping USING btree (updated); -- --- Name: timev4_idx; Type: INDEX; Schema: public; Owner: nms; Tablespace: +-- Name: updated_index2; Type: INDEX; Schema: public; Owner: nms; Tablespace: -- -CREATE INDEX timev4_idx ON ipv4 USING btree ("time"); +CREATE INDEX updated_index2 ON linknet_ping USING btree (updated); + + +-- +-- Name: updated_index3; Type: INDEX; Schema: public; Owner: nms; Tablespace: +-- + +CREATE INDEX updated_index3 ON ping_secondary_ip USING btree (updated); -- @@ -1823,21 +816,13 @@ GRANT ALL ON SCHEMA public TO PUBLIC; -- --- Name: ipv4; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE ipv4 FROM PUBLIC; -REVOKE ALL ON TABLE ipv4 FROM nms; -GRANT ALL ON TABLE ipv4 TO nms; - - --- --- Name: ipv6; Type: ACL; Schema: public; Owner: nms +-- Name: dhcp; Type: ACL; Schema: public; Owner: nms -- -REVOKE ALL ON TABLE ipv6 FROM PUBLIC; -REVOKE ALL ON TABLE ipv6 FROM nms; -GRANT ALL ON TABLE ipv6 TO nms; +REVOKE ALL ON TABLE dhcp FROM PUBLIC; +REVOKE ALL ON TABLE dhcp FROM nms; +GRANT ALL ON TABLE dhcp TO nms; +GRANT ALL ON TABLE dhcp TO root; -- @@ -1860,104 +845,46 @@ GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mldpolls TO nms; -- --- PostgreSQL database dump complete +-- Name: placements; Type: ACL; Schema: public; Owner: nms -- -\connect postgres +REVOKE ALL ON TABLE placements FROM PUBLIC; +REVOKE ALL ON TABLE placements FROM nms; +GRANT ALL ON TABLE placements TO nms; +GRANT ALL ON TABLE placements TO root; --- --- PostgreSQL database dump --- - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = on; -SET check_function_bodies = false; -SET client_min_messages = warning; -- --- Name: postgres; Type: COMMENT; Schema: -; Owner: postgres +-- Name: seen_mac; Type: ACL; Schema: public; Owner: postgres -- -COMMENT ON DATABASE postgres IS 'default administrative connection database'; +REVOKE ALL ON TABLE seen_mac FROM PUBLIC; +REVOKE ALL ON TABLE seen_mac FROM postgres; +GRANT ALL ON TABLE seen_mac TO postgres; +GRANT SELECT,INSERT ON TABLE seen_mac TO nms; -- --- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: +-- Name: squeue; Type: ACL; Schema: public; Owner: nms -- -CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; +REVOKE ALL ON TABLE squeue FROM PUBLIC; +REVOKE ALL ON TABLE squeue FROM nms; +GRANT ALL ON TABLE squeue TO nms; +GRANT ALL ON TABLE squeue TO root; -- --- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: +-- Name: switches; Type: ACL; Schema: public; Owner: nms -- -COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; - - --- --- Name: public; Type: ACL; Schema: -; Owner: postgres --- - -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM postgres; -GRANT ALL ON SCHEMA public TO postgres; -GRANT ALL ON SCHEMA public TO PUBLIC; +REVOKE ALL ON TABLE switches FROM PUBLIC; +REVOKE ALL ON TABLE switches FROM nms; +GRANT ALL ON TABLE switches TO nms; +GRANT ALL ON TABLE switches TO root; -- -- PostgreSQL database dump complete -- -\connect template1 - --- --- PostgreSQL database dump --- - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = on; -SET check_function_bodies = false; -SET client_min_messages = warning; - --- --- Name: template1; Type: COMMENT; Schema: -; Owner: postgres --- - -COMMENT ON DATABASE template1 IS 'default template for new databases'; - - --- --- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: --- - -CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; - - --- --- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: --- - -COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; - - --- --- Name: public; Type: ACL; Schema: -; Owner: postgres --- - -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM postgres; -GRANT ALL ON SCHEMA public TO postgres; -GRANT ALL ON SCHEMA public TO PUBLIC; - - --- --- PostgreSQL database dump complete --- - --- --- PostgreSQL database cluster dump complete --- - |