2 -- PostgreSQL database dump
5 SET client_encoding = 'SQL_ASCII';
6 SET check_function_bodies = false;
7 SET client_min_messages = warning;
10 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
13 COMMENT ON SCHEMA public IS 'Standard public schema';
17 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner:
20 CREATE PROCEDURAL LANGUAGE plpgsql;
23 SET search_path = public, pg_catalog;
26 -- Name: datarate; Type: TYPE; Schema: public; Owner: sesse
29 CREATE TYPE datarate AS (
32 bytes_in double precision,
33 bytes_out double precision
37 ALTER TYPE public.datarate OWNER TO sesse;
40 -- Name: get_current_datarate(); Type: FUNCTION; Schema: public; Owner: nms
43 CREATE FUNCTION get_current_datarate() RETURNS SETOF datarate
54 last_poll.switch := -1;
56 FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP
57 IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN
58 IF num_entries >= 2 THEN
59 timediff := EXTRACT(epoch from last_poll.time - first_poll.time);
60 ret.switch := last_poll.switch;
61 ret.port := last_poll.port;
63 IF last_poll.bytes_in >= first_poll.bytes_in AND last_poll.bytes_out >= first_poll.bytes_out THEN
64 ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff;
65 ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff;
71 -- reset if we have wraparound
72 IF last_poll.bytes_in < first_poll.bytes_in OR
73 last_poll.bytes_out < first_poll.bytes_out THEN
78 num_entries := num_entries + 1;
79 IF num_entries = 1 THEN
80 first_poll.switch := poll.switch;
81 first_poll.port := poll.port;
82 first_poll.time := poll.time;
83 first_poll.bytes_in := poll.bytes_in;
84 first_poll.bytes_out := poll.bytes_out;
87 last_poll.switch := poll.switch;
88 last_poll.port := poll.port;
89 last_poll.time := poll.time;
90 last_poll.bytes_in := poll.bytes_in;
91 last_poll.bytes_out := poll.bytes_out;
95 IF num_entries >= 2 THEN
96 timediff := EXTRACT(epoch from last_poll.time - first_poll.time);
97 ret.switch := last_poll.switch;
98 ret.port := last_poll.port;
100 IF last_poll.bytes_in >= first_poll.bytes_in AND
101 last_poll.bytes_out >= first_poll.bytes_out THEN
102 ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff;
103 ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff;
114 ALTER FUNCTION public.get_current_datarate() OWNER TO nms;
117 -- Name: get_datarate(); Type: FUNCTION; Schema: public; Owner: postgres
120 CREATE FUNCTION get_datarate() RETURNS SETOF datarate
125 second_last_poll polls;
131 last_poll.switch = -1;
133 FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP
134 IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN
135 IF num_entries >= 2 THEN
136 timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time);
137 ret.switch := last_poll.switch;
138 ret.port := last_poll.port;
140 IF last_poll.bytes_in < second_last_poll.bytes_in THEN
141 second_last_poll.bytes_in = 0;
143 IF last_poll.bytes_out < second_last_poll.bytes_out THEN
144 second_last_poll.bytes_out = 0;
147 ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff;
148 ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff;
150 ELSIF num_entries = 1 THEN
151 ret.switch := last_poll.switch;
152 ret.port := last_poll.port;
159 num_entries := num_entries + 1;
161 second_last_poll.switch := last_poll.switch;
162 second_last_poll.port := last_poll.port;
163 second_last_poll.time := last_poll.time;
164 second_last_poll.bytes_in := last_poll.bytes_in;
165 second_last_poll.bytes_out := last_poll.bytes_out;
166 last_poll.switch := poll.switch;
167 last_poll.port := poll.port;
168 last_poll.time := poll.time;
169 last_poll.bytes_in := poll.bytes_in;
170 last_poll.bytes_out := poll.bytes_out;
172 -- pah, and once more, for the last switch/port...
173 IF num_entries >= 2 THEN
174 timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time);
175 ret.switch := last_poll.switch;
176 ret.port := last_poll.port;
178 IF last_poll.bytes_in < second_last_poll.bytes_in THEN
179 second_last_poll.bytes_in = 0;
181 IF last_poll.bytes_out < second_last_poll.bytes_out THEN
182 second_last_poll.bytes_out = 0;
185 ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff;
186 ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff;
188 ELSIF num_entries = 1 THEN
189 ret.switch := last_poll.switch;
190 ret.port := last_poll.port;
202 ALTER FUNCTION public.get_datarate() OWNER TO postgres;
205 -- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
208 CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
209 AS '$libdir/plpgsql', 'plpgsql_call_handler'
213 ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres;
215 SET default_tablespace = '';
217 SET default_with_oids = false;
220 -- Name: cpuloadpoll; Type: TABLE; Schema: public; Owner: sesse; Tablespace:
223 CREATE TABLE cpuloadpoll (
225 "time" timestamp without time zone NOT NULL,
226 switch integer NOT NULL,
227 entity integer NOT NULL,
228 value integer NOT NULL
232 ALTER TABLE public.cpuloadpoll OWNER TO sesse;
235 -- Name: cpuloadpoll_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sesse
241 -- Name: dhcp; Type: TABLE; Schema: public; Owner: sesse; Tablespace:
245 switch integer NOT NULL,
246 network cidr NOT NULL,
247 last_ack timestamp without time zone
251 ALTER TABLE public.dhcp OWNER TO sesse;
254 -- Name: placements; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
257 CREATE TABLE placements (
258 switch integer NOT NULL,
259 placement box NOT NULL
263 ALTER TABLE public.placements OWNER TO postgres;
266 -- Name: polls; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
270 "time" timestamp with time zone NOT NULL,
271 switch integer NOT NULL,
272 port integer NOT NULL,
273 bytes_in bigint NOT NULL,
274 bytes_out bigint NOT NULL,
275 errors_in bigint NOT NULL,
276 errors_out bigint NOT NULL
278 ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;
281 ALTER TABLE public.polls OWNER TO postgres;
284 -- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres
287 CREATE SEQUENCE polls_poll_seq
295 ALTER TABLE public.polls_poll_seq OWNER TO postgres;
298 -- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
301 SELECT pg_catalog.setval('polls_poll_seq', 1, false);
304 SET default_with_oids = true;
307 -- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
310 CREATE TABLE portnames (
311 switchtype character varying NOT NULL,
312 port integer NOT NULL,
313 description character varying NOT NULL
317 ALTER TABLE public.portnames OWNER TO postgres;
320 -- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace:
323 CREATE TABLE squeue (
324 id integer DEFAULT nextval(('squeue_sequence'::text)::regclass) NOT NULL,
325 gid integer NOT NULL,
326 added timestamp with time zone NOT NULL,
327 updated timestamp with time zone,
329 cmd character varying NOT NULL,
330 locked boolean DEFAULT false NOT NULL,
331 processed boolean DEFAULT false NOT NULL,
332 disabled boolean DEFAULT false NOT NULL,
333 priority integer DEFAULT 3,
334 sysname character varying NOT NULL,
335 author character varying NOT NULL,
336 result character varying,
337 delay timestamp with time zone,
338 delaytime interval DEFAULT '00:01:00'::interval
342 ALTER TABLE public.squeue OWNER TO nms;
345 -- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms
348 CREATE SEQUENCE squeue_group_sequence
355 ALTER TABLE public.squeue_group_sequence OWNER TO nms;
358 -- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
364 -- Name: squeue_sequence; Type: SEQUENCE; Schema: public; Owner: nms
367 CREATE SEQUENCE squeue_sequence
374 ALTER TABLE public.squeue_sequence OWNER TO nms;
377 -- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
380 SELECT pg_catalog.setval('squeue_sequence', 901, true);
384 -- Name: stemppoll_sequence; Type: SEQUENCE; Schema: public; Owner: nms
387 CREATE SEQUENCE stemppoll_sequence
394 ALTER TABLE public.stemppoll_sequence OWNER TO nms;
397 -- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
400 SELECT pg_catalog.setval('stemppoll_sequence', 182534, true);
403 SET default_with_oids = false;
406 -- Name: switches; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
409 CREATE TABLE switches (
410 switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL,
412 sysname character varying NOT NULL,
413 switchtype character varying NOT NULL,
414 last_updated timestamp with time zone,
415 locked boolean DEFAULT false NOT NULL,
416 priority integer DEFAULT 0 NOT NULL,
417 poll_frequency interval DEFAULT '00:05:00'::interval NOT NULL,
418 community character varying DEFAULT 'public'::character varying NOT NULL
422 ALTER TABLE public.switches OWNER TO postgres;
425 -- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: postgres
428 CREATE SEQUENCE switches_switch_seq
435 ALTER TABLE public.switches_switch_seq OWNER TO postgres;
438 -- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
441 SELECT pg_catalog.setval('switches_switch_seq', 225, true);
445 -- Name: switchtypes; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
448 CREATE TABLE switchtypes (
449 switchtype character varying NOT NULL,
450 ports character varying NOT NULL,
451 wide_counters boolean DEFAULT false NOT NULL
455 ALTER TABLE public.switchtypes OWNER TO postgres;
457 SET default_with_oids = true;
460 -- Name: temppoll; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
463 CREATE TABLE temppoll (
464 id integer DEFAULT nextval(('stemppoll_sequence'::text)::regclass) NOT NULL,
465 "time" timestamp without time zone NOT NULL,
466 switch integer NOT NULL,
467 "temp" double precision
471 ALTER TABLE public.temppoll OWNER TO postgres;
475 -- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres
478 COPY portnames (switchtype, port, description) FROM stdin;
479 blackdiamond 1001 BD6808/G8Xi-Port 1:1
480 blackdiamond 1002 BD6808/G8Xi-Port 1:2
481 blackdiamond 1003 BD6808/G8Xi-Port 1:3
482 blackdiamond 1004 BD6808/G8Xi-Port 1:4
483 blackdiamond 1005 BD6808/G8Xi-Port 1:5
484 blackdiamond 1006 BD6808/G8Xi-Port 1:6
485 blackdiamond 1007 BD6808/G8Xi-Port 1:7
486 blackdiamond 4001 BD6808/G16X3-Port 4:1
487 blackdiamond 4002 BD6808/G16X3-Port 4:2
488 blackdiamond 4003 BD6808/G16X3-Port 4:3
489 blackdiamond 4004 BD6808/G16X3-Port 4:4
490 blackdiamond 4005 BD6808/G16X3-Port 4:5
491 blackdiamond 4006 BD6808/G16X3-Port 4:6
492 blackdiamond 4007 BD6808/G16X3-Port 4:7
493 blackdiamond 4008 BD6808/G16X3-Port 4:8
494 blackdiamond 4009 BD6808/G16X3-Port 4:9
495 blackdiamond 4010 BD6808/G16X3-Port 4:10
496 blackdiamond 4011 BD6808/G16X3-Port 4:11
497 blackdiamond 4012 BD6808/G16X3-Port 4:12
498 blackdiamond 4013 BD6808/G16X3-Port 4:13
499 blackdiamond 4014 BD6808/G16X3-Port 4:14
500 blackdiamond 4015 BD6808/G16X3-Port 4:15
501 blackdiamond 4016 BD6808/G16X3-Port 4:16
502 blackdiamond 5001 BD6808/G24T3-Port 5:1
503 blackdiamond 5002 BD6808/G24T3-Port 5:2
504 blackdiamond 5003 BD6808/G24T3-Port 5:3
505 blackdiamond 5004 BD6808/G24T3-Port 5:4
506 blackdiamond 5005 BD6808/G24T3-Port 5:5
507 blackdiamond 5006 BD6808/G24T3-Port 5:6
508 blackdiamond 5007 BD6808/G24T3-Port 5:7
509 blackdiamond 5008 BD6808/G24T3-Port 5:8
510 blackdiamond 5009 BD6808/G24T3-Port 5:9
511 blackdiamond 5010 BD6808/G24T3-Port 5:10
512 blackdiamond 5011 BD6808/G24T3-Port 5:11
513 blackdiamond 5012 BD6808/G24T3-Port 5:12
514 blackdiamond 5013 BD6808/G24T3-Port 5:13
515 blackdiamond 5014 BD6808/G24T3-Port 5:14
516 blackdiamond 5015 BD6808/G24T3-Port 5:15
517 blackdiamond 5016 BD6808/G24T3-Port 5:16
518 blackdiamond 5017 BD6808/G24T3-Port 5:17
519 blackdiamond 5018 BD6808/G24T3-Port 5:18
520 blackdiamond 5019 BD6808/G24T3-Port 5:19
521 blackdiamond 5020 BD6808/G24T3-Port 5:20
522 blackdiamond 5021 BD6808/G24T3-Port 5:21
523 blackdiamond 5022 BD6808/G24T3-Port 5:22
524 blackdiamond 5023 BD6808/G24T3-Port 5:23
525 blackdiamond 5024 BD6808/G24T3-Port 5:24
526 blackdiamond 6001 BD6808/F48Ti-Port 6:1
527 blackdiamond 6002 BD6808/F48Ti-Port 6:2
528 blackdiamond 6003 BD6808/F48Ti-Port 6:3
529 blackdiamond 6004 BD6808/F48Ti-Port 6:4
530 blackdiamond 6005 BD6808/F48Ti-Port 6:5
531 blackdiamond 6006 BD6808/F48Ti-Port 6:6
532 blackdiamond 6007 BD6808/F48Ti-Port 6:7
533 blackdiamond 6008 BD6808/F48Ti-Port 6:8
534 blackdiamond 6009 BD6808/F48Ti-Port 6:9
535 blackdiamond 6010 BD6808/F48Ti-Port 6:10
536 blackdiamond 6011 BD6808/F48Ti-Port 6:11
537 blackdiamond 6012 BD6808/F48Ti-Port 6:12
538 blackdiamond 6013 BD6808/F48Ti-Port 6:13
539 blackdiamond 6014 BD6808/F48Ti-Port 6:14
540 blackdiamond 6015 BD6808/F48Ti-Port 6:15
541 blackdiamond 6016 BD6808/F48Ti-Port 6:16
542 blackdiamond 6017 BD6808/F48Ti-Port 6:17
543 blackdiamond 6018 BD6808/F48Ti-Port 6:18
544 blackdiamond 6019 BD6808/F48Ti-Port 6:19
545 blackdiamond 6020 BD6808/F48Ti-Port 6:20
546 blackdiamond 6021 BD6808/F48Ti-Port 6:21
547 blackdiamond 6022 BD6808/F48Ti-Port 6:22
548 blackdiamond 6023 BD6808/F48Ti-Port 6:23
549 blackdiamond 6024 BD6808/F48Ti-Port 6:24
550 blackdiamond 6025 BD6808/F48Ti-Port 6:25
551 blackdiamond 6026 BD6808/F48Ti-Port 6:26
552 blackdiamond 6027 BD6808/F48Ti-Port 6:27
553 blackdiamond 6028 BD6808/F48Ti-Port 6:28
554 blackdiamond 6029 BD6808/F48Ti-Port 6:29
555 blackdiamond 6030 BD6808/F48Ti-Port 6:30
556 blackdiamond 6031 BD6808/F48Ti-Port 6:31
557 blackdiamond 6032 BD6808/F48Ti-Port 6:32
558 blackdiamond 6033 BD6808/F48Ti-Port 6:33
559 blackdiamond 6034 BD6808/F48Ti-Port 6:34
560 blackdiamond 6035 BD6808/F48Ti-Port 6:35
561 blackdiamond 6036 BD6808/F48Ti-Port 6:36
562 blackdiamond 6037 BD6808/F48Ti-Port 6:37
563 blackdiamond 6038 BD6808/F48Ti-Port 6:38
564 blackdiamond 6039 BD6808/F48Ti-Port 6:39
565 blackdiamond 6040 BD6808/F48Ti-Port 6:40
566 blackdiamond 6041 BD6808/F48Ti-Port 6:41
567 blackdiamond 6042 BD6808/F48Ti-Port 6:42
568 blackdiamond 6043 BD6808/F48Ti-Port 6:43
569 blackdiamond 6044 BD6808/F48Ti-Port 6:44
570 blackdiamond 6045 BD6808/F48Ti-Port 6:45
571 blackdiamond 6046 BD6808/F48Ti-Port 6:46
572 blackdiamond 6047 BD6808/F48Ti-Port 6:47
573 blackdiamond 6048 BD6808/F48Ti-Port 6:48
574 cisco6509 1 GigabitEthernet1/1
575 cisco6509 2 GigabitEthernet1/2
576 cisco6509 3 GigabitEthernet1/3
577 cisco6509 4 GigabitEthernet1/4
578 cisco6509 5 GigabitEthernet1/5
579 cisco6509 6 GigabitEthernet1/6
580 cisco6509 7 GigabitEthernet1/7
581 cisco6509 8 GigabitEthernet1/8
582 cisco6509 9 GigabitEthernet1/9
583 cisco6509 10 GigabitEthernet1/10
584 cisco6509 11 GigabitEthernet1/11
585 cisco6509 12 GigabitEthernet1/12
586 cisco6509 13 GigabitEthernet1/13
587 cisco6509 14 GigabitEthernet1/14
588 cisco6509 15 GigabitEthernet1/15
589 cisco6509 16 GigabitEthernet1/16
590 cisco6509 17 GigabitEthernet1/17
591 cisco6509 18 GigabitEthernet1/18
592 cisco6509 19 GigabitEthernet1/19
593 cisco6509 20 GigabitEthernet1/20
594 cisco6509 21 GigabitEthernet1/21
595 cisco6509 22 GigabitEthernet1/22
596 cisco6509 23 GigabitEthernet1/23
597 cisco6509 24 GigabitEthernet1/24
598 cisco6509 25 GigabitEthernet1/25
599 cisco6509 26 GigabitEthernet1/26
600 cisco6509 27 GigabitEthernet1/27
601 cisco6509 28 GigabitEthernet1/28
602 cisco6509 29 GigabitEthernet1/29
603 cisco6509 30 GigabitEthernet1/30
604 cisco6509 31 GigabitEthernet1/31
605 cisco6509 32 GigabitEthernet1/32
606 cisco6509 33 GigabitEthernet1/33
607 cisco6509 34 GigabitEthernet1/34
608 cisco6509 35 GigabitEthernet1/35
609 cisco6509 36 GigabitEthernet1/36
610 cisco6509 37 GigabitEthernet1/37
611 cisco6509 38 GigabitEthernet1/38
612 cisco6509 39 GigabitEthernet1/39
613 cisco6509 40 GigabitEthernet1/40
614 cisco6509 41 GigabitEthernet1/41
615 cisco6509 42 GigabitEthernet1/42
616 cisco6509 43 GigabitEthernet1/43
617 cisco6509 44 GigabitEthernet1/44
618 cisco6509 45 GigabitEthernet1/45
619 cisco6509 46 GigabitEthernet1/46
620 cisco6509 47 GigabitEthernet1/47
621 cisco6509 48 GigabitEthernet1/48
622 cisco6509 49 GigabitEthernet2/1
623 cisco6509 50 GigabitEthernet2/2
624 cisco6509 51 GigabitEthernet2/3
625 cisco6509 52 GigabitEthernet2/4
626 cisco6509 53 GigabitEthernet2/5
627 cisco6509 54 GigabitEthernet2/6
628 cisco6509 55 GigabitEthernet2/7
629 cisco6509 56 GigabitEthernet2/8
630 cisco6509 57 GigabitEthernet2/9
631 cisco6509 58 GigabitEthernet2/10
632 cisco6509 59 GigabitEthernet2/11
633 cisco6509 60 GigabitEthernet2/12
634 cisco6509 61 GigabitEthernet2/13
635 cisco6509 62 GigabitEthernet2/14
636 cisco6509 63 GigabitEthernet2/15
637 cisco6509 64 GigabitEthernet2/16
638 cisco6509 65 FastEthernet4/1
639 cisco6509 66 FastEthernet4/2
640 cisco6509 67 FastEthernet4/3
641 cisco6509 68 FastEthernet4/4
642 cisco6509 69 FastEthernet4/5
643 cisco6509 70 FastEthernet4/6
644 cisco6509 71 FastEthernet4/7
645 cisco6509 72 FastEthernet4/8
646 cisco6509 73 FastEthernet4/9
647 cisco6509 74 FastEthernet4/10
648 cisco6509 75 FastEthernet4/11
649 cisco6509 76 FastEthernet4/12
650 cisco6509 77 FastEthernet4/13
651 cisco6509 78 FastEthernet4/14
652 cisco6509 79 FastEthernet4/15
653 cisco6509 80 FastEthernet4/16
654 cisco6509 81 FastEthernet4/17
655 cisco6509 82 FastEthernet4/18
656 cisco6509 83 FastEthernet4/19
657 cisco6509 84 FastEthernet4/20
658 cisco6509 85 FastEthernet4/21
659 cisco6509 86 FastEthernet4/22
660 cisco6509 87 FastEthernet4/23
661 cisco6509 88 FastEthernet4/24
662 cisco6509 89 FastEthernet4/25
663 cisco6509 90 FastEthernet4/26
664 cisco6509 91 FastEthernet4/27
665 cisco6509 92 FastEthernet4/28
666 cisco6509 93 FastEthernet4/29
667 cisco6509 94 FastEthernet4/30
668 cisco6509 95 FastEthernet4/31
669 cisco6509 96 FastEthernet4/32
670 cisco6509 97 FastEthernet4/33
671 cisco6509 98 FastEthernet4/34
672 cisco6509 99 FastEthernet4/35
673 cisco6509 100 FastEthernet4/36
674 cisco6509 101 FastEthernet4/37
675 cisco6509 102 FastEthernet4/38
676 cisco6509 103 FastEthernet4/39
677 cisco6509 104 FastEthernet4/40
678 cisco6509 105 FastEthernet4/41
679 cisco6509 106 FastEthernet4/42
680 cisco6509 107 FastEthernet4/43
681 cisco6509 108 FastEthernet4/44
682 cisco6509 109 FastEthernet4/45
683 cisco6509 110 FastEthernet4/46
684 cisco6509 111 FastEthernet4/47
685 cisco6509 112 FastEthernet4/48
686 cisco6509 113 GigabitEthernet5/1
687 cisco6509 114 GigabitEthernet5/2
688 cisco6509 115 GigabitEthernet8/1
689 cisco6509 116 GigabitEthernet8/2
690 cisco6509 117 GigabitEthernet8/3
691 cisco6509 118 GigabitEthernet8/4
692 cisco6509 119 GigabitEthernet8/5
693 cisco6509 120 GigabitEthernet8/6
694 cisco6509 121 GigabitEthernet8/7
695 cisco6509 122 GigabitEthernet8/8
696 cisco6509 123 GigabitEthernet8/9
701 -- Data for Name: squeue; Type: TABLE DATA; Schema: public; Owner: nms
704 COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin;
709 COPY switchtypes (switchtype, ports, wide_counters) FROM stdin;
710 blackdiamond 1001-1007,4001-4016,5001-5024,6001-6048 f
721 -- Data for Name: temppoll; Type: TABLE DATA; Schema: public; Owner: postgres
724 COPY temppoll (id, "time", switch, "temp") FROM stdin;
729 -- Name: cpuloadpoll_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace:
732 ALTER TABLE ONLY cpuloadpoll
733 ADD CONSTRAINT cpuloadpoll_pkey PRIMARY KEY (id);
737 -- Name: public; Type: ACL; Schema: -; Owner: postgres
740 REVOKE ALL ON SCHEMA public FROM PUBLIC;
741 REVOKE ALL ON SCHEMA public FROM postgres;
742 GRANT ALL ON SCHEMA public TO postgres;
743 GRANT ALL ON SCHEMA public TO PUBLIC;
747 -- Name: cpuloadpoll; Type: ACL; Schema: public; Owner: sesse
750 REVOKE ALL ON TABLE cpuloadpoll FROM PUBLIC;
751 REVOKE ALL ON TABLE cpuloadpoll FROM sesse;
752 GRANT ALL ON TABLE cpuloadpoll TO sesse;
753 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll TO nms;
757 -- Name: cpuloadpoll_id_seq; Type: ACL; Schema: public; Owner: sesse
760 REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM PUBLIC;
761 REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM sesse;
762 GRANT ALL ON TABLE cpuloadpoll_id_seq TO sesse;
763 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll_id_seq TO nms;
767 -- Name: polls; Type: ACL; Schema: public; Owner: postgres
770 REVOKE ALL ON TABLE polls FROM PUBLIC;
771 REVOKE ALL ON TABLE polls FROM postgres;
772 GRANT ALL ON TABLE polls TO postgres;
773 GRANT INSERT ON TABLE polls TO nms;
777 -- Name: switches; Type: ACL; Schema: public; Owner: postgres
780 REVOKE ALL ON TABLE switches FROM PUBLIC;
781 REVOKE ALL ON TABLE switches FROM postgres;
782 GRANT ALL ON TABLE switches TO postgres;
783 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE switches TO nms;
787 -- Name: switchtypes; Type: ACL; Schema: public; Owner: postgres
790 REVOKE ALL ON TABLE switchtypes FROM PUBLIC;
791 REVOKE ALL ON TABLE switchtypes FROM postgres;
792 GRANT ALL ON TABLE switchtypes TO postgres;
793 GRANT SELECT ON TABLE switchtypes TO nms;
797 -- PostgreSQL database dump complete