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
 239
 240 --
 241 -- Name: dhcp; Type: TABLE; Schema: public; Owner: sesse; Tablespace:
 242 --
 243
 244 CREATE TABLE dhcp (
 245     switch integer NOT NULL,
 246     network cidr NOT NULL,
 247     last_ack timestamp without time zone
 248 );
 249
 250
 251 ALTER TABLE public.dhcp OWNER TO sesse;
 252
 253 --
 254 -- Name: placements; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 255 --
 256
 257 CREATE TABLE placements (
 258     switch integer NOT NULL,
 259     placement box NOT NULL
 260 );
 261
 262
 263 ALTER TABLE public.placements OWNER TO postgres;
 264
 265 --
 266 -- Name: polls; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 267 --
 268
 269 CREATE TABLE polls (
 270     "time" timestamp with time zone NOT NULL,
 271     switch integer NOT NULL,
 272     port integer NOT NULL,
 273     bytes_in bigint NOT NULL,
 274     bytes_out bigint NOT NULL,
 275     errors_in bigint NOT NULL,
 276     errors_out bigint NOT NULL
 277 );
 278 ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;
 279
 280
 281 ALTER TABLE public.polls OWNER TO postgres;
 282
 283 --
 284 -- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 285 --
 286
 287 CREATE SEQUENCE polls_poll_seq
 288     START WITH 1
 289     INCREMENT BY 1
 290     NO MAXVALUE
 291     NO MINVALUE
 292     CACHE 1;
 293
 294
 295 ALTER TABLE public.polls_poll_seq OWNER TO postgres;
 296
 297 --
 298 -- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 299 --
 300
 301 SELECT pg_catalog.setval('polls_poll_seq', 1, false);
 302
 303
 304 SET default_with_oids = true;
 305
 306 --
 307 -- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 308 --
 309
 310 CREATE TABLE portnames (
 311     switchtype character varying NOT NULL,
 312     port integer NOT NULL,
 313     description character varying NOT NULL
 314 );
 315
 316
 317 ALTER TABLE public.portnames OWNER TO postgres;
 318
 319 --
 320 -- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace:
 321 --
 322
 323 CREATE TABLE squeue (
 324     id integer DEFAULT nextval(('squeue_sequence'::text)::regclass) NOT NULL,
 325     gid integer NOT NULL,
 326     added timestamp with time zone NOT NULL,
 327     updated timestamp with time zone,
 328     addr inet,
 329     cmd character varying NOT NULL,
 330     locked boolean DEFAULT false NOT NULL,
 331     processed boolean DEFAULT false NOT NULL,
 332     disabled boolean DEFAULT false NOT NULL,
 333     priority integer DEFAULT 3,
 334     sysname character varying NOT NULL,
 335     author character varying NOT NULL,
 336     result character varying,
 337     delay timestamp with time zone,
 338     delaytime interval DEFAULT '00:01:00'::interval
 339 );
 340
 341
 342 ALTER TABLE public.squeue OWNER TO nms;
 343
 344 --
 345 -- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 346 --
 347
 348 CREATE SEQUENCE squeue_group_sequence
 349     INCREMENT BY 1
 350     NO MAXVALUE
 351     NO MINVALUE
 352     CACHE 1;
 353
 354
 355 ALTER TABLE public.squeue_group_sequence OWNER TO nms;
 356
 357 --
 358 -- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 359 --
 360
 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 --
 475 -- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres
 476 --
 477
 478 COPY portnames (switchtype, port, description) FROM stdin;
 479 blackdiamond    1001    BD6808/G8Xi-Port 1:1
 480 blackdiamond    1002    BD6808/G8Xi-Port 1:2
 481 blackdiamond    1003    BD6808/G8Xi-Port 1:3
 482 blackdiamond    1004    BD6808/G8Xi-Port 1:4
 483 blackdiamond    1005    BD6808/G8Xi-Port 1:5
 484 blackdiamond    1006    BD6808/G8Xi-Port 1:6
 485 blackdiamond    1007    BD6808/G8Xi-Port 1:7
 486 blackdiamond    4001    BD6808/G16X3-Port 4:1
 487 blackdiamond    4002    BD6808/G16X3-Port 4:2
 488 blackdiamond    4003    BD6808/G16X3-Port 4:3
 489 blackdiamond    4004    BD6808/G16X3-Port 4:4
 490 blackdiamond    4005    BD6808/G16X3-Port 4:5
 491 blackdiamond    4006    BD6808/G16X3-Port 4:6
 492 blackdiamond    4007    BD6808/G16X3-Port 4:7
 493 blackdiamond    4008    BD6808/G16X3-Port 4:8
 494 blackdiamond    4009    BD6808/G16X3-Port 4:9
 495 blackdiamond    4010    BD6808/G16X3-Port 4:10
 496 blackdiamond    4011    BD6808/G16X3-Port 4:11
 497 blackdiamond    4012    BD6808/G16X3-Port 4:12
 498 blackdiamond    4013    BD6808/G16X3-Port 4:13
 499 blackdiamond    4014    BD6808/G16X3-Port 4:14
 500 blackdiamond    4015    BD6808/G16X3-Port 4:15
 501 blackdiamond    4016    BD6808/G16X3-Port 4:16
 502 blackdiamond    5001    BD6808/G24T3-Port 5:1
 503 blackdiamond    5002    BD6808/G24T3-Port 5:2
 504 blackdiamond    5003    BD6808/G24T3-Port 5:3
 505 blackdiamond    5004    BD6808/G24T3-Port 5:4
 506 blackdiamond    5005    BD6808/G24T3-Port 5:5
 507 blackdiamond    5006    BD6808/G24T3-Port 5:6
 508 blackdiamond    5007    BD6808/G24T3-Port 5:7
 509 blackdiamond    5008    BD6808/G24T3-Port 5:8
 510 blackdiamond    5009    BD6808/G24T3-Port 5:9
 511 blackdiamond    5010    BD6808/G24T3-Port 5:10
 512 blackdiamond    5011    BD6808/G24T3-Port 5:11
 513 blackdiamond    5012    BD6808/G24T3-Port 5:12
 514 blackdiamond    5013    BD6808/G24T3-Port 5:13
 515 blackdiamond    5014    BD6808/G24T3-Port 5:14
 516 blackdiamond    5015    BD6808/G24T3-Port 5:15
 517 blackdiamond    5016    BD6808/G24T3-Port 5:16
 518 blackdiamond    5017    BD6808/G24T3-Port 5:17
 519 blackdiamond    5018    BD6808/G24T3-Port 5:18
 520 blackdiamond    5019    BD6808/G24T3-Port 5:19
 521 blackdiamond    5020    BD6808/G24T3-Port 5:20
 522 blackdiamond    5021    BD6808/G24T3-Port 5:21
 523 blackdiamond    5022    BD6808/G24T3-Port 5:22
 524 blackdiamond    5023    BD6808/G24T3-Port 5:23
 525 blackdiamond    5024    BD6808/G24T3-Port 5:24
 526 blackdiamond    6001    BD6808/F48Ti-Port 6:1
 527 blackdiamond    6002    BD6808/F48Ti-Port 6:2
 528 blackdiamond    6003    BD6808/F48Ti-Port 6:3
 529 blackdiamond    6004    BD6808/F48Ti-Port 6:4
 530 blackdiamond    6005    BD6808/F48Ti-Port 6:5
 531 blackdiamond    6006    BD6808/F48Ti-Port 6:6
 532 blackdiamond    6007    BD6808/F48Ti-Port 6:7
 533 blackdiamond    6008    BD6808/F48Ti-Port 6:8
 534 blackdiamond    6009    BD6808/F48Ti-Port 6:9
 535 blackdiamond    6010    BD6808/F48Ti-Port 6:10
 536 blackdiamond    6011    BD6808/F48Ti-Port 6:11
 537 blackdiamond    6012    BD6808/F48Ti-Port 6:12
 538 blackdiamond    6013    BD6808/F48Ti-Port 6:13
 539 blackdiamond    6014    BD6808/F48Ti-Port 6:14
 540 blackdiamond    6015    BD6808/F48Ti-Port 6:15
 541 blackdiamond    6016    BD6808/F48Ti-Port 6:16
 542 blackdiamond    6017    BD6808/F48Ti-Port 6:17
 543 blackdiamond    6018    BD6808/F48Ti-Port 6:18
 544 blackdiamond    6019    BD6808/F48Ti-Port 6:19
 545 blackdiamond    6020    BD6808/F48Ti-Port 6:20
 546 blackdiamond    6021    BD6808/F48Ti-Port 6:21
 547 blackdiamond    6022    BD6808/F48Ti-Port 6:22
 548 blackdiamond    6023    BD6808/F48Ti-Port 6:23
 549 blackdiamond    6024    BD6808/F48Ti-Port 6:24
 550 blackdiamond    6025    BD6808/F48Ti-Port 6:25
 551 blackdiamond    6026    BD6808/F48Ti-Port 6:26
 552 blackdiamond    6027    BD6808/F48Ti-Port 6:27
 553 blackdiamond    6028    BD6808/F48Ti-Port 6:28
 554 blackdiamond    6029    BD6808/F48Ti-Port 6:29
 555 blackdiamond    6030    BD6808/F48Ti-Port 6:30
 556 blackdiamond    6031    BD6808/F48Ti-Port 6:31
 557 blackdiamond    6032    BD6808/F48Ti-Port 6:32
 558 blackdiamond    6033    BD6808/F48Ti-Port 6:33
 559 blackdiamond    6034    BD6808/F48Ti-Port 6:34
 560 blackdiamond    6035    BD6808/F48Ti-Port 6:35
 561 blackdiamond    6036    BD6808/F48Ti-Port 6:36
 562 blackdiamond    6037    BD6808/F48Ti-Port 6:37
 563 blackdiamond    6038    BD6808/F48Ti-Port 6:38
 564 blackdiamond    6039    BD6808/F48Ti-Port 6:39
 565 blackdiamond    6040    BD6808/F48Ti-Port 6:40
 566 blackdiamond    6041    BD6808/F48Ti-Port 6:41
 567 blackdiamond    6042    BD6808/F48Ti-Port 6:42
 568 blackdiamond    6043    BD6808/F48Ti-Port 6:43
 569 blackdiamond    6044    BD6808/F48Ti-Port 6:44
 570 blackdiamond    6045    BD6808/F48Ti-Port 6:45
 571 blackdiamond    6046    BD6808/F48Ti-Port 6:46
 572 blackdiamond    6047    BD6808/F48Ti-Port 6:47
 573 blackdiamond    6048    BD6808/F48Ti-Port 6:48
 574 cisco6509       1       GigabitEthernet1/1
 575 cisco6509       2       GigabitEthernet1/2
 576 cisco6509       3       GigabitEthernet1/3
 577 cisco6509       4       GigabitEthernet1/4
 578 cisco6509       5       GigabitEthernet1/5
 579 cisco6509       6       GigabitEthernet1/6
 580 cisco6509       7       GigabitEthernet1/7
 581 cisco6509       8       GigabitEthernet1/8
 582 cisco6509       9       GigabitEthernet1/9
 583 cisco6509       10      GigabitEthernet1/10
 584 cisco6509       11      GigabitEthernet1/11
 585 cisco6509       12      GigabitEthernet1/12
 586 cisco6509       13      GigabitEthernet1/13
 587 cisco6509       14      GigabitEthernet1/14
 588 cisco6509       15      GigabitEthernet1/15
 589 cisco6509       16      GigabitEthernet1/16
 590 cisco6509       17      GigabitEthernet1/17
 591 cisco6509       18      GigabitEthernet1/18
 592 cisco6509       19      GigabitEthernet1/19
 593 cisco6509       20      GigabitEthernet1/20
 594 cisco6509       21      GigabitEthernet1/21
 595 cisco6509       22      GigabitEthernet1/22
 596 cisco6509       23      GigabitEthernet1/23
 597 cisco6509       24      GigabitEthernet1/24
 598 cisco6509       25      GigabitEthernet1/25
 599 cisco6509       26      GigabitEthernet1/26
 600 cisco6509       27      GigabitEthernet1/27
 601 cisco6509       28      GigabitEthernet1/28
 602 cisco6509       29      GigabitEthernet1/29
 603 cisco6509       30      GigabitEthernet1/30
 604 cisco6509       31      GigabitEthernet1/31
 605 cisco6509       32      GigabitEthernet1/32
 606 cisco6509       33      GigabitEthernet1/33
 607 cisco6509       34      GigabitEthernet1/34
 608 cisco6509       35      GigabitEthernet1/35
 609 cisco6509       36      GigabitEthernet1/36
 610 cisco6509       37      GigabitEthernet1/37
 611 cisco6509       38      GigabitEthernet1/38
 612 cisco6509       39      GigabitEthernet1/39
 613 cisco6509       40      GigabitEthernet1/40
 614 cisco6509       41      GigabitEthernet1/41
 615 cisco6509       42      GigabitEthernet1/42
 616 cisco6509       43      GigabitEthernet1/43
 617 cisco6509       44      GigabitEthernet1/44
 618 cisco6509       45      GigabitEthernet1/45
 619 cisco6509       46      GigabitEthernet1/46
 620 cisco6509       47      GigabitEthernet1/47
 621 cisco6509       48      GigabitEthernet1/48
 622 cisco6509       49      GigabitEthernet2/1
 623 cisco6509       50      GigabitEthernet2/2
 624 cisco6509       51      GigabitEthernet2/3
 625 cisco6509       52      GigabitEthernet2/4
 626 cisco6509       53      GigabitEthernet2/5
 627 cisco6509       54      GigabitEthernet2/6
 628 cisco6509       55      GigabitEthernet2/7
 629 cisco6509       56      GigabitEthernet2/8
 630 cisco6509       57      GigabitEthernet2/9
 631 cisco6509       58      GigabitEthernet2/10
 632 cisco6509       59      GigabitEthernet2/11
 633 cisco6509       60      GigabitEthernet2/12
 634 cisco6509       61      GigabitEthernet2/13
 635 cisco6509       62      GigabitEthernet2/14
 636 cisco6509       63      GigabitEthernet2/15
 637 cisco6509       64      GigabitEthernet2/16
 638 cisco6509       65      FastEthernet4/1
 639 cisco6509       66      FastEthernet4/2
 640 cisco6509       67      FastEthernet4/3
 641 cisco6509       68      FastEthernet4/4
 642 cisco6509       69      FastEthernet4/5
 643 cisco6509       70      FastEthernet4/6
 644 cisco6509       71      FastEthernet4/7
 645 cisco6509       72      FastEthernet4/8
 646 cisco6509       73      FastEthernet4/9
 647 cisco6509       74      FastEthernet4/10
 648 cisco6509       75      FastEthernet4/11
 649 cisco6509       76      FastEthernet4/12
 650 cisco6509       77      FastEthernet4/13
 651 cisco6509       78      FastEthernet4/14
 652 cisco6509       79      FastEthernet4/15
 653 cisco6509       80      FastEthernet4/16
 654 cisco6509       81      FastEthernet4/17
 655 cisco6509       82      FastEthernet4/18
 656 cisco6509       83      FastEthernet4/19
 657 cisco6509       84      FastEthernet4/20
 658 cisco6509       85      FastEthernet4/21
 659 cisco6509       86      FastEthernet4/22
 660 cisco6509       87      FastEthernet4/23
 661 cisco6509       88      FastEthernet4/24
 662 cisco6509       89      FastEthernet4/25
 663 cisco6509       90      FastEthernet4/26
 664 cisco6509       91      FastEthernet4/27
 665 cisco6509       92      FastEthernet4/28
 666 cisco6509       93      FastEthernet4/29
 667 cisco6509       94      FastEthernet4/30
 668 cisco6509       95      FastEthernet4/31
 669 cisco6509       96      FastEthernet4/32
 670 cisco6509       97      FastEthernet4/33
 671 cisco6509       98      FastEthernet4/34
 672 cisco6509       99      FastEthernet4/35
 673 cisco6509       100     FastEthernet4/36
 674 cisco6509       101     FastEthernet4/37
 675 cisco6509       102     FastEthernet4/38
 676 cisco6509       103     FastEthernet4/39
 677 cisco6509       104     FastEthernet4/40
 678 cisco6509       105     FastEthernet4/41
 679 cisco6509       106     FastEthernet4/42
 680 cisco6509       107     FastEthernet4/43
 681 cisco6509       108     FastEthernet4/44
 682 cisco6509       109     FastEthernet4/45
 683 cisco6509       110     FastEthernet4/46
 684 cisco6509       111     FastEthernet4/47
 685 cisco6509       112     FastEthernet4/48
 686 cisco6509       113     GigabitEthernet5/1
 687 cisco6509       114     GigabitEthernet5/2
 688 cisco6509       115     GigabitEthernet8/1
 689 cisco6509       116     GigabitEthernet8/2
 690 cisco6509       117     GigabitEthernet8/3
 691 cisco6509       118     GigabitEthernet8/4
 692 cisco6509       119     GigabitEthernet8/5
 693 cisco6509       120     GigabitEthernet8/6
 694 cisco6509       121     GigabitEthernet8/7
 695 cisco6509       122     GigabitEthernet8/8
 696 cisco6509       123     GigabitEthernet8/9
 697 \.
 698
 699
 700 --
 701 -- Data for Name: squeue; Type: TABLE DATA; Schema: public; Owner: nms
 702 --
 703
 704 COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin;
 705 \.
 706
 707
 708
 709 COPY switchtypes (switchtype, ports, wide_counters) FROM stdin;
 710 blackdiamond    1001-1007,4001-4016,5001-5024,6001-6048 f
 711 es3024  1-25    f
 712 summit400       1-50    f
 713 cisco3550       1-50    f
 714 summit7i        1-32    f
 715 summit48        1-50    f
 716 cisco6509       1-24    t
 717 \.
 718
 719
 720 --
 721 -- Data for Name: temppoll; Type: TABLE DATA; Schema: public; Owner: postgres
 722 --
 723
 724 COPY temppoll (id, "time", switch, "temp") FROM stdin;
 725 \.
 726
 727
 728 --
 729 -- Name: cpuloadpoll_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace:
 730 --
 731
 732 ALTER TABLE ONLY cpuloadpoll
 733     ADD CONSTRAINT cpuloadpoll_pkey PRIMARY KEY (id);
 734
 735
 736 --
 737 -- Name: public; Type: ACL; Schema: -; Owner: postgres
 738 --
 739
 740 REVOKE ALL ON SCHEMA public FROM PUBLIC;
 741 REVOKE ALL ON SCHEMA public FROM postgres;
 742 GRANT ALL ON SCHEMA public TO postgres;
 743 GRANT ALL ON SCHEMA public TO PUBLIC;
 744
 745
 746 --
 747 -- Name: cpuloadpoll; Type: ACL; Schema: public; Owner: sesse
 748 --
 749
 750 REVOKE ALL ON TABLE cpuloadpoll FROM PUBLIC;
 751 REVOKE ALL ON TABLE cpuloadpoll FROM sesse;
 752 GRANT ALL ON TABLE cpuloadpoll TO sesse;
 753 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll TO nms;
 754
 755
 756 --
 757 -- Name: cpuloadpoll_id_seq; Type: ACL; Schema: public; Owner: sesse
 758 --
 759
 760 REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM PUBLIC;
 761 REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM sesse;
 762 GRANT ALL ON TABLE cpuloadpoll_id_seq TO sesse;
 763 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll_id_seq TO nms;
 764
 765
 766 --
 767 -- Name: polls; Type: ACL; Schema: public; Owner: postgres
 768 --
 769
 770 REVOKE ALL ON TABLE polls FROM PUBLIC;
 771 REVOKE ALL ON TABLE polls FROM postgres;
 772 GRANT ALL ON TABLE polls TO postgres;
 773 GRANT INSERT ON TABLE polls TO nms;
 774
 775
 776 --
 777 -- Name: switches; Type: ACL; Schema: public; Owner: postgres
 778 --
 779
 780 REVOKE ALL ON TABLE switches FROM PUBLIC;
 781 REVOKE ALL ON TABLE switches FROM postgres;
 782 GRANT ALL ON TABLE switches TO postgres;
 783 GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE switches TO nms;
 784
 785
 786 --
 787 -- Name: switchtypes; Type: ACL; Schema: public; Owner: postgres
 788 --
 789
 790 REVOKE ALL ON TABLE switchtypes FROM PUBLIC;
 791 REVOKE ALL ON TABLE switchtypes FROM postgres;
 792 GRANT ALL ON TABLE switchtypes TO postgres;
 793 GRANT SELECT ON TABLE switchtypes TO nms;
 794
 795
 796 --
 797 -- PostgreSQL database dump complete
 798 --
 799