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     errors_in bigint NOT NULL,
 277     errors_out bigint NOT NULL
 278 );
 279 ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;
 280
 281
 282 ALTER TABLE public.polls OWNER TO postgres;
 283
 284 --
 285 -- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 286 --
 287
 288 CREATE SEQUENCE polls_poll_seq
 289     START WITH 1
 290     INCREMENT BY 1
 291     NO MAXVALUE
 292     NO MINVALUE
 293     CACHE 1;
 294
 295
 296 ALTER TABLE public.polls_poll_seq OWNER TO postgres;
 297
 298 --
 299 -- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 300 --
 301
 302 SELECT pg_catalog.setval('polls_poll_seq', 1, false);
 303
 304
 305 SET default_with_oids = true;
 306
 307 --
 308 -- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 309 --
 310
 311 CREATE TABLE portnames (
 312     switchtype character varying NOT NULL,
 313     port integer NOT NULL,
 314     description character varying NOT NULL
 315 );
 316
 317
 318 ALTER TABLE public.portnames OWNER TO postgres;
 319
 320 --
 321 -- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace:
 322 --
 323
 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,
 329     addr inet,
 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
 340 );
 341
 342
 343 ALTER TABLE public.squeue OWNER TO nms;
 344
 345 --
 346 -- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 347 --
 348
 349 CREATE SEQUENCE squeue_group_sequence
 350     INCREMENT BY 1
 351     NO MAXVALUE
 352     NO MINVALUE
 353     CACHE 1;
 354
 355
 356 ALTER TABLE public.squeue_group_sequence OWNER TO nms;
 357
 358 --
 359 -- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 360 --
 361
 362 SELECT pg_catalog.setval('squeue_group_sequence', 21, true);
 363
 364
 365 --
 366 -- Name: squeue_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 367 --
 368
 369 CREATE SEQUENCE squeue_sequence
 370     INCREMENT BY 1
 371     NO MAXVALUE
 372     NO MINVALUE
 373     CACHE 1;
 374
 375
 376 ALTER TABLE public.squeue_sequence OWNER TO nms;
 377
 378 --
 379 -- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 380 --
 381
 382 SELECT pg_catalog.setval('squeue_sequence', 901, true);
 383
 384
 385 --
 386 -- Name: stemppoll_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 387 --
 388
 389 CREATE SEQUENCE stemppoll_sequence
 390     INCREMENT BY 1
 391     NO MAXVALUE
 392     NO MINVALUE
 393     CACHE 1;
 394
 395
 396 ALTER TABLE public.stemppoll_sequence OWNER TO nms;
 397
 398 --
 399 -- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 400 --
 401
 402 SELECT pg_catalog.setval('stemppoll_sequence', 182534, true);
 403
 404
 405 SET default_with_oids = false;
 406
 407 --
 408 -- Name: switches; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 409 --
 410
 411 CREATE TABLE switches (
 412     switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL,
 413     ip inet 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
 421 );
 422
 423
 424 ALTER TABLE public.switches OWNER TO postgres;
 425
 426 --
 427 -- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 428 --
 429
 430 CREATE SEQUENCE switches_switch_seq
 431     INCREMENT BY 1
 432     NO MAXVALUE
 433     NO MINVALUE
 434     CACHE 1;
 435
 436
 437 ALTER TABLE public.switches_switch_seq OWNER TO postgres;
 438
 439 --
 440 -- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 441 --
 442
 443 SELECT pg_catalog.setval('switches_switch_seq', 225, true);
 444
 445
 446 --
 447 -- Name: switchtypes; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 448 --
 449
 450 CREATE TABLE switchtypes (
 451     switchtype character varying NOT NULL,
 452     ports character varying NOT NULL,
 453     wide_counters boolean DEFAULT false NOT NULL
 454 );
 455
 456
 457 ALTER TABLE public.switchtypes OWNER TO postgres;
 458
 459 SET default_with_oids = true;
 460
 461 --
 462 -- Name: temppoll; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 463 --
 464
 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
 470 );
 471
 472
 473 ALTER TABLE public.temppoll OWNER TO postgres;
 474
 475 --
 476 -- Data for Name: cpuloadpoll; Type: TABLE DATA; Schema: public; Owner: sesse
 477 --
 478
 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
 488 \.
 489
 490
 491 --
 492 -- Data for Name: dhcp; Type: TABLE DATA; Schema: public; Owner: sesse
 493 --
 494
 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
 711 \.
 712
 713
 714 --
 715 -- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: postgres
 716 --
 717
 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)
 940 \.
 941
 942
 943 --
 944 -- Data for Name: polls; Type: TABLE DATA; Schema: public; Owner: postgres
 945 --
 946
 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
1311 \.
1312
1313
1314 --
1315 -- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres
1316 --
1317
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
1537 \.
1538
1539
1540 --
1541 -- Data for Name: squeue; Type: TABLE DATA; Schema: public; Owner: nms
1542 --
1543
1544 COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin;
1545 \.
1546
1547
1548 --
1549 -- Data for Name: switches; Type: TABLE DATA; Schema: public; Owner: postgres
1550 --
1551
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
1555 \.
1556
1557
1558 --
1559 -- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: postgres
1560 --
1561
1562 COPY switchtypes (switchtype, ports, wide_counters) FROM stdin;
1563 blackdiamond    1001-1007,4001-4016,5001-5024,6001-6048 f
1564 es3024  1-25    f
1565 summit400       1-50    f
1566 cisco3550       1-50    f
1567 summit7i        1-32    f
1568 summit48        1-50    f
1569 cisco6509       1-24    t
1570 \.
1571
1572
1573 --
1574 -- Data for Name: temppoll; Type: TABLE DATA; Schema: public; Owner: postgres
1575 --
1576
1577 COPY temppoll (id, "time", switch, "temp") FROM stdin;
1578 \.
1579
1580
1581 --
1582 -- Name: cpuloadpoll_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace:
1583 --
1584
1585 ALTER TABLE ONLY cpuloadpoll
1586     ADD CONSTRAINT cpuloadpoll_pkey PRIMARY KEY (id);
1587
1588
1589 --
1590 -- Name: public; Type: ACL; Schema: -; Owner: postgres
1591 --
1592
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;
1597
1598
1599 --
1600 -- Name: cpuloadpoll; Type: ACL; Schema: public; Owner: sesse
1601 --
1602
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;
1607
1608
1609 --
1610 -- Name: cpuloadpoll_id_seq; Type: ACL; Schema: public; Owner: sesse
1611 --
1612
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;
1617
1618
1619 --
1620 -- Name: polls; Type: ACL; Schema: public; Owner: postgres
1621 --
1622
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;
1627
1628
1629 --
1630 -- Name: switches; Type: ACL; Schema: public; Owner: postgres
1631 --
1632
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;
1637
1638
1639 --
1640 -- Name: switchtypes; Type: ACL; Schema: public; Owner: postgres
1641 --
1642
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;
1647
1648
1649 --
1650 -- PostgreSQL database dump complete
1651 --
1652