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
238 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('cpuloadpoll', 'id'), 12, true);
242 -- Name: dhcp; Type: TABLE; Schema: public; Owner: sesse; Tablespace:
246 switch integer NOT NULL,
247 network cidr NOT NULL,
248 last_ack timestamp without time zone
252 ALTER TABLE public.dhcp OWNER TO sesse;
255 -- Name: placements; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
258 CREATE TABLE placements (
259 switch integer NOT NULL,
260 placement box NOT NULL
264 ALTER TABLE public.placements OWNER TO postgres;
267 -- Name: polls; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
271 "time" timestamp with time zone NOT NULL,
272 switch integer NOT NULL,
273 port integer NOT NULL,
274 bytes_in bigint NOT NULL,
275 bytes_out bigint NOT NULL,
276 errors_in bigint NOT NULL,
277 errors_out bigint NOT NULL
279 ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;
282 ALTER TABLE public.polls OWNER TO postgres;
285 -- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres
288 CREATE SEQUENCE polls_poll_seq
296 ALTER TABLE public.polls_poll_seq OWNER TO postgres;
299 -- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
302 SELECT pg_catalog.setval('polls_poll_seq', 1, false);
305 SET default_with_oids = true;
308 -- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
311 CREATE TABLE portnames (
312 switchtype character varying NOT NULL,
313 port integer NOT NULL,
314 description character varying NOT NULL
318 ALTER TABLE public.portnames OWNER TO postgres;
321 -- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace:
324 CREATE TABLE squeue (
325 id integer DEFAULT nextval(('squeue_sequence'::text)::regclass) NOT NULL,
326 gid integer NOT NULL,
327 added timestamp with time zone NOT NULL,
328 updated timestamp with time zone,
330 cmd character varying NOT NULL,
331 locked boolean DEFAULT false NOT NULL,
332 processed boolean DEFAULT false NOT NULL,
333 disabled boolean DEFAULT false NOT NULL,
334 priority integer DEFAULT 3,
335 sysname character varying NOT NULL,
336 author character varying NOT NULL,
337 result character varying,
338 delay timestamp with time zone,
339 delaytime interval DEFAULT '00:01:00'::interval
343 ALTER TABLE public.squeue OWNER TO nms;
346 -- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms
349 CREATE SEQUENCE squeue_group_sequence
356 ALTER TABLE public.squeue_group_sequence OWNER TO nms;
359 -- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
362 SELECT pg_catalog.setval('squeue_group_sequence', 21, true);
366 -- Name: squeue_sequence; Type: SEQUENCE; Schema: public; Owner: nms
369 CREATE SEQUENCE squeue_sequence
376 ALTER TABLE public.squeue_sequence OWNER TO nms;
379 -- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
382 SELECT pg_catalog.setval('squeue_sequence', 901, true);
386 -- Name: stemppoll_sequence; Type: SEQUENCE; Schema: public; Owner: nms
389 CREATE SEQUENCE stemppoll_sequence
396 ALTER TABLE public.stemppoll_sequence OWNER TO nms;
399 -- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
402 SELECT pg_catalog.setval('stemppoll_sequence', 182534, true);
405 SET default_with_oids = false;
408 -- Name: switches; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
411 CREATE TABLE switches (
412 switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL,
414 sysname character varying NOT NULL,
415 switchtype character varying NOT NULL,
416 last_updated timestamp with time zone,
417 locked boolean DEFAULT false NOT NULL,
418 priority integer DEFAULT 0 NOT NULL,
419 poll_frequency interval DEFAULT '00:05:00'::interval NOT NULL,
420 community character varying DEFAULT 'public'::character varying NOT NULL
424 ALTER TABLE public.switches OWNER TO postgres;
427 -- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: postgres
430 CREATE SEQUENCE switches_switch_seq
437 ALTER TABLE public.switches_switch_seq OWNER TO postgres;
440 -- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
443 SELECT pg_catalog.setval('switches_switch_seq', 225, true);
447 -- Name: switchtypes; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
450 CREATE TABLE switchtypes (
451 switchtype character varying NOT NULL,
452 ports character varying NOT NULL,
453 wide_counters boolean DEFAULT false NOT NULL
457 ALTER TABLE public.switchtypes OWNER TO postgres;
459 SET default_with_oids = true;
462 -- Name: temppoll; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
465 CREATE TABLE temppoll (
466 id integer DEFAULT nextval(('stemppoll_sequence'::text)::regclass) NOT NULL,
467 "time" timestamp without time zone NOT NULL,
468 switch integer NOT NULL,
469 "temp" double precision
473 ALTER TABLE public.temppoll OWNER TO postgres;
476 -- Data for Name: cpuloadpoll; Type: TABLE DATA; Schema: public; Owner: sesse
479 COPY cpuloadpoll (id, "time", switch, entity, value) FROM stdin;
480 5 2006-03-28 23:16:18.950263 1 5017 1
481 6 2006-03-28 23:16:18.970211 1 5001 3
482 7 2006-03-28 23:16:18.999445 1 2007 76
483 8 2006-03-28 23:16:19.018999 1 1056 3
484 9 2006-03-29 14:21:07.052914 1 5017 0
485 10 2006-03-29 14:21:07.07474 1 5001 4
486 11 2006-03-29 14:21:07.104667 1 2007 69
487 12 2006-03-29 14:21:07.125 1 1056 3
492 -- Data for Name: dhcp; Type: TABLE DATA; Schema: public; Owner: sesse
495 COPY dhcp (switch, network, last_ack) FROM stdin;
496 151 81.162.53.0/26 2005-03-27 11:53:29
497 41 81.162.16.64/26 2005-03-27 11:53:35
498 164 81.162.57.64/26 2005-03-27 11:53:39
499 20 81.162.9.64/26 2005-03-27 11:54:27
500 4 81.162.4.0/26 2005-03-27 11:55:33
501 44 81.162.17.64/26 2005-03-27 11:56:37
502 194 81.162.67.64/26 2005-03-27 11:56:38
503 139 81.162.49.0/26 2005-03-27 11:57:08
504 46 81.162.18.0/26 2005-03-27 11:57:27
505 193 81.162.67.0/26 2005-03-27 11:57:36
506 27 81.162.11.128/26 2005-03-27 11:58:07
507 107 81.162.38.64/26 2005-03-27 11:58:31
508 133 81.162.47.0/26 2005-03-27 11:58:52
509 99 81.162.35.128/26 2005-03-27 11:59:09
510 79 81.162.29.0/26 2005-03-27 11:59:18
511 34 81.162.14.0/26 2005-03-27 11:59:28
512 51 81.162.19.128/26 2005-03-27 11:59:34
513 160 81.162.56.0/26 2005-03-27 12:00:01
514 196 81.162.68.0/26 2005-03-27 12:00:11
515 184 81.162.64.0/26 2005-03-27 12:01:48
516 9 81.162.5.128/26 2005-03-27 12:01:54
517 195 81.162.67.128/26 2005-03-27 12:02:18
518 123 81.162.43.128/26 2005-03-27 12:02:46
519 192 81.162.66.128/26 2005-03-27 12:03:09
520 212 81.162.203.0/24 2005-03-27 12:04:12
521 5 81.162.4.64/26 2005-03-27 12:04:14
522 113 81.162.40.64/26 2005-03-27 12:05:01
523 191 81.162.66.64/26 2005-03-27 12:05:01
524 119 81.162.42.64/26 2005-03-27 12:06:01
525 3 81.162.2.128/26 2005-03-27 12:06:03
526 74 81.162.27.64/26 2005-03-27 12:06:12
527 201 81.162.70.0/26 2005-03-27 12:06:25
528 86 81.162.31.64/26 2005-03-27 12:07:56
529 50 81.162.19.64/26 2005-03-27 12:08:36
530 59 81.162.22.64/26 2005-03-27 12:08:59
531 43 81.162.17.0/26 2005-03-27 12:09:02
532 80 81.162.29.64/26 2005-03-27 12:09:14
533 106 81.162.38.0/26 2005-03-27 12:09:15
534 52 81.162.20.0/26 2005-03-27 12:09:22
535 205 81.162.72.0/26 2005-03-27 12:10:08
536 82 81.162.30.0/26 2005-03-27 12:10:10
537 128 81.162.45.64/26 2005-03-27 12:10:38
538 112 81.162.40.0/26 2005-03-27 12:11:16
539 202 81.162.70.64/26 2005-03-27 12:12:30
540 6 81.162.4.128/26 2005-03-27 12:12:49
541 95 81.162.34.64/26 2005-03-27 12:13:02
542 178 81.162.62.0/26 2005-03-27 12:13:10
543 145 81.162.51.0/26 2005-03-27 12:13:15
544 84 81.162.30.128/26 2005-03-27 12:13:34
545 28 81.162.12.0/26 2005-03-27 12:13:58
546 22 81.162.10.0/26 2005-03-27 12:14:40
547 122 81.162.43.64/26 2005-03-27 12:14:57
548 85 81.162.31.0/26 2005-03-27 12:15:21
549 18 81.162.8.128/26 2005-03-27 12:15:24
550 105 81.162.37.128/26 2005-03-27 12:15:24
551 81 81.162.29.128/26 2005-03-27 12:15:36
552 77 81.162.28.64/26 2005-03-27 12:15:47
553 146 81.162.51.64/26 2005-03-27 12:17:09
554 24 81.162.10.128/26 2005-03-27 12:17:10
555 190 81.162.66.0/26 2005-03-27 12:17:10
556 33 81.162.13.128/26 2005-03-27 12:17:17
557 150 81.162.52.128/26 2005-03-27 12:17:27
558 57 81.162.21.128/26 2005-03-27 12:17:37
559 17 81.162.8.64/26 2005-03-27 12:17:39
560 54 81.162.20.128/26 2005-03-27 12:18:24
561 94 81.162.34.0/26 2005-03-27 12:18:24
562 69 81.162.25.128/26 2005-03-27 12:18:26
563 141 81.162.49.128/26 2005-03-27 12:18:43
564 154 81.162.54.0/26 2005-03-27 12:19:25
565 177 81.162.61.128/26 2005-03-27 12:20:17
566 29 81.162.12.64/26 2005-03-27 12:20:37
567 91 81.162.33.0/26 2005-03-27 12:20:53
568 83 81.162.30.64/26 2005-03-27 12:20:57
569 47 81.162.18.64/26 2005-03-27 12:21:10
570 170 81.162.59.64/26 2005-03-27 12:22:01
571 78 81.162.28.128/26 2005-03-27 12:22:26
572 155 81.162.54.64/26 2005-03-27 12:23:11
573 35 81.162.14.64/26 2005-03-27 12:23:12
574 32 81.162.13.64/26 2005-03-27 12:23:55
575 199 81.162.69.64/26 2005-03-27 12:24:13
576 63 81.162.23.128/26 2005-03-27 12:24:33
577 90 81.162.32.128/26 2005-03-27 12:25:31
578 114 81.162.40.128/26 2005-03-27 12:26:04
579 75 81.162.27.128/26 2005-03-27 12:26:06
580 42 81.162.16.128/26 2005-03-27 12:26:26
581 87 81.162.31.128/26 2005-03-27 12:26:42
582 67 81.162.25.0/26 2005-03-27 12:27:31
583 204 81.162.71.128/26 2005-03-27 12:34:04
584 200 81.162.69.128/26 2005-03-27 12:37:19
585 207 81.162.73.64/26 2005-03-27 12:41:57
586 203 81.162.71.64/26 2005-03-27 12:58:48
587 214 81.162.213.0/24 2005-03-27 13:02:26
588 213 81.162.213.0/24 2005-03-27 13:02:26
589 209 81.162.212.0/24 2005-03-27 13:16:02
590 215 81.162.200.0/24 2005-03-27 13:16:14
591 210 81.162.250.0/24 2005-03-27 13:18:02
592 211 81.162.252.0/24 2005-03-27 12:39:02
593 129 81.162.45.128/26 2005-03-27 10:44:11
594 110 81.162.39.64/26 2005-03-27 08:19:17
595 10 81.162.6.0/26 2005-03-27 08:35:15
596 171 81.162.59.128/26 2005-03-27 08:42:52
597 167 81.162.58.64/26 2005-03-27 09:07:47
598 180 81.162.62.128/26 2005-03-27 09:22:15
599 140 81.162.49.64/26 2005-03-27 09:41:51
600 103 81.162.37.0/26 2005-03-27 09:42:30
601 55 81.162.21.0/26 2005-03-27 09:42:54
602 137 81.162.48.64/26 2005-03-27 09:47:06
603 62 81.162.23.64/26 2005-03-27 09:51:30
604 158 81.162.55.64/26 2005-03-27 09:51:55
605 70 81.162.26.0/26 2005-03-27 09:52:09
606 159 81.162.55.128/26 2005-03-27 10:05:56
607 165 81.162.57.128/26 2005-03-27 10:09:30
608 125 81.162.44.64/26 2005-03-27 10:10:14
609 169 81.162.59.0/26 2005-03-27 10:10:29
610 89 81.162.32.64/26 2005-03-27 10:11:14
611 168 81.162.58.128/26 2005-03-27 10:11:42
612 39 81.162.15.128/26 2005-03-27 10:11:49
613 134 81.162.47.64/26 2005-03-27 10:12:00
614 144 81.162.50.128/26 2005-03-27 10:15:46
615 61 81.162.23.0/26 2005-03-27 10:19:36
616 186 81.162.64.128/26 2005-03-27 10:24:08
617 97 81.162.35.0/26 2005-03-27 10:26:13
618 124 81.162.44.0/26 2005-03-27 10:28:37
619 162 81.162.56.128/26 2005-03-27 10:36:33
620 76 81.162.28.0/26 2005-03-27 10:38:20
621 156 81.162.54.128/26 2005-03-27 10:41:07
622 93 81.162.33.128/26 2005-03-27 10:42:16
623 58 81.162.22.0/26 2005-03-27 10:42:50
624 23 81.162.10.64/26 2005-03-27 10:43:27
625 132 81.162.46.128/26 2005-03-27 10:46:35
626 118 81.162.42.0/26 2005-03-27 10:47:16
627 16 81.162.8.0/26 2005-03-27 10:47:53
628 182 81.162.63.64/26 2005-03-27 10:47:58
629 88 81.162.32.0/26 2005-03-27 10:49:28
630 126 81.162.44.128/26 2005-03-27 10:50:02
631 130 81.162.46.0/26 2005-03-27 10:50:46
632 15 81.162.7.128/26 2005-03-27 10:54:20
633 12 81.162.6.128/26 2005-03-27 10:54:40
634 98 81.162.35.64/26 2005-03-27 10:55:15
635 104 81.162.37.64/26 2005-03-27 10:57:11
636 100 81.162.36.0/26 2005-03-27 10:58:55
637 45 81.162.17.128/26 2005-03-27 11:02:32
638 131 81.162.46.64/26 2005-03-27 11:04:23
639 175 81.162.61.0/26 2005-03-27 11:04:47
640 72 81.162.26.128/26 2005-03-27 11:04:50
641 148 81.162.52.0/26 2005-03-27 11:05:19
642 198 81.162.68.128/26 2005-03-27 11:06:42
643 68 81.162.25.64/26 2005-03-27 11:06:55
644 115 81.162.41.0/26 2005-03-27 11:08:58
645 157 81.162.55.0/26 2005-03-27 11:10:30
646 111 81.162.39.128/26 2005-03-27 11:11:10
647 120 81.162.42.128/26 2005-03-27 10:14:01
648 21 81.162.9.128/26 2005-03-27 10:39:11
649 64 81.162.24.0/26 2005-03-27 11:14:54
650 7 81.162.5.0/26 2005-03-27 11:15:07
651 163 81.162.57.0/26 2005-03-27 11:18:50
652 208 81.162.73.128/26 2005-03-27 11:18:53
653 189 81.162.65.128/26 2005-03-27 11:20:12
654 197 81.162.68.64/26 2005-03-27 11:20:46
655 31 81.162.13.0/26 2005-03-27 11:22:31
656 19 81.162.9.0/26 2005-03-27 11:22:48
657 13 81.162.7.0/26 2005-03-27 11:24:35
658 147 81.162.51.128/26 2005-03-27 11:27:37
659 135 81.162.47.128/26 2005-03-27 11:28:43
660 121 81.162.43.0/26 2005-03-27 11:28:58
661 136 81.162.48.0/26 2005-03-27 11:31:04
662 66 81.162.24.128/26 2005-03-27 11:32:10
663 166 81.162.58.0/26 2005-03-27 09:25:55
664 138 81.162.48.128/26 2005-03-27 10:08:33
665 56 81.162.21.64/26 2005-03-27 11:32:34
666 143 81.162.50.64/26 2005-03-27 11:33:03
667 176 81.162.61.64/26 2005-03-27 11:33:36
668 65 81.162.24.64/26 2005-03-27 11:33:40
669 102 81.162.36.128/26 2005-03-27 11:34:00
670 116 81.162.41.64/26 2005-03-27 11:34:56
671 183 81.162.63.128/26 2005-03-27 11:36:02
672 109 81.162.39.0/26 2005-03-27 11:36:45
673 25 81.162.11.0/26 2005-03-27 11:37:44
674 174 81.162.60.128/26 2005-03-27 11:38:11
675 216 81.162.202.0/24 2005-03-27 11:39:03
676 40 81.162.16.0/26 2005-03-27 11:39:31
677 152 81.162.53.64/26 2005-03-27 11:39:47
678 14 81.162.7.64/26 2005-03-27 11:39:59
679 92 81.162.33.64/26 2005-03-27 11:40:05
680 173 81.162.60.64/26 2005-03-27 11:40:28
681 48 81.162.18.128/26 2005-03-27 11:40:28
682 8 81.162.5.64/26 2005-03-27 11:40:45
683 108 81.162.38.128/26 2005-03-27 11:42:43
684 11 81.162.6.64/26 2005-03-27 08:50:50
685 188 81.162.65.64/26 2005-03-27 08:55:21
686 117 81.162.41.128/26 2005-03-27 09:23:35
687 26 81.162.11.64/26 2005-03-27 11:43:18
688 172 81.162.60.0/26 2005-03-27 11:43:21
689 71 81.162.26.64/26 2005-03-27 11:43:51
690 38 81.162.15.64/26 2005-03-27 11:44:11
691 153 81.162.53.128/26 2005-03-27 11:45:51
692 53 81.162.20.64/26 2005-03-27 11:46:24
693 1 81.162.2.0/26 2005-03-27 11:47:03
694 2 81.162.2.64/26 2005-03-27 11:47:10
695 149 81.162.52.64/26 2005-03-27 11:48:35
696 37 81.162.15.0/26 2005-03-27 11:49:04
697 127 81.162.45.0/26 2005-03-27 11:49:22
698 179 81.162.62.64/26 2005-03-27 11:49:48
699 185 81.162.64.64/26 2005-03-27 11:50:36
700 142 81.162.50.0/26 2005-03-27 11:51:18
701 36 81.162.14.128/26 2005-03-27 11:51:19
702 30 81.162.12.128/26 2005-03-27 11:51:20
703 60 81.162.22.128/26 2005-03-27 11:52:08
704 49 81.162.19.0/26 2005-03-27 10:22:15
705 73 81.162.27.0/26 2005-03-27 11:27:55
706 96 81.162.34.128/26 2005-03-27 11:32:26
707 101 81.162.36.64/26 2005-03-27 11:40:47
708 181 81.162.63.0/26 2005-03-27 11:52:55
709 187 81.162.65.0/26 2005-03-27 11:53:23
710 161 81.162.56.64/26 2005-03-27 08:54:44
715 -- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: postgres
718 COPY placements (switch, placement) FROM stdin;
719 221 (375,325),(350,300)
720 222 (550,325),(525,300)
721 224 (775,325),(750,300)
722 223 (875,325),(850,300)
723 225 (675,325),(650,300)
724 218 (980,550),(930,520)
725 1 (306,306),(294,256)
726 2 (306,256),(294,206)
727 3 (306,206),(294,156)
728 4 (325,306),(313,256)
729 5 (325,256),(313,206)
730 6 (325,206),(313,156)
731 7 (344,470),(332,422)
732 8 (344,422),(332,374)
733 9 (344,374),(332,326)
734 10 (344,306),(332,256)
735 11 (344,256),(332,206)
736 12 (344,206),(332,156)
737 13 (363,470),(351,422)
738 14 (363,422),(351,374)
739 15 (363,374),(351,326)
740 16 (363,306),(351,256)
741 17 (363,256),(351,206)
742 18 (363,206),(351,156)
743 19 (382,470),(370,422)
744 20 (382,422),(370,374)
745 21 (382,374),(370,326)
746 22 (382,306),(370,256)
747 23 (382,256),(370,206)
748 24 (382,206),(370,156)
749 25 (400,470),(388,422)
750 26 (400,422),(388,374)
751 27 (400,374),(388,326)
752 28 (400,306),(388,256)
753 29 (400,256),(388,206)
754 30 (400,206),(388,156)
755 31 (419,470),(407,422)
756 32 (419,422),(407,374)
757 33 (419,374),(407,326)
758 34 (419,306),(407,256)
759 35 (419,256),(407,206)
760 36 (419,206),(407,156)
761 37 (438,470),(426,422)
762 38 (438,422),(426,374)
763 39 (438,374),(426,326)
764 40 (438,306),(426,256)
765 41 (438,256),(426,206)
766 42 (438,206),(426,156)
767 43 (457,470),(445,422)
768 44 (457,422),(445,374)
769 45 (457,374),(445,326)
770 46 (457,306),(445,256)
771 47 (457,256),(445,206)
772 48 (457,206),(445,156)
773 49 (483,470),(471,422)
774 50 (483,422),(471,374)
775 51 (483,374),(471,326)
776 52 (483,306),(471,256)
777 53 (483,256),(471,206)
778 54 (483,206),(471,156)
779 55 (502,470),(490,422)
780 56 (502,422),(490,374)
781 57 (502,374),(490,326)
782 58 (502,306),(490,256)
783 59 (502,256),(490,206)
784 60 (502,206),(490,156)
785 61 (521,470),(509,422)
786 62 (521,422),(509,374)
787 63 (521,374),(509,326)
788 64 (521,306),(509,256)
789 65 (521,256),(509,206)
790 66 (521,206),(509,156)
791 67 (540,470),(528,422)
792 68 (540,422),(528,374)
793 69 (540,374),(528,326)
794 70 (540,306),(528,256)
795 71 (540,256),(528,206)
796 72 (540,206),(528,156)
797 73 (559,470),(547,422)
798 74 (559,422),(547,374)
799 75 (559,374),(547,326)
800 76 (559,306),(547,256)
801 77 (559,256),(547,206)
802 78 (559,206),(547,156)
803 79 (578,470),(566,422)
804 80 (578,422),(566,374)
805 81 (578,374),(566,326)
806 82 (578,306),(566,256)
807 83 (578,256),(566,206)
808 84 (578,206),(566,156)
809 85 (596,470),(584,422)
810 86 (596,422),(584,374)
811 87 (596,374),(584,326)
812 88 (596,306),(584,256)
813 89 (596,256),(584,206)
814 90 (596,206),(584,156)
815 91 (615,470),(603,422)
816 92 (615,422),(603,374)
817 93 (615,374),(603,326)
818 94 (615,306),(603,256)
819 95 (615,256),(603,206)
820 96 (615,206),(603,156)
821 97 (648,470),(636,422)
822 98 (648,422),(636,374)
823 99 (648,374),(636,326)
824 100 (648,306),(636,256)
825 101 (648,256),(636,206)
826 102 (648,206),(636,156)
827 103 (667,470),(655,422)
828 104 (667,422),(655,374)
829 105 (667,374),(655,326)
830 106 (667,306),(655,256)
831 107 (667,256),(655,206)
832 108 (667,206),(655,156)
833 109 (686,470),(674,422)
834 110 (686,422),(674,374)
835 111 (686,374),(674,326)
836 112 (686,306),(674,256)
837 113 (686,256),(674,206)
838 114 (686,206),(674,156)
839 115 (705,470),(693,422)
840 116 (705,422),(693,374)
841 117 (705,374),(693,326)
842 118 (705,306),(693,256)
843 119 (705,256),(693,206)
844 120 (705,206),(693,156)
845 121 (724,470),(712,422)
846 122 (724,422),(712,374)
847 123 (724,374),(712,326)
848 124 (724,306),(712,256)
849 125 (724,256),(712,206)
850 126 (724,206),(712,156)
851 127 (743,470),(731,422)
852 128 (743,422),(731,374)
853 129 (743,374),(731,326)
854 130 (743,306),(731,256)
855 131 (743,256),(731,206)
856 132 (743,206),(731,156)
857 133 (762,470),(750,422)
858 134 (762,422),(750,374)
859 135 (762,374),(750,326)
860 136 (762,306),(750,256)
861 137 (762,256),(750,206)
862 138 (762,206),(750,156)
863 139 (781,470),(769,422)
864 140 (781,422),(769,374)
865 141 (781,374),(769,326)
866 142 (781,306),(769,256)
867 143 (781,256),(769,206)
868 144 (781,206),(769,156)
869 145 (808,470),(796,422)
870 146 (808,422),(796,374)
871 147 (808,374),(796,326)
872 148 (808,306),(796,256)
873 149 (808,256),(796,206)
874 150 (808,206),(796,156)
875 151 (827,470),(815,422)
876 152 (827,422),(815,374)
877 153 (827,374),(815,326)
878 154 (827,306),(815,256)
879 155 (827,256),(815,206)
880 156 (827,206),(815,156)
881 157 (846,470),(834,422)
882 158 (846,422),(834,374)
883 159 (846,374),(834,326)
884 160 (846,306),(834,256)
885 161 (846,256),(834,206)
886 162 (846,206),(834,156)
887 163 (865,470),(853,422)
888 164 (865,422),(853,374)
889 165 (865,374),(853,326)
890 166 (865,306),(853,256)
891 167 (865,256),(853,206)
892 168 (865,206),(853,156)
893 169 (884,470),(872,422)
894 170 (884,422),(872,374)
895 171 (884,374),(872,326)
896 172 (884,306),(872,256)
897 173 (884,256),(872,206)
898 174 (884,206),(872,156)
899 175 (903,470),(891,422)
900 176 (903,422),(891,374)
901 177 (903,374),(891,326)
902 178 (903,306),(891,256)
903 179 (903,256),(891,206)
904 180 (903,206),(891,156)
905 181 (922,470),(910,422)
906 182 (922,422),(910,374)
907 183 (922,374),(910,326)
908 184 (922,306),(910,256)
909 185 (922,256),(910,206)
910 186 (922,206),(910,156)
911 187 (941,470),(929,422)
912 188 (941,422),(929,374)
913 189 (941,374),(929,326)
914 190 (941,306),(929,256)
915 191 (941,256),(929,206)
916 192 (941,206),(929,156)
917 193 (960,470),(948,422)
918 194 (960,422),(948,374)
919 195 (960,374),(948,326)
920 196 (960,306),(948,256)
921 197 (960,256),(948,206)
922 198 (960,206),(948,156)
923 199 (988,422),(976,374)
924 200 (988,374),(976,326)
925 201 (979,306),(967,256)
926 202 (979,256),(967,206)
927 203 (1006,422),(994,374)
928 204 (1006,374),(994,326)
929 205 (997,306),(985,256)
930 207 (1025,422),(1013,374)
931 208 (1025,374),(1013,326)
932 209 (1125,225),(1100,200)
933 210 (680,550),(630,520)
934 211 (610,550),(560,520)
935 212 (305,385),(270,350)
936 213 (900,100),(800,75)
937 214 (900,100),(800,75)
938 215 (200,270),(170,240)
939 216 (250,180),(220,150)
944 -- Data for Name: polls; Type: TABLE DATA; Schema: public; Owner: postgres
947 COPY polls ("time", switch, port, bytes_in, bytes_out) FROM stdin;
948 2006-03-28 22:39:09.893643+02 1 1 0 0
949 2006-03-28 22:39:09.913546+02 1 2 0 0
950 2006-03-28 22:39:09.933906+02 1 3 0 0
951 2006-03-28 22:39:09.953638+02 1 4 0 0
952 2006-03-28 22:39:09.973536+02 1 5 0 0
953 2006-03-28 22:39:09.993418+02 1 6 0 0
954 2006-03-28 22:39:10.013146+02 1 7 0 0
955 2006-03-28 22:39:10.032774+02 1 8 0 0
956 2006-03-28 22:39:10.052348+02 1 9 0 0
957 2006-03-28 22:39:10.072177+02 1 10 0 0
958 2006-03-28 22:39:10.092731+02 1 11 0 0
959 2006-03-28 22:39:10.11247+02 1 12 0 0
960 2006-03-28 22:39:10.132382+02 1 13 7747123 14112208
961 2006-03-28 22:39:10.152582+02 1 14 7713082 14042766
962 2006-03-28 22:39:10.172369+02 1 15 8056118 17207110
963 2006-03-28 22:39:10.192118+02 1 16 0 0
964 2006-03-28 22:39:10.212055+02 1 17 0 0
965 2006-03-28 22:39:10.231483+02 1 18 0 0
966 2006-03-28 22:39:10.251181+02 1 19 138414013 203348896
967 2006-03-28 22:39:10.271767+02 1 20 199834250 208491729
968 2006-03-28 22:39:10.29177+02 1 21 6357743 13961928
969 2006-03-28 22:39:10.311587+02 1 22 0 0
970 2006-03-28 22:39:10.331091+02 1 23 0 0
971 2006-03-28 22:39:10.350932+02 1 24 0 0
972 2006-03-28 22:39:10.370631+02 1 25 0 0
973 2006-03-28 22:39:10.390715+02 1 26 0 0
974 2006-03-28 22:39:10.410346+02 1 27 0 0
975 2006-03-28 22:39:10.430225+02 1 28 0 0
976 2006-03-28 22:39:10.450417+02 1 29 0 0
977 2006-03-28 22:39:10.471318+02 1 30 0 0
978 2006-03-28 22:39:10.490967+02 1 31 0 0
979 2006-03-28 22:39:10.511826+02 1 32 0 0
980 2006-03-28 22:39:10.53276+02 1 33 0 0
981 2006-03-28 22:39:10.553075+02 1 34 0 0
982 2006-03-28 22:39:10.573845+02 1 35 0 0
983 2006-03-28 22:39:10.595012+02 1 36 0 0
984 2006-03-28 22:39:10.615023+02 1 37 0 0
985 2006-03-28 22:39:10.634971+02 1 38 0 0
986 2006-03-28 22:39:10.654731+02 1 39 0 0
987 2006-03-28 22:39:10.686279+02 1 40 0 0
988 2006-03-28 22:39:10.705889+02 1 41 0 0
989 2006-03-28 22:39:10.72543+02 1 42 0 0
990 2006-03-28 22:39:10.745098+02 1 43 0 0
991 2006-03-28 22:39:10.764735+02 1 44 0 0
992 2006-03-28 22:39:10.784882+02 1 45 0 0
993 2006-03-28 22:39:10.804477+02 1 46 816 976127
994 2006-03-28 22:39:10.82424+02 1 47 748 503124
995 2006-03-28 22:39:10.843866+02 1 48 816 276935
996 2006-03-28 22:39:10.863439+02 1 49 2890 2890
997 2006-03-28 22:39:10.883028+02 1 50 210 210
998 2006-03-28 22:39:10.90281+02 1 51 210 210
999 2006-03-28 22:39:10.922442+02 1 52 210 210
1000 2006-03-28 22:39:10.942226+02 1 53 210 210
1001 2006-03-28 22:39:10.96199+02 1 54 210 210
1002 2006-03-28 22:39:10.983951+02 1 55 210 210
1003 2006-03-28 22:39:11.003594+02 1 56 210 210
1004 2006-03-28 22:39:11.023272+02 1 57 1058 1058
1005 2006-03-28 22:39:11.043103+02 1 58 210 210
1006 2006-03-28 22:39:11.062924+02 1 59 210 210
1007 2006-03-28 22:39:11.083132+02 1 60 210 210
1008 2006-03-28 22:39:11.103073+02 1 61 210 210
1009 2006-03-28 22:39:11.123076+02 1 62 370389 1367489
1010 2006-03-28 22:39:11.142765+02 1 63 210 535911
1011 2006-03-28 22:39:11.162409+02 1 64 210 243777
1012 2006-03-28 22:39:11.18224+02 1 65 228 5275950
1013 2006-03-28 22:39:11.202296+02 1 66 7020 164802316
1014 2006-03-28 22:39:11.221934+02 1 67 0 0
1015 2006-03-28 22:39:11.24138+02 1 68 0 0
1016 2006-03-28 22:39:11.260987+02 1 69 0 0
1017 2006-03-28 22:39:11.280526+02 1 70 0 0
1018 2006-03-28 22:39:11.300239+02 1 71 228 228
1019 2006-03-28 22:39:11.319742+02 1 72 146 5274588
1020 2006-03-28 22:39:11.339383+02 1 73 240 240
1021 2006-03-28 22:39:11.35914+02 1 74 240 240
1022 2006-03-28 22:39:11.378792+02 1 75 240 240
1023 2006-03-28 22:39:11.398351+02 1 76 240 240
1024 2006-03-28 22:39:11.41811+02 1 77 240 240
1025 2006-03-28 22:39:11.437892+02 1 78 240 240
1026 2006-03-28 22:39:11.457433+02 1 79 0 0
1027 2006-03-28 22:39:11.477388+02 1 80 4286507245 3471154200
1028 2006-03-28 22:39:11.497485+02 1 81 146 146
1029 2006-03-28 22:39:11.517205+02 1 82 0 0
1030 2006-03-28 22:39:11.536948+02 1 83 146 146
1031 2006-03-28 22:39:11.556906+02 1 84 0 0
1032 2006-03-28 22:39:11.576549+02 1 85 0 0
1033 2006-03-28 22:39:11.597038+02 1 86 0 0
1034 2006-03-28 22:39:11.616963+02 1 87 0 0
1035 2006-03-28 22:39:11.636499+02 1 88 0 0
1036 2006-03-28 22:39:11.656367+02 1 89 0 0
1037 2006-03-28 22:39:11.67601+02 1 90 0 0
1038 2006-03-28 22:39:11.696501+02 1 91 0 0
1039 2006-03-28 22:39:11.715967+02 1 92 0 0
1040 2006-03-28 22:39:11.735507+02 1 93 0 0
1041 2006-03-28 22:39:11.755479+02 1 94 0 0
1042 2006-03-28 22:39:11.775257+02 1 95 0 0
1043 2006-03-28 22:39:11.795138+02 1 96 0 0
1044 2006-03-28 22:39:11.815197+02 1 97 240 1620567769
1045 2006-03-28 22:39:11.834833+02 1 98 39356 122027824
1046 2006-03-28 22:39:11.854636+02 1 99 9234 1182439
1047 2006-03-28 22:39:11.874374+02 1 100 240 28805070
1048 2006-03-28 22:39:11.894428+02 1 101 240 1096957
1049 2006-03-28 22:39:11.91458+02 1 102 620 619669
1050 2006-03-28 22:39:11.934683+02 1 103 0 0
1051 2006-03-28 22:39:11.954545+02 1 104 2746281650 1380471316
1052 2006-03-28 22:39:11.974981+02 1 105 0 0
1053 2006-03-28 22:39:11.994707+02 1 106 0 0
1054 2006-03-28 22:39:12.016469+02 1 107 0 0
1055 2006-03-28 22:39:12.036156+02 1 108 154278739 16885365
1056 2006-03-28 22:39:12.055859+02 1 109 0 953869
1057 2006-03-28 22:39:12.075687+02 1 110 11485 93069
1058 2006-03-28 22:39:12.095999+02 1 111 17993418 93133
1059 2006-03-28 22:39:12.1156+02 1 112 5310060 6561837
1060 2006-03-28 22:39:12.135708+02 1 113 0 97485
1061 2006-03-28 22:39:12.155377+02 1 114 0 0
1062 2006-03-28 22:39:12.174924+02 1 115 0 93133
1063 2006-03-28 22:39:12.195017+02 1 116 0 93133
1064 2006-03-28 22:39:12.214711+02 1 117 40502 130091
1065 2006-03-28 22:39:12.234355+02 1 118 0 0
1066 2006-03-28 22:39:12.253895+02 1 119 1440 1440
1067 2006-03-28 22:39:12.273878+02 1 120 49930 1774299728
1068 2006-03-28 22:39:12.383056+02 1 121 7476090 7476090
1069 2006-03-28 22:39:12.403941+02 1 122 0 0
1070 2006-03-28 22:39:12.424965+02 1 123 0 0
1071 2006-03-28 22:45:50.691773+02 1 1 0 0
1072 2006-03-28 22:45:50.712108+02 1 2 0 0
1073 2006-03-28 22:45:50.732551+02 1 3 0 0
1074 2006-03-28 22:45:50.752709+02 1 4 0 0
1075 2006-03-28 22:45:50.772544+02 1 5 0 0
1076 2006-03-28 22:45:50.792215+02 1 6 0 0
1077 2006-03-28 22:45:50.811996+02 1 7 0 0
1078 2006-03-28 22:45:50.838285+02 1 8 0 0
1079 2006-03-28 22:45:50.859209+02 1 9 0 0
1080 2006-03-28 22:45:50.879008+02 1 10 0 0
1081 2006-03-28 22:45:50.899314+02 1 11 0 0
1082 2006-03-28 22:45:50.918892+02 1 12 0 0
1083 2006-03-28 22:45:50.938681+02 1 13 7781011 14166925
1084 2006-03-28 22:45:50.958276+02 1 14 7742093 14093748
1085 2006-03-28 22:45:50.978192+02 1 15 8089140 17260526
1086 2006-03-28 22:45:50.998131+02 1 16 0 0
1087 2006-03-28 22:45:51.017874+02 1 17 0 0
1088 2006-03-28 22:45:51.037875+02 1 18 0 0
1089 2006-03-28 22:45:51.057617+02 1 19 138442049 203409365
1090 2006-03-28 22:45:51.07741+02 1 20 199872795 208568010
1091 2006-03-28 22:45:51.09707+02 1 21 6385320 14021490
1092 2006-03-28 22:45:51.116944+02 1 22 0 0
1093 2006-03-28 22:45:51.136723+02 1 23 0 0
1094 2006-03-28 22:45:51.156402+02 1 24 0 0
1095 2006-03-28 22:46:04.439098+02 1 1 0 0
1096 2006-03-28 22:46:04.459636+02 1 2 0 0
1097 2006-03-28 22:46:04.479286+02 1 3 0 0
1098 2006-03-28 22:46:04.498935+02 1 4 0 0
1099 2006-03-28 22:46:04.5186+02 1 5 0 0
1100 2006-03-28 22:46:04.538232+02 1 6 0 0
1101 2006-03-28 22:46:04.55788+02 1 7 0 0
1102 2006-03-28 22:46:04.577626+02 1 8 0 0
1103 2006-03-28 22:46:04.597683+02 1 9 0 0
1104 2006-03-28 22:46:04.617111+02 1 10 0 0
1105 2006-03-28 22:46:04.637422+02 1 11 0 0
1106 2006-03-28 22:46:04.657219+02 1 12 0 0
1107 2006-03-28 22:46:04.67687+02 1 13 7781329 14167539
1108 2006-03-28 22:46:04.696741+02 1 14 7742221 14094648
1109 2006-03-28 22:46:04.716788+02 1 15 8089268 17261268
1110 2006-03-28 22:46:04.736581+02 1 16 0 0
1111 2006-03-28 22:46:04.756341+02 1 17 0 0
1112 2006-03-28 22:46:04.775933+02 1 18 0 0
1113 2006-03-28 22:46:04.795543+02 1 19 138442495 203409877
1114 2006-03-28 22:46:04.815504+02 1 20 199872859 208568458
1115 2006-03-28 22:46:04.835122+02 1 21 6385384 14022032
1116 2006-03-28 22:46:04.855403+02 1 22 0 0
1117 2006-03-28 22:46:04.875114+02 1 23 0 0
1118 2006-03-28 22:46:04.895722+02 1 24 0 0
1119 2006-03-28 23:04:10.517298+02 1 1 0 0
1120 2006-03-28 23:04:10.537186+02 1 2 0 0
1121 2006-03-28 23:04:10.556902+02 1 3 0 0
1122 2006-03-28 23:04:10.576559+02 1 4 0 0
1123 2006-03-28 23:04:10.596516+02 1 5 0 0
1124 2006-03-28 23:04:10.617152+02 1 6 0 0
1125 2006-03-28 23:04:10.636818+02 1 7 0 0
1126 2006-03-28 23:04:10.656596+02 1 8 0 0
1127 2006-03-28 23:04:10.676103+02 1 9 0 0
1128 2006-03-28 23:04:10.696325+02 1 10 0 0
1129 2006-03-28 23:04:10.716109+02 1 11 0 0
1130 2006-03-28 23:04:10.736552+02 1 12 0 0
1131 2006-03-28 23:04:10.75648+02 1 13 7856336 14296955
1132 2006-03-28 23:04:10.776391+02 1 14 7823592 14228507
1133 2006-03-28 23:04:10.796099+02 1 15 8167545 17392530
1134 2006-03-28 23:04:10.816284+02 1 16 0 0
1135 2006-03-28 23:04:10.836317+02 1 17 0 0
1136 2006-03-28 23:04:10.855804+02 1 18 0 0
1137 2006-03-28 23:04:10.876015+02 1 19 138516087 203568321
1138 2006-03-28 23:04:10.896711+02 1 20 199973797 208768486
1139 2006-03-28 23:04:10.916745+02 1 21 6458453 14179252
1140 2006-03-28 23:04:10.937118+02 1 22 0 0
1141 2006-03-28 23:04:10.956641+02 1 23 0 0
1142 2006-03-28 23:04:10.976821+02 1 24 0 0
1143 2006-03-28 23:04:38.934053+02 1 1 0 0
1144 2006-03-28 23:04:38.95404+02 1 2 0 0
1145 2006-03-28 23:04:38.973763+02 1 3 0 0
1146 2006-03-28 23:04:38.993548+02 1 4 0 0
1147 2006-03-28 23:04:39.013146+02 1 5 0 0
1148 2006-03-28 23:04:39.032762+02 1 6 0 0
1149 2006-03-28 23:04:39.05292+02 1 7 0 0
1150 2006-03-28 23:04:39.073058+02 1 8 0 0
1151 2006-03-28 23:04:39.093076+02 1 9 0 0
1152 2006-03-28 23:04:39.112943+02 1 10 0 0
1153 2006-03-28 23:04:39.142183+02 1 11 0 0
1154 2006-03-28 23:04:39.16179+02 1 12 0 0
1155 2006-03-28 23:04:39.181511+02 1 13 7857656 14300001
1156 2006-03-28 23:04:39.201421+02 1 14 7825006 14231647
1157 2006-03-28 23:04:39.221197+02 1 15 8169119 17395512
1158 2006-03-28 23:04:39.24095+02 1 16 0 0
1159 2006-03-28 23:04:39.260593+02 1 17 0 0
1160 2006-03-28 23:04:39.28024+02 1 18 0 0
1161 2006-03-28 23:04:39.300251+02 1 19 138516907 203572473
1162 2006-03-28 23:04:39.320172+02 1 20 199974935 208772794
1163 2006-03-28 23:04:39.340547+02 1 21 6459209 14183340
1164 2006-03-28 23:04:39.36032+02 1 22 0 0
1165 2006-03-28 23:04:39.379996+02 1 23 0 0
1166 2006-03-28 23:04:39.399682+02 1 24 0 0
1167 2006-03-28 23:08:25.811543+02 1 1 0 0
1168 2006-03-28 23:08:25.832178+02 1 2 0 0
1169 2006-03-28 23:08:25.851821+02 1 3 0 0
1170 2006-03-28 23:08:25.871447+02 1 4 0 0
1171 2006-03-28 23:08:25.891095+02 1 5 0 0
1172 2006-03-28 23:08:25.911042+02 1 6 0 0
1173 2006-03-28 23:08:25.930796+02 1 7 0 0
1174 2006-03-28 23:08:25.950443+02 1 8 0 0
1175 2006-03-28 23:08:25.970441+02 1 9 0 0
1176 2006-03-28 23:08:25.990093+02 1 10 0 0
1177 2006-03-28 23:08:26.009844+02 1 11 0 0
1178 2006-03-28 23:08:26.029585+02 1 12 0 0
1179 2006-03-28 23:08:26.04914+02 1 13 7876029 14330508
1180 2006-03-28 23:08:26.068755+02 1 14 7842402 14260671
1181 2006-03-28 23:08:26.088424+02 1 15 8186302 17425712
1182 2006-03-28 23:08:26.108129+02 1 16 0 0
1183 2006-03-28 23:08:26.128018+02 1 17 0 0
1184 2006-03-28 23:08:26.147692+02 1 18 0 0
1185 2006-03-28 23:08:26.167393+02 1 19 138532007 203604699
1186 2006-03-28 23:08:26.187095+02 1 20 199996249 208814508
1187 2006-03-28 23:08:26.206925+02 1 21 6474499 14215586
1188 2006-03-28 23:08:26.226462+02 1 22 0 0
1189 2006-03-28 23:08:26.246118+02 1 23 0 0
1190 2006-03-28 23:08:26.265827+02 1 24 0 0
1191 2006-03-28 23:09:33.136981+02 1 1 0 0
1192 2006-03-28 23:09:33.15741+02 1 2 0 0
1193 2006-03-28 23:09:33.177081+02 1 3 0 0
1194 2006-03-28 23:09:33.196591+02 1 4 0 0
1195 2006-03-28 23:09:33.216282+02 1 5 0 0
1196 2006-03-28 23:09:33.235922+02 1 6 0 0
1197 2006-03-28 23:09:33.255785+02 1 7 0 0
1198 2006-03-28 23:09:33.27593+02 1 8 0 0
1199 2006-03-28 23:09:33.295795+02 1 9 0 0
1200 2006-03-28 23:09:33.3154+02 1 10 0 0
1201 2006-03-28 23:09:33.337366+02 1 11 0 0
1202 2006-03-28 23:09:33.357016+02 1 12 0 0
1203 2006-03-28 23:09:33.376724+02 1 13 7880337 14338168
1204 2006-03-28 23:09:33.396546+02 1 14 7845454 14268425
1205 2006-03-28 23:09:33.416402+02 1 15 8189578 17433278
1206 2006-03-28 23:09:33.436008+02 1 16 0 0
1207 2006-03-28 23:09:33.455964+02 1 17 0 0
1208 2006-03-28 23:09:33.475705+02 1 18 0 0
1209 2006-03-28 23:09:33.495599+02 1 19 138538669 203617075
1210 2006-03-28 23:09:33.515334+02 1 20 200004048 208829958
1211 2006-03-28 23:09:33.535467+02 1 21 6478630 14226719
1212 2006-03-28 23:09:33.556044+02 1 22 0 0
1213 2006-03-28 23:09:33.575656+02 1 23 0 0
1214 2006-03-28 23:09:33.595203+02 1 24 0 0
1215 2006-03-28 23:09:35.995013+02 1 1 0 0
1216 2006-03-28 23:09:36.014831+02 1 2 0 0
1217 2006-03-28 23:09:36.035206+02 1 3 0 0
1218 2006-03-28 23:09:36.054957+02 1 4 0 0
1219 2006-03-28 23:09:36.074448+02 1 5 0 0
1220 2006-03-28 23:09:36.094459+02 1 6 0 0
1221 2006-03-28 23:09:36.114187+02 1 7 0 0
1222 2006-03-28 23:09:36.134162+02 1 8 0 0
1223 2006-03-28 23:09:36.153924+02 1 9 0 0
1224 2006-03-28 23:09:36.173467+02 1 10 0 0
1225 2006-03-28 23:09:36.192962+02 1 11 0 0
1226 2006-03-28 23:09:36.212584+02 1 12 0 0
1227 2006-03-28 23:09:36.232421+02 1 13 7880337 14338168
1228 2006-03-28 23:09:36.252247+02 1 14 7845454 14268425
1229 2006-03-28 23:09:36.271956+02 1 15 8189578 17433278
1230 2006-03-28 23:09:36.291855+02 1 16 0 0
1231 2006-03-28 23:09:36.311497+02 1 17 0 0
1232 2006-03-28 23:09:36.331351+02 1 18 0 0
1233 2006-03-28 23:09:36.351106+02 1 19 138538669 203617075
1234 2006-03-28 23:09:36.371495+02 1 20 200004048 208829958
1235 2006-03-28 23:09:36.391472+02 1 21 6478630 14226719
1236 2006-03-28 23:09:36.411218+02 1 22 0 0
1237 2006-03-28 23:09:36.432314+02 1 23 0 0
1238 2006-03-28 23:09:36.452165+02 1 24 0 0
1239 2006-03-28 23:15:40.752379+02 1 1 0 0
1240 2006-03-28 23:15:40.772684+02 1 2 0 0
1241 2006-03-28 23:15:40.792228+02 1 3 0 0
1242 2006-03-28 23:15:40.811814+02 1 4 0 0
1243 2006-03-28 23:15:40.83156+02 1 5 0 0
1244 2006-03-28 23:15:40.851352+02 1 6 0 0
1245 2006-03-28 23:15:40.870986+02 1 7 0 0
1246 2006-03-28 23:15:40.890991+02 1 8 0 0
1247 2006-03-28 23:15:40.911205+02 1 9 0 0
1248 2006-03-28 23:15:40.931349+02 1 10 0 0
1249 2006-03-28 23:15:40.951733+02 1 11 0 0
1250 2006-03-28 23:15:40.971545+02 1 12 0 0
1251 2006-03-28 23:15:40.991322+02 1 13 7911314 14387025
1252 2006-03-28 23:15:41.010894+02 1 14 7871637 14313012
1253 2006-03-28 23:15:41.031336+02 1 15 8219073 17479349
1254 2006-03-28 23:15:41.051693+02 1 16 0 0
1255 2006-03-28 23:15:41.071363+02 1 17 0 0
1256 2006-03-28 23:15:41.091194+02 1 18 0 0
1257 2006-03-28 23:15:41.111185+02 1 19 138562273 203670334
1258 2006-03-28 23:15:41.131322+02 1 20 200037822 208897207
1259 2006-03-28 23:15:41.15099+02 1 21 6502475 14279258
1260 2006-03-28 23:15:41.171033+02 1 22 0 0
1261 2006-03-28 23:15:41.190836+02 1 23 0 0
1262 2006-03-28 23:15:41.210909+02 1 24 0 0
1263 2006-03-28 23:16:18.461384+02 1 1 0 0
1264 2006-03-28 23:16:18.481697+02 1 2 0 0
1265 2006-03-28 23:16:18.501411+02 1 3 0 0
1266 2006-03-28 23:16:18.521355+02 1 4 0 0
1267 2006-03-28 23:16:18.541475+02 1 5 0 0
1268 2006-03-28 23:16:18.561151+02 1 6 0 0
1269 2006-03-28 23:16:18.581281+02 1 7 0 0
1270 2006-03-28 23:16:18.601048+02 1 8 0 0
1271 2006-03-28 23:16:18.621418+02 1 9 0 0
1272 2006-03-28 23:16:18.641084+02 1 10 0 0
1273 2006-03-28 23:16:18.660893+02 1 11 0 0
1274 2006-03-28 23:16:18.680749+02 1 12 0 0
1275 2006-03-28 23:16:18.700982+02 1 13 7914272 14391758
1276 2006-03-28 23:16:18.720543+02 1 14 7874595 14317587
1277 2006-03-28 23:16:18.740221+02 1 15 8221649 17484018
1278 2006-03-28 23:16:18.760369+02 1 16 0 0
1279 2006-03-28 23:16:18.780054+02 1 17 0 0
1280 2006-03-28 23:16:18.800943+02 1 18 0 0
1281 2006-03-28 23:16:18.820712+02 1 19 138564103 203674931
1282 2006-03-28 23:16:18.84036+02 1 20 200041217 208903898
1283 2006-03-28 23:16:18.860027+02 1 21 6506271 14285384
1284 2006-03-28 23:16:18.87964+02 1 22 0 0
1285 2006-03-28 23:16:18.899632+02 1 23 0 0
1286 2006-03-28 23:16:18.919771+02 1 24 0 0
1287 2006-03-29 14:21:06.538631+02 1 1 0 0
1288 2006-03-29 14:21:06.566347+02 1 2 0 0
1289 2006-03-29 14:21:06.586281+02 1 3 0 0
1290 2006-03-29 14:21:06.606101+02 1 4 0 0
1291 2006-03-29 14:21:06.626253+02 1 5 0 0
1292 2006-03-29 14:21:06.646471+02 1 6 0 0
1293 2006-03-29 14:21:06.666186+02 1 7 0 0
1294 2006-03-29 14:21:06.685778+02 1 8 0 0
1295 2006-03-29 14:21:06.705397+02 1 9 0 0
1296 2006-03-29 14:21:06.725104+02 1 10 0 0
1297 2006-03-29 14:21:06.745612+02 1 11 0 0
1298 2006-03-29 14:21:06.765703+02 1 12 0 0
1299 2006-03-29 14:21:06.785214+02 1 13 11913823 21156032
1300 2006-03-29 14:21:06.805512+02 1 14 11834383 21035751
1301 2006-03-29 14:21:06.825285+02 1 15 12216402 24218350
1302 2006-03-29 14:21:06.845644+02 1 16 0 0
1303 2006-03-29 14:21:06.865666+02 1 17 0 0
1304 2006-03-29 14:21:06.885942+02 1 18 0 0
1305 2006-03-29 14:21:06.905781+02 1 19 142415383 211673321
1306 2006-03-29 14:21:06.926271+02 1 20 205266368 218989817
1307 2006-03-29 14:21:06.946227+02 1 21 10315756 22231663
1308 2006-03-29 14:21:06.966297+02 1 22 0 0
1309 2006-03-29 14:21:06.985762+02 1 23 0 0
1310 2006-03-29 14:21:07.005733+02 1 24 0 0
1315 -- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres
1318 COPY portnames (switchtype, port, description) FROM stdin;
1319 blackdiamond 1001 BD6808/G8Xi-Port 1:1
1320 blackdiamond 1002 BD6808/G8Xi-Port 1:2
1321 blackdiamond 1003 BD6808/G8Xi-Port 1:3
1322 blackdiamond 1004 BD6808/G8Xi-Port 1:4
1323 blackdiamond 1005 BD6808/G8Xi-Port 1:5
1324 blackdiamond 1006 BD6808/G8Xi-Port 1:6
1325 blackdiamond 1007 BD6808/G8Xi-Port 1:7
1326 blackdiamond 4001 BD6808/G16X3-Port 4:1
1327 blackdiamond 4002 BD6808/G16X3-Port 4:2
1328 blackdiamond 4003 BD6808/G16X3-Port 4:3
1329 blackdiamond 4004 BD6808/G16X3-Port 4:4
1330 blackdiamond 4005 BD6808/G16X3-Port 4:5
1331 blackdiamond 4006 BD6808/G16X3-Port 4:6
1332 blackdiamond 4007 BD6808/G16X3-Port 4:7
1333 blackdiamond 4008 BD6808/G16X3-Port 4:8
1334 blackdiamond 4009 BD6808/G16X3-Port 4:9
1335 blackdiamond 4010 BD6808/G16X3-Port 4:10
1336 blackdiamond 4011 BD6808/G16X3-Port 4:11
1337 blackdiamond 4012 BD6808/G16X3-Port 4:12
1338 blackdiamond 4013 BD6808/G16X3-Port 4:13
1339 blackdiamond 4014 BD6808/G16X3-Port 4:14
1340 blackdiamond 4015 BD6808/G16X3-Port 4:15
1341 blackdiamond 4016 BD6808/G16X3-Port 4:16
1342 blackdiamond 5001 BD6808/G24T3-Port 5:1
1343 blackdiamond 5002 BD6808/G24T3-Port 5:2
1344 blackdiamond 5003 BD6808/G24T3-Port 5:3
1345 blackdiamond 5004 BD6808/G24T3-Port 5:4
1346 blackdiamond 5005 BD6808/G24T3-Port 5:5
1347 blackdiamond 5006 BD6808/G24T3-Port 5:6
1348 blackdiamond 5007 BD6808/G24T3-Port 5:7
1349 blackdiamond 5008 BD6808/G24T3-Port 5:8
1350 blackdiamond 5009 BD6808/G24T3-Port 5:9
1351 blackdiamond 5010 BD6808/G24T3-Port 5:10
1352 blackdiamond 5011 BD6808/G24T3-Port 5:11
1353 blackdiamond 5012 BD6808/G24T3-Port 5:12
1354 blackdiamond 5013 BD6808/G24T3-Port 5:13
1355 blackdiamond 5014 BD6808/G24T3-Port 5:14
1356 blackdiamond 5015 BD6808/G24T3-Port 5:15
1357 blackdiamond 5016 BD6808/G24T3-Port 5:16
1358 blackdiamond 5017 BD6808/G24T3-Port 5:17
1359 blackdiamond 5018 BD6808/G24T3-Port 5:18
1360 blackdiamond 5019 BD6808/G24T3-Port 5:19
1361 blackdiamond 5020 BD6808/G24T3-Port 5:20
1362 blackdiamond 5021 BD6808/G24T3-Port 5:21
1363 blackdiamond 5022 BD6808/G24T3-Port 5:22
1364 blackdiamond 5023 BD6808/G24T3-Port 5:23
1365 blackdiamond 5024 BD6808/G24T3-Port 5:24
1366 blackdiamond 6001 BD6808/F48Ti-Port 6:1
1367 blackdiamond 6002 BD6808/F48Ti-Port 6:2
1368 blackdiamond 6003 BD6808/F48Ti-Port 6:3
1369 blackdiamond 6004 BD6808/F48Ti-Port 6:4
1370 blackdiamond 6005 BD6808/F48Ti-Port 6:5
1371 blackdiamond 6006 BD6808/F48Ti-Port 6:6
1372 blackdiamond 6007 BD6808/F48Ti-Port 6:7
1373 blackdiamond 6008 BD6808/F48Ti-Port 6:8
1374 blackdiamond 6009 BD6808/F48Ti-Port 6:9
1375 blackdiamond 6010 BD6808/F48Ti-Port 6:10
1376 blackdiamond 6011 BD6808/F48Ti-Port 6:11
1377 blackdiamond 6012 BD6808/F48Ti-Port 6:12
1378 blackdiamond 6013 BD6808/F48Ti-Port 6:13
1379 blackdiamond 6014 BD6808/F48Ti-Port 6:14
1380 blackdiamond 6015 BD6808/F48Ti-Port 6:15
1381 blackdiamond 6016 BD6808/F48Ti-Port 6:16
1382 blackdiamond 6017 BD6808/F48Ti-Port 6:17
1383 blackdiamond 6018 BD6808/F48Ti-Port 6:18
1384 blackdiamond 6019 BD6808/F48Ti-Port 6:19
1385 blackdiamond 6020 BD6808/F48Ti-Port 6:20
1386 blackdiamond 6021 BD6808/F48Ti-Port 6:21
1387 blackdiamond 6022 BD6808/F48Ti-Port 6:22
1388 blackdiamond 6023 BD6808/F48Ti-Port 6:23
1389 blackdiamond 6024 BD6808/F48Ti-Port 6:24
1390 blackdiamond 6025 BD6808/F48Ti-Port 6:25
1391 blackdiamond 6026 BD6808/F48Ti-Port 6:26
1392 blackdiamond 6027 BD6808/F48Ti-Port 6:27
1393 blackdiamond 6028 BD6808/F48Ti-Port 6:28
1394 blackdiamond 6029 BD6808/F48Ti-Port 6:29
1395 blackdiamond 6030 BD6808/F48Ti-Port 6:30
1396 blackdiamond 6031 BD6808/F48Ti-Port 6:31
1397 blackdiamond 6032 BD6808/F48Ti-Port 6:32
1398 blackdiamond 6033 BD6808/F48Ti-Port 6:33
1399 blackdiamond 6034 BD6808/F48Ti-Port 6:34
1400 blackdiamond 6035 BD6808/F48Ti-Port 6:35
1401 blackdiamond 6036 BD6808/F48Ti-Port 6:36
1402 blackdiamond 6037 BD6808/F48Ti-Port 6:37
1403 blackdiamond 6038 BD6808/F48Ti-Port 6:38
1404 blackdiamond 6039 BD6808/F48Ti-Port 6:39
1405 blackdiamond 6040 BD6808/F48Ti-Port 6:40
1406 blackdiamond 6041 BD6808/F48Ti-Port 6:41
1407 blackdiamond 6042 BD6808/F48Ti-Port 6:42
1408 blackdiamond 6043 BD6808/F48Ti-Port 6:43
1409 blackdiamond 6044 BD6808/F48Ti-Port 6:44
1410 blackdiamond 6045 BD6808/F48Ti-Port 6:45
1411 blackdiamond 6046 BD6808/F48Ti-Port 6:46
1412 blackdiamond 6047 BD6808/F48Ti-Port 6:47
1413 blackdiamond 6048 BD6808/F48Ti-Port 6:48
1414 cisco6509 1 GigabitEthernet1/1
1415 cisco6509 2 GigabitEthernet1/2
1416 cisco6509 3 GigabitEthernet1/3
1417 cisco6509 4 GigabitEthernet1/4
1418 cisco6509 5 GigabitEthernet1/5
1419 cisco6509 6 GigabitEthernet1/6
1420 cisco6509 7 GigabitEthernet1/7
1421 cisco6509 8 GigabitEthernet1/8
1422 cisco6509 9 GigabitEthernet1/9
1423 cisco6509 10 GigabitEthernet1/10
1424 cisco6509 11 GigabitEthernet1/11
1425 cisco6509 12 GigabitEthernet1/12
1426 cisco6509 13 GigabitEthernet1/13
1427 cisco6509 14 GigabitEthernet1/14
1428 cisco6509 15 GigabitEthernet1/15
1429 cisco6509 16 GigabitEthernet1/16
1430 cisco6509 17 GigabitEthernet1/17
1431 cisco6509 18 GigabitEthernet1/18
1432 cisco6509 19 GigabitEthernet1/19
1433 cisco6509 20 GigabitEthernet1/20
1434 cisco6509 21 GigabitEthernet1/21
1435 cisco6509 22 GigabitEthernet1/22
1436 cisco6509 23 GigabitEthernet1/23
1437 cisco6509 24 GigabitEthernet1/24
1438 cisco6509 25 GigabitEthernet1/25
1439 cisco6509 26 GigabitEthernet1/26
1440 cisco6509 27 GigabitEthernet1/27
1441 cisco6509 28 GigabitEthernet1/28
1442 cisco6509 29 GigabitEthernet1/29
1443 cisco6509 30 GigabitEthernet1/30
1444 cisco6509 31 GigabitEthernet1/31
1445 cisco6509 32 GigabitEthernet1/32
1446 cisco6509 33 GigabitEthernet1/33
1447 cisco6509 34 GigabitEthernet1/34
1448 cisco6509 35 GigabitEthernet1/35
1449 cisco6509 36 GigabitEthernet1/36
1450 cisco6509 37 GigabitEthernet1/37
1451 cisco6509 38 GigabitEthernet1/38
1452 cisco6509 39 GigabitEthernet1/39
1453 cisco6509 40 GigabitEthernet1/40
1454 cisco6509 41 GigabitEthernet1/41
1455 cisco6509 42 GigabitEthernet1/42
1456 cisco6509 43 GigabitEthernet1/43
1457 cisco6509 44 GigabitEthernet1/44
1458 cisco6509 45 GigabitEthernet1/45
1459 cisco6509 46 GigabitEthernet1/46
1460 cisco6509 47 GigabitEthernet1/47
1461 cisco6509 48 GigabitEthernet1/48
1462 cisco6509 49 GigabitEthernet2/1
1463 cisco6509 50 GigabitEthernet2/2
1464 cisco6509 51 GigabitEthernet2/3
1465 cisco6509 52 GigabitEthernet2/4
1466 cisco6509 53 GigabitEthernet2/5
1467 cisco6509 54 GigabitEthernet2/6
1468 cisco6509 55 GigabitEthernet2/7
1469 cisco6509 56 GigabitEthernet2/8
1470 cisco6509 57 GigabitEthernet2/9
1471 cisco6509 58 GigabitEthernet2/10
1472 cisco6509 59 GigabitEthernet2/11
1473 cisco6509 60 GigabitEthernet2/12
1474 cisco6509 61 GigabitEthernet2/13
1475 cisco6509 62 GigabitEthernet2/14
1476 cisco6509 63 GigabitEthernet2/15
1477 cisco6509 64 GigabitEthernet2/16
1478 cisco6509 65 FastEthernet4/1
1479 cisco6509 66 FastEthernet4/2
1480 cisco6509 67 FastEthernet4/3
1481 cisco6509 68 FastEthernet4/4
1482 cisco6509 69 FastEthernet4/5
1483 cisco6509 70 FastEthernet4/6
1484 cisco6509 71 FastEthernet4/7
1485 cisco6509 72 FastEthernet4/8
1486 cisco6509 73 FastEthernet4/9
1487 cisco6509 74 FastEthernet4/10
1488 cisco6509 75 FastEthernet4/11
1489 cisco6509 76 FastEthernet4/12
1490 cisco6509 77 FastEthernet4/13
1491 cisco6509 78 FastEthernet4/14
1492 cisco6509 79 FastEthernet4/15
1493 cisco6509 80 FastEthernet4/16
1494 cisco6509 81 FastEthernet4/17
1495 cisco6509 82 FastEthernet4/18
1496 cisco6509 83 FastEthernet4/19
1497 cisco6509 84 FastEthernet4/20
1498 cisco6509 85 FastEthernet4/21
1499 cisco6509 86 FastEthernet4/22
1500 cisco6509 87 FastEthernet4/23
1501 cisco6509 88 FastEthernet4/24
1502 cisco6509 89 FastEthernet4/25
1503 cisco6509 90 FastEthernet4/26
1504 cisco6509 91 FastEthernet4/27
1505 cisco6509 92 FastEthernet4/28
1506 cisco6509 93 FastEthernet4/29
1507 cisco6509 94 FastEthernet4/30
1508 cisco6509 95 FastEthernet4/31
1509 cisco6509 96 FastEthernet4/32
1510 cisco6509 97 FastEthernet4/33
1511 cisco6509 98 FastEthernet4/34
1512 cisco6509 99 FastEthernet4/35
1513 cisco6509 100 FastEthernet4/36
1514 cisco6509 101 FastEthernet4/37
1515 cisco6509 102 FastEthernet4/38
1516 cisco6509 103 FastEthernet4/39
1517 cisco6509 104 FastEthernet4/40
1518 cisco6509 105 FastEthernet4/41
1519 cisco6509 106 FastEthernet4/42
1520 cisco6509 107 FastEthernet4/43
1521 cisco6509 108 FastEthernet4/44
1522 cisco6509 109 FastEthernet4/45
1523 cisco6509 110 FastEthernet4/46
1524 cisco6509 111 FastEthernet4/47
1525 cisco6509 112 FastEthernet4/48
1526 cisco6509 113 GigabitEthernet5/1
1527 cisco6509 114 GigabitEthernet5/2
1528 cisco6509 115 GigabitEthernet8/1
1529 cisco6509 116 GigabitEthernet8/2
1530 cisco6509 117 GigabitEthernet8/3
1531 cisco6509 118 GigabitEthernet8/4
1532 cisco6509 119 GigabitEthernet8/5
1533 cisco6509 120 GigabitEthernet8/6
1534 cisco6509 121 GigabitEthernet8/7
1535 cisco6509 122 GigabitEthernet8/8
1536 cisco6509 123 GigabitEthernet8/9
1541 -- Data for Name: squeue; Type: TABLE DATA; Schema: public; Owner: nms
1544 COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin;
1549 -- Data for Name: switches; Type: TABLE DATA; Schema: public; Owner: postgres
1552 COPY switches (switch, ip, sysname, switchtype, last_updated, locked, priority, poll_frequency, community) FROM stdin;
1553 210 81.162.239.10 noc cisco6509 2005-03-27 13:21:26.109659+02 f 5 00:00:20 removed
1554 1 62.148.36.20 zorro cisco6509 2006-03-29 14:21:06.525009+02 f 5 00:01:00 tg06
1559 -- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: postgres
1562 COPY switchtypes (switchtype, ports, wide_counters) FROM stdin;
1563 blackdiamond 1001-1007,4001-4016,5001-5024,6001-6048 f
1574 -- Data for Name: temppoll; Type: TABLE DATA; Schema: public; Owner: postgres
1577 COPY temppoll (id, "time", switch, "temp") FROM stdin;
1582 -- Name: cpuloadpoll_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace:
1585 ALTER TABLE ONLY cpuloadpoll
1586 ADD CONSTRAINT cpuloadpoll_pkey PRIMARY KEY (id);
1590 -- Name: public; Type: ACL; Schema: -; Owner: postgres
1593 REVOKE ALL ON SCHEMA public FROM PUBLIC;
1594 REVOKE ALL ON SCHEMA public FROM postgres;
1595 GRANT ALL ON SCHEMA public TO postgres;
1596 GRANT ALL ON SCHEMA public TO PUBLIC;
1600 -- Name: cpuloadpoll; Type: ACL; Schema: public; Owner: sesse
1603 REVOKE ALL ON TABLE cpuloadpoll FROM PUBLIC;
1604 REVOKE ALL ON TABLE cpuloadpoll FROM sesse;
1605 GRANT ALL ON TABLE cpuloadpoll TO sesse;
1606 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll TO nms;
1610 -- Name: cpuloadpoll_id_seq; Type: ACL; Schema: public; Owner: sesse
1613 REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM PUBLIC;
1614 REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM sesse;
1615 GRANT ALL ON TABLE cpuloadpoll_id_seq TO sesse;
1616 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll_id_seq TO nms;
1620 -- Name: polls; Type: ACL; Schema: public; Owner: postgres
1623 REVOKE ALL ON TABLE polls FROM PUBLIC;
1624 REVOKE ALL ON TABLE polls FROM postgres;
1625 GRANT ALL ON TABLE polls TO postgres;
1626 GRANT INSERT ON TABLE polls TO nms;
1630 -- Name: switches; Type: ACL; Schema: public; Owner: postgres
1633 REVOKE ALL ON TABLE switches FROM PUBLIC;
1634 REVOKE ALL ON TABLE switches FROM postgres;
1635 GRANT ALL ON TABLE switches TO postgres;
1636 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE switches TO nms;
1640 -- Name: switchtypes; Type: ACL; Schema: public; Owner: postgres
1643 REVOKE ALL ON TABLE switchtypes FROM PUBLIC;
1644 REVOKE ALL ON TABLE switchtypes FROM postgres;
1645 GRANT ALL ON TABLE switchtypes TO postgres;
1646 GRANT SELECT ON TABLE switchtypes TO nms;
1650 -- PostgreSQL database dump complete