git.sesse.net Git - nms/blob - sql/nms.sql

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