From: Steinar H. Gunderson Date: Wed, 29 Mar 2006 12:26:05 +0000 (+0000) Subject: Actually add the new file, too. X-Git-Url: https://git.sesse.net/?p=nms;a=commitdiff_plain;h=9a9f0ce3aeebc04ff7fd56989ace9a737b0879cf Actually add the new file, too. --- diff --git a/sql/nms.sql b/sql/nms.sql new file mode 100644 index 0000000..12d8244 --- /dev/null +++ b/sql/nms.sql @@ -0,0 +1,1650 @@ +-- +-- PostgreSQL database dump +-- + +SET client_encoding = 'SQL_ASCII'; +SET check_function_bodies = false; +SET client_min_messages = warning; + +-- +-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres +-- + +COMMENT ON SCHEMA public IS 'Standard public schema'; + + +-- +-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: +-- + +CREATE PROCEDURAL LANGUAGE plpgsql; + + +SET search_path = public, pg_catalog; + +-- +-- Name: datarate; Type: TYPE; Schema: public; Owner: sesse +-- + +CREATE TYPE datarate AS ( + switch integer, + port integer, + bytes_in double precision, + bytes_out double precision +); + + +ALTER TYPE public.datarate OWNER TO sesse; + +-- +-- Name: get_current_datarate(); Type: FUNCTION; Schema: public; Owner: nms +-- + +CREATE FUNCTION get_current_datarate() RETURNS SETOF datarate + AS $$ +DECLARE + num_entries INTEGER; + poll polls; + first_poll polls; + last_poll polls; + timediff float; + ret datarate; +BEGIN + num_entries := 0; + last_poll.switch := -1; + + FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP + IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN + IF num_entries >= 2 THEN + timediff := EXTRACT(epoch from last_poll.time - first_poll.time); + ret.switch := last_poll.switch; + ret.port := last_poll.port; + + IF last_poll.bytes_in >= first_poll.bytes_in AND last_poll.bytes_out >= first_poll.bytes_out THEN + ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff; + ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff; + return next ret; + END IF; + END IF; + num_entries := 0; + ELSE + -- reset if we have wraparound + IF last_poll.bytes_in < first_poll.bytes_in OR + last_poll.bytes_out < first_poll.bytes_out THEN + num_entries := 0; + END IF; + END IF; + + num_entries := num_entries + 1; + IF num_entries = 1 THEN + first_poll.switch := poll.switch; + first_poll.port := poll.port; + first_poll.time := poll.time; + first_poll.bytes_in := poll.bytes_in; + first_poll.bytes_out := poll.bytes_out; + END IF; + + last_poll.switch := poll.switch; + last_poll.port := poll.port; + last_poll.time := poll.time; + last_poll.bytes_in := poll.bytes_in; + last_poll.bytes_out := poll.bytes_out; + END LOOP; + + -- last + IF num_entries >= 2 THEN + timediff := EXTRACT(epoch from last_poll.time - first_poll.time); + ret.switch := last_poll.switch; + ret.port := last_poll.port; + + IF last_poll.bytes_in >= first_poll.bytes_in AND + last_poll.bytes_out >= first_poll.bytes_out THEN + ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff; + ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff; + return next ret; + END IF; + END IF; + + RETURN; +END; +$$ + LANGUAGE plpgsql; + + +ALTER FUNCTION public.get_current_datarate() OWNER TO nms; + +-- +-- Name: get_datarate(); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION get_datarate() RETURNS SETOF datarate + AS $$ +DECLARE + num_entries INTEGER; + poll polls; + second_last_poll polls; + last_poll polls; + timediff float; + ret datarate; +BEGIN + num_entries := 0; + last_poll.switch = -1; + + FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP + IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN + IF num_entries >= 2 THEN + timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time); + ret.switch := last_poll.switch; + ret.port := last_poll.port; + + IF last_poll.bytes_in < second_last_poll.bytes_in THEN + second_last_poll.bytes_in = 0; + END IF; + IF last_poll.bytes_out < second_last_poll.bytes_out THEN + second_last_poll.bytes_out = 0; + END IF; + + ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff; + ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff; + return next ret; + ELSIF num_entries = 1 THEN + ret.switch := last_poll.switch; + ret.port := last_poll.port; + ret.bytes_in := -1; + ret.bytes_out := -1; + return next ret; + END IF; + num_entries := 1; + ELSE + num_entries := num_entries + 1; + END IF; + second_last_poll.switch := last_poll.switch; + second_last_poll.port := last_poll.port; + second_last_poll.time := last_poll.time; + second_last_poll.bytes_in := last_poll.bytes_in; + second_last_poll.bytes_out := last_poll.bytes_out; + last_poll.switch := poll.switch; + last_poll.port := poll.port; + last_poll.time := poll.time; + last_poll.bytes_in := poll.bytes_in; + last_poll.bytes_out := poll.bytes_out; + END LOOP; + -- pah, and once more, for the last switch/port... + IF num_entries >= 2 THEN + timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time); + ret.switch := last_poll.switch; + ret.port := last_poll.port; + + IF last_poll.bytes_in < second_last_poll.bytes_in THEN + second_last_poll.bytes_in = 0; + END IF; + IF last_poll.bytes_out < second_last_poll.bytes_out THEN + second_last_poll.bytes_out = 0; + END IF; + + ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff; + ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff; + return next ret; + ELSIF num_entries = 1 THEN + ret.switch := last_poll.switch; + ret.port := last_poll.port; + ret.bytes_in := -1; + ret.bytes_out := -1; + return next ret; + END IF; + + RETURN; +END; +$$ + LANGUAGE plpgsql; + + +ALTER FUNCTION public.get_datarate() OWNER TO postgres; + +-- +-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler + AS '$libdir/plpgsql', 'plpgsql_call_handler' + LANGUAGE c; + + +ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres; + +SET default_tablespace = ''; + +SET default_with_oids = false; + +-- +-- Name: cpuloadpoll; Type: TABLE; Schema: public; Owner: sesse; Tablespace: +-- + +CREATE TABLE cpuloadpoll ( + id serial NOT NULL, + "time" timestamp without time zone NOT NULL, + switch integer NOT NULL, + entity integer NOT NULL, + value integer NOT NULL +); + + +ALTER TABLE public.cpuloadpoll OWNER TO sesse; + +-- +-- Name: cpuloadpoll_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sesse +-- + +SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('cpuloadpoll', 'id'), 12, true); + + +-- +-- Name: dhcp; Type: TABLE; Schema: public; Owner: sesse; Tablespace: +-- + +CREATE TABLE dhcp ( + switch integer NOT NULL, + network cidr NOT NULL, + last_ack timestamp without time zone +); + + +ALTER TABLE public.dhcp OWNER TO sesse; + +-- +-- Name: placements; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE placements ( + switch integer NOT NULL, + placement box NOT NULL +); + + +ALTER TABLE public.placements OWNER TO postgres; + +-- +-- Name: polls; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE polls ( + "time" timestamp with time zone NOT NULL, + switch integer NOT NULL, + port integer NOT NULL, + bytes_in bigint NOT NULL, + bytes_out bigint NOT NULL +); +ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100; + + +ALTER TABLE public.polls OWNER TO postgres; + +-- +-- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres +-- + +CREATE SEQUENCE polls_poll_seq + START WITH 1 + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +ALTER TABLE public.polls_poll_seq OWNER TO postgres; + +-- +-- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres +-- + +SELECT pg_catalog.setval('polls_poll_seq', 1, false); + + +SET default_with_oids = true; + +-- +-- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE portnames ( + switchtype character varying NOT NULL, + port integer NOT NULL, + description character varying NOT NULL +); + + +ALTER TABLE public.portnames OWNER TO postgres; + +-- +-- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace: +-- + +CREATE TABLE squeue ( + id integer DEFAULT nextval(('squeue_sequence'::text)::regclass) NOT NULL, + gid integer NOT NULL, + added timestamp with time zone NOT NULL, + updated timestamp with time zone, + addr inet, + cmd character varying NOT NULL, + locked boolean DEFAULT false NOT NULL, + processed boolean DEFAULT false NOT NULL, + disabled boolean DEFAULT false NOT NULL, + priority integer DEFAULT 3, + sysname character varying NOT NULL, + author character varying NOT NULL, + result character varying, + delay timestamp with time zone, + delaytime interval DEFAULT '00:01:00'::interval +); + + +ALTER TABLE public.squeue OWNER TO nms; + +-- +-- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms +-- + +CREATE SEQUENCE squeue_group_sequence + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +ALTER TABLE public.squeue_group_sequence OWNER TO nms; + +-- +-- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms +-- + +SELECT pg_catalog.setval('squeue_group_sequence', 21, true); + + +-- +-- Name: squeue_sequence; Type: SEQUENCE; Schema: public; Owner: nms +-- + +CREATE SEQUENCE squeue_sequence + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +ALTER TABLE public.squeue_sequence OWNER TO nms; + +-- +-- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms +-- + +SELECT pg_catalog.setval('squeue_sequence', 901, true); + + +-- +-- Name: stemppoll_sequence; Type: SEQUENCE; Schema: public; Owner: nms +-- + +CREATE SEQUENCE stemppoll_sequence + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +ALTER TABLE public.stemppoll_sequence OWNER TO nms; + +-- +-- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms +-- + +SELECT pg_catalog.setval('stemppoll_sequence', 182534, true); + + +SET default_with_oids = false; + +-- +-- Name: switches; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE switches ( + switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL, + ip inet NOT NULL, + sysname character varying NOT NULL, + switchtype character varying NOT NULL, + last_updated timestamp with time zone, + locked boolean DEFAULT false NOT NULL, + priority integer DEFAULT 0 NOT NULL, + poll_frequency interval DEFAULT '00:05:00'::interval NOT NULL, + community character varying DEFAULT 'public'::character varying NOT NULL +); + + +ALTER TABLE public.switches OWNER TO postgres; + +-- +-- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: postgres +-- + +CREATE SEQUENCE switches_switch_seq + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +ALTER TABLE public.switches_switch_seq OWNER TO postgres; + +-- +-- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres +-- + +SELECT pg_catalog.setval('switches_switch_seq', 225, true); + + +-- +-- Name: switchtypes; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE switchtypes ( + switchtype character varying NOT NULL, + ports character varying NOT NULL, + wide_counters boolean DEFAULT false NOT NULL +); + + +ALTER TABLE public.switchtypes OWNER TO postgres; + +SET default_with_oids = true; + +-- +-- Name: temppoll; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE temppoll ( + id integer DEFAULT nextval(('stemppoll_sequence'::text)::regclass) NOT NULL, + "time" timestamp without time zone NOT NULL, + switch integer NOT NULL, + "temp" double precision +); + + +ALTER TABLE public.temppoll OWNER TO postgres; + +-- +-- Data for Name: cpuloadpoll; Type: TABLE DATA; Schema: public; Owner: sesse +-- + +COPY cpuloadpoll (id, "time", switch, entity, value) FROM stdin; +5 2006-03-28 23:16:18.950263 1 5017 1 +6 2006-03-28 23:16:18.970211 1 5001 3 +7 2006-03-28 23:16:18.999445 1 2007 76 +8 2006-03-28 23:16:19.018999 1 1056 3 +9 2006-03-29 14:21:07.052914 1 5017 0 +10 2006-03-29 14:21:07.07474 1 5001 4 +11 2006-03-29 14:21:07.104667 1 2007 69 +12 2006-03-29 14:21:07.125 1 1056 3 +\. + + +-- +-- Data for Name: dhcp; Type: TABLE DATA; Schema: public; Owner: sesse +-- + +COPY dhcp (switch, network, last_ack) FROM stdin; +151 81.162.53.0/26 2005-03-27 11:53:29 +41 81.162.16.64/26 2005-03-27 11:53:35 +164 81.162.57.64/26 2005-03-27 11:53:39 +20 81.162.9.64/26 2005-03-27 11:54:27 +4 81.162.4.0/26 2005-03-27 11:55:33 +44 81.162.17.64/26 2005-03-27 11:56:37 +194 81.162.67.64/26 2005-03-27 11:56:38 +139 81.162.49.0/26 2005-03-27 11:57:08 +46 81.162.18.0/26 2005-03-27 11:57:27 +193 81.162.67.0/26 2005-03-27 11:57:36 +27 81.162.11.128/26 2005-03-27 11:58:07 +107 81.162.38.64/26 2005-03-27 11:58:31 +133 81.162.47.0/26 2005-03-27 11:58:52 +99 81.162.35.128/26 2005-03-27 11:59:09 +79 81.162.29.0/26 2005-03-27 11:59:18 +34 81.162.14.0/26 2005-03-27 11:59:28 +51 81.162.19.128/26 2005-03-27 11:59:34 +160 81.162.56.0/26 2005-03-27 12:00:01 +196 81.162.68.0/26 2005-03-27 12:00:11 +184 81.162.64.0/26 2005-03-27 12:01:48 +9 81.162.5.128/26 2005-03-27 12:01:54 +195 81.162.67.128/26 2005-03-27 12:02:18 +123 81.162.43.128/26 2005-03-27 12:02:46 +192 81.162.66.128/26 2005-03-27 12:03:09 +212 81.162.203.0/24 2005-03-27 12:04:12 +5 81.162.4.64/26 2005-03-27 12:04:14 +113 81.162.40.64/26 2005-03-27 12:05:01 +191 81.162.66.64/26 2005-03-27 12:05:01 +119 81.162.42.64/26 2005-03-27 12:06:01 +3 81.162.2.128/26 2005-03-27 12:06:03 +74 81.162.27.64/26 2005-03-27 12:06:12 +201 81.162.70.0/26 2005-03-27 12:06:25 +86 81.162.31.64/26 2005-03-27 12:07:56 +50 81.162.19.64/26 2005-03-27 12:08:36 +59 81.162.22.64/26 2005-03-27 12:08:59 +43 81.162.17.0/26 2005-03-27 12:09:02 +80 81.162.29.64/26 2005-03-27 12:09:14 +106 81.162.38.0/26 2005-03-27 12:09:15 +52 81.162.20.0/26 2005-03-27 12:09:22 +205 81.162.72.0/26 2005-03-27 12:10:08 +82 81.162.30.0/26 2005-03-27 12:10:10 +128 81.162.45.64/26 2005-03-27 12:10:38 +112 81.162.40.0/26 2005-03-27 12:11:16 +202 81.162.70.64/26 2005-03-27 12:12:30 +6 81.162.4.128/26 2005-03-27 12:12:49 +95 81.162.34.64/26 2005-03-27 12:13:02 +178 81.162.62.0/26 2005-03-27 12:13:10 +145 81.162.51.0/26 2005-03-27 12:13:15 +84 81.162.30.128/26 2005-03-27 12:13:34 +28 81.162.12.0/26 2005-03-27 12:13:58 +22 81.162.10.0/26 2005-03-27 12:14:40 +122 81.162.43.64/26 2005-03-27 12:14:57 +85 81.162.31.0/26 2005-03-27 12:15:21 +18 81.162.8.128/26 2005-03-27 12:15:24 +105 81.162.37.128/26 2005-03-27 12:15:24 +81 81.162.29.128/26 2005-03-27 12:15:36 +77 81.162.28.64/26 2005-03-27 12:15:47 +146 81.162.51.64/26 2005-03-27 12:17:09 +24 81.162.10.128/26 2005-03-27 12:17:10 +190 81.162.66.0/26 2005-03-27 12:17:10 +33 81.162.13.128/26 2005-03-27 12:17:17 +150 81.162.52.128/26 2005-03-27 12:17:27 +57 81.162.21.128/26 2005-03-27 12:17:37 +17 81.162.8.64/26 2005-03-27 12:17:39 +54 81.162.20.128/26 2005-03-27 12:18:24 +94 81.162.34.0/26 2005-03-27 12:18:24 +69 81.162.25.128/26 2005-03-27 12:18:26 +141 81.162.49.128/26 2005-03-27 12:18:43 +154 81.162.54.0/26 2005-03-27 12:19:25 +177 81.162.61.128/26 2005-03-27 12:20:17 +29 81.162.12.64/26 2005-03-27 12:20:37 +91 81.162.33.0/26 2005-03-27 12:20:53 +83 81.162.30.64/26 2005-03-27 12:20:57 +47 81.162.18.64/26 2005-03-27 12:21:10 +170 81.162.59.64/26 2005-03-27 12:22:01 +78 81.162.28.128/26 2005-03-27 12:22:26 +155 81.162.54.64/26 2005-03-27 12:23:11 +35 81.162.14.64/26 2005-03-27 12:23:12 +32 81.162.13.64/26 2005-03-27 12:23:55 +199 81.162.69.64/26 2005-03-27 12:24:13 +63 81.162.23.128/26 2005-03-27 12:24:33 +90 81.162.32.128/26 2005-03-27 12:25:31 +114 81.162.40.128/26 2005-03-27 12:26:04 +75 81.162.27.128/26 2005-03-27 12:26:06 +42 81.162.16.128/26 2005-03-27 12:26:26 +87 81.162.31.128/26 2005-03-27 12:26:42 +67 81.162.25.0/26 2005-03-27 12:27:31 +204 81.162.71.128/26 2005-03-27 12:34:04 +200 81.162.69.128/26 2005-03-27 12:37:19 +207 81.162.73.64/26 2005-03-27 12:41:57 +203 81.162.71.64/26 2005-03-27 12:58:48 +214 81.162.213.0/24 2005-03-27 13:02:26 +213 81.162.213.0/24 2005-03-27 13:02:26 +209 81.162.212.0/24 2005-03-27 13:16:02 +215 81.162.200.0/24 2005-03-27 13:16:14 +210 81.162.250.0/24 2005-03-27 13:18:02 +211 81.162.252.0/24 2005-03-27 12:39:02 +129 81.162.45.128/26 2005-03-27 10:44:11 +110 81.162.39.64/26 2005-03-27 08:19:17 +10 81.162.6.0/26 2005-03-27 08:35:15 +171 81.162.59.128/26 2005-03-27 08:42:52 +167 81.162.58.64/26 2005-03-27 09:07:47 +180 81.162.62.128/26 2005-03-27 09:22:15 +140 81.162.49.64/26 2005-03-27 09:41:51 +103 81.162.37.0/26 2005-03-27 09:42:30 +55 81.162.21.0/26 2005-03-27 09:42:54 +137 81.162.48.64/26 2005-03-27 09:47:06 +62 81.162.23.64/26 2005-03-27 09:51:30 +158 81.162.55.64/26 2005-03-27 09:51:55 +70 81.162.26.0/26 2005-03-27 09:52:09 +159 81.162.55.128/26 2005-03-27 10:05:56 +165 81.162.57.128/26 2005-03-27 10:09:30 +125 81.162.44.64/26 2005-03-27 10:10:14 +169 81.162.59.0/26 2005-03-27 10:10:29 +89 81.162.32.64/26 2005-03-27 10:11:14 +168 81.162.58.128/26 2005-03-27 10:11:42 +39 81.162.15.128/26 2005-03-27 10:11:49 +134 81.162.47.64/26 2005-03-27 10:12:00 +144 81.162.50.128/26 2005-03-27 10:15:46 +61 81.162.23.0/26 2005-03-27 10:19:36 +186 81.162.64.128/26 2005-03-27 10:24:08 +97 81.162.35.0/26 2005-03-27 10:26:13 +124 81.162.44.0/26 2005-03-27 10:28:37 +162 81.162.56.128/26 2005-03-27 10:36:33 +76 81.162.28.0/26 2005-03-27 10:38:20 +156 81.162.54.128/26 2005-03-27 10:41:07 +93 81.162.33.128/26 2005-03-27 10:42:16 +58 81.162.22.0/26 2005-03-27 10:42:50 +23 81.162.10.64/26 2005-03-27 10:43:27 +132 81.162.46.128/26 2005-03-27 10:46:35 +118 81.162.42.0/26 2005-03-27 10:47:16 +16 81.162.8.0/26 2005-03-27 10:47:53 +182 81.162.63.64/26 2005-03-27 10:47:58 +88 81.162.32.0/26 2005-03-27 10:49:28 +126 81.162.44.128/26 2005-03-27 10:50:02 +130 81.162.46.0/26 2005-03-27 10:50:46 +15 81.162.7.128/26 2005-03-27 10:54:20 +12 81.162.6.128/26 2005-03-27 10:54:40 +98 81.162.35.64/26 2005-03-27 10:55:15 +104 81.162.37.64/26 2005-03-27 10:57:11 +100 81.162.36.0/26 2005-03-27 10:58:55 +45 81.162.17.128/26 2005-03-27 11:02:32 +131 81.162.46.64/26 2005-03-27 11:04:23 +175 81.162.61.0/26 2005-03-27 11:04:47 +72 81.162.26.128/26 2005-03-27 11:04:50 +148 81.162.52.0/26 2005-03-27 11:05:19 +198 81.162.68.128/26 2005-03-27 11:06:42 +68 81.162.25.64/26 2005-03-27 11:06:55 +115 81.162.41.0/26 2005-03-27 11:08:58 +157 81.162.55.0/26 2005-03-27 11:10:30 +111 81.162.39.128/26 2005-03-27 11:11:10 +120 81.162.42.128/26 2005-03-27 10:14:01 +21 81.162.9.128/26 2005-03-27 10:39:11 +64 81.162.24.0/26 2005-03-27 11:14:54 +7 81.162.5.0/26 2005-03-27 11:15:07 +163 81.162.57.0/26 2005-03-27 11:18:50 +208 81.162.73.128/26 2005-03-27 11:18:53 +189 81.162.65.128/26 2005-03-27 11:20:12 +197 81.162.68.64/26 2005-03-27 11:20:46 +31 81.162.13.0/26 2005-03-27 11:22:31 +19 81.162.9.0/26 2005-03-27 11:22:48 +13 81.162.7.0/26 2005-03-27 11:24:35 +147 81.162.51.128/26 2005-03-27 11:27:37 +135 81.162.47.128/26 2005-03-27 11:28:43 +121 81.162.43.0/26 2005-03-27 11:28:58 +136 81.162.48.0/26 2005-03-27 11:31:04 +66 81.162.24.128/26 2005-03-27 11:32:10 +166 81.162.58.0/26 2005-03-27 09:25:55 +138 81.162.48.128/26 2005-03-27 10:08:33 +56 81.162.21.64/26 2005-03-27 11:32:34 +143 81.162.50.64/26 2005-03-27 11:33:03 +176 81.162.61.64/26 2005-03-27 11:33:36 +65 81.162.24.64/26 2005-03-27 11:33:40 +102 81.162.36.128/26 2005-03-27 11:34:00 +116 81.162.41.64/26 2005-03-27 11:34:56 +183 81.162.63.128/26 2005-03-27 11:36:02 +109 81.162.39.0/26 2005-03-27 11:36:45 +25 81.162.11.0/26 2005-03-27 11:37:44 +174 81.162.60.128/26 2005-03-27 11:38:11 +216 81.162.202.0/24 2005-03-27 11:39:03 +40 81.162.16.0/26 2005-03-27 11:39:31 +152 81.162.53.64/26 2005-03-27 11:39:47 +14 81.162.7.64/26 2005-03-27 11:39:59 +92 81.162.33.64/26 2005-03-27 11:40:05 +173 81.162.60.64/26 2005-03-27 11:40:28 +48 81.162.18.128/26 2005-03-27 11:40:28 +8 81.162.5.64/26 2005-03-27 11:40:45 +108 81.162.38.128/26 2005-03-27 11:42:43 +11 81.162.6.64/26 2005-03-27 08:50:50 +188 81.162.65.64/26 2005-03-27 08:55:21 +117 81.162.41.128/26 2005-03-27 09:23:35 +26 81.162.11.64/26 2005-03-27 11:43:18 +172 81.162.60.0/26 2005-03-27 11:43:21 +71 81.162.26.64/26 2005-03-27 11:43:51 +38 81.162.15.64/26 2005-03-27 11:44:11 +153 81.162.53.128/26 2005-03-27 11:45:51 +53 81.162.20.64/26 2005-03-27 11:46:24 +1 81.162.2.0/26 2005-03-27 11:47:03 +2 81.162.2.64/26 2005-03-27 11:47:10 +149 81.162.52.64/26 2005-03-27 11:48:35 +37 81.162.15.0/26 2005-03-27 11:49:04 +127 81.162.45.0/26 2005-03-27 11:49:22 +179 81.162.62.64/26 2005-03-27 11:49:48 +185 81.162.64.64/26 2005-03-27 11:50:36 +142 81.162.50.0/26 2005-03-27 11:51:18 +36 81.162.14.128/26 2005-03-27 11:51:19 +30 81.162.12.128/26 2005-03-27 11:51:20 +60 81.162.22.128/26 2005-03-27 11:52:08 +49 81.162.19.0/26 2005-03-27 10:22:15 +73 81.162.27.0/26 2005-03-27 11:27:55 +96 81.162.34.128/26 2005-03-27 11:32:26 +101 81.162.36.64/26 2005-03-27 11:40:47 +181 81.162.63.0/26 2005-03-27 11:52:55 +187 81.162.65.0/26 2005-03-27 11:53:23 +161 81.162.56.64/26 2005-03-27 08:54:44 +\. + + +-- +-- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: postgres +-- + +COPY placements (switch, placement) FROM stdin; +221 (375,325),(350,300) +222 (550,325),(525,300) +224 (775,325),(750,300) +223 (875,325),(850,300) +225 (675,325),(650,300) +218 (980,550),(930,520) +1 (306,306),(294,256) +2 (306,256),(294,206) +3 (306,206),(294,156) +4 (325,306),(313,256) +5 (325,256),(313,206) +6 (325,206),(313,156) +7 (344,470),(332,422) +8 (344,422),(332,374) +9 (344,374),(332,326) +10 (344,306),(332,256) +11 (344,256),(332,206) +12 (344,206),(332,156) +13 (363,470),(351,422) +14 (363,422),(351,374) +15 (363,374),(351,326) +16 (363,306),(351,256) +17 (363,256),(351,206) +18 (363,206),(351,156) +19 (382,470),(370,422) +20 (382,422),(370,374) +21 (382,374),(370,326) +22 (382,306),(370,256) +23 (382,256),(370,206) +24 (382,206),(370,156) +25 (400,470),(388,422) +26 (400,422),(388,374) +27 (400,374),(388,326) +28 (400,306),(388,256) +29 (400,256),(388,206) +30 (400,206),(388,156) +31 (419,470),(407,422) +32 (419,422),(407,374) +33 (419,374),(407,326) +34 (419,306),(407,256) +35 (419,256),(407,206) +36 (419,206),(407,156) +37 (438,470),(426,422) +38 (438,422),(426,374) +39 (438,374),(426,326) +40 (438,306),(426,256) +41 (438,256),(426,206) +42 (438,206),(426,156) +43 (457,470),(445,422) +44 (457,422),(445,374) +45 (457,374),(445,326) +46 (457,306),(445,256) +47 (457,256),(445,206) +48 (457,206),(445,156) +49 (483,470),(471,422) +50 (483,422),(471,374) +51 (483,374),(471,326) +52 (483,306),(471,256) +53 (483,256),(471,206) +54 (483,206),(471,156) +55 (502,470),(490,422) +56 (502,422),(490,374) +57 (502,374),(490,326) +58 (502,306),(490,256) +59 (502,256),(490,206) +60 (502,206),(490,156) +61 (521,470),(509,422) +62 (521,422),(509,374) +63 (521,374),(509,326) +64 (521,306),(509,256) +65 (521,256),(509,206) +66 (521,206),(509,156) +67 (540,470),(528,422) +68 (540,422),(528,374) +69 (540,374),(528,326) +70 (540,306),(528,256) +71 (540,256),(528,206) +72 (540,206),(528,156) +73 (559,470),(547,422) +74 (559,422),(547,374) +75 (559,374),(547,326) +76 (559,306),(547,256) +77 (559,256),(547,206) +78 (559,206),(547,156) +79 (578,470),(566,422) +80 (578,422),(566,374) +81 (578,374),(566,326) +82 (578,306),(566,256) +83 (578,256),(566,206) +84 (578,206),(566,156) +85 (596,470),(584,422) +86 (596,422),(584,374) +87 (596,374),(584,326) +88 (596,306),(584,256) +89 (596,256),(584,206) +90 (596,206),(584,156) +91 (615,470),(603,422) +92 (615,422),(603,374) +93 (615,374),(603,326) +94 (615,306),(603,256) +95 (615,256),(603,206) +96 (615,206),(603,156) +97 (648,470),(636,422) +98 (648,422),(636,374) +99 (648,374),(636,326) +100 (648,306),(636,256) +101 (648,256),(636,206) +102 (648,206),(636,156) +103 (667,470),(655,422) +104 (667,422),(655,374) +105 (667,374),(655,326) +106 (667,306),(655,256) +107 (667,256),(655,206) +108 (667,206),(655,156) +109 (686,470),(674,422) +110 (686,422),(674,374) +111 (686,374),(674,326) +112 (686,306),(674,256) +113 (686,256),(674,206) +114 (686,206),(674,156) +115 (705,470),(693,422) +116 (705,422),(693,374) +117 (705,374),(693,326) +118 (705,306),(693,256) +119 (705,256),(693,206) +120 (705,206),(693,156) +121 (724,470),(712,422) +122 (724,422),(712,374) +123 (724,374),(712,326) +124 (724,306),(712,256) +125 (724,256),(712,206) +126 (724,206),(712,156) +127 (743,470),(731,422) +128 (743,422),(731,374) +129 (743,374),(731,326) +130 (743,306),(731,256) +131 (743,256),(731,206) +132 (743,206),(731,156) +133 (762,470),(750,422) +134 (762,422),(750,374) +135 (762,374),(750,326) +136 (762,306),(750,256) +137 (762,256),(750,206) +138 (762,206),(750,156) +139 (781,470),(769,422) +140 (781,422),(769,374) +141 (781,374),(769,326) +142 (781,306),(769,256) +143 (781,256),(769,206) +144 (781,206),(769,156) +145 (808,470),(796,422) +146 (808,422),(796,374) +147 (808,374),(796,326) +148 (808,306),(796,256) +149 (808,256),(796,206) +150 (808,206),(796,156) +151 (827,470),(815,422) +152 (827,422),(815,374) +153 (827,374),(815,326) +154 (827,306),(815,256) +155 (827,256),(815,206) +156 (827,206),(815,156) +157 (846,470),(834,422) +158 (846,422),(834,374) +159 (846,374),(834,326) +160 (846,306),(834,256) +161 (846,256),(834,206) +162 (846,206),(834,156) +163 (865,470),(853,422) +164 (865,422),(853,374) +165 (865,374),(853,326) +166 (865,306),(853,256) +167 (865,256),(853,206) +168 (865,206),(853,156) +169 (884,470),(872,422) +170 (884,422),(872,374) +171 (884,374),(872,326) +172 (884,306),(872,256) +173 (884,256),(872,206) +174 (884,206),(872,156) +175 (903,470),(891,422) +176 (903,422),(891,374) +177 (903,374),(891,326) +178 (903,306),(891,256) +179 (903,256),(891,206) +180 (903,206),(891,156) +181 (922,470),(910,422) +182 (922,422),(910,374) +183 (922,374),(910,326) +184 (922,306),(910,256) +185 (922,256),(910,206) +186 (922,206),(910,156) +187 (941,470),(929,422) +188 (941,422),(929,374) +189 (941,374),(929,326) +190 (941,306),(929,256) +191 (941,256),(929,206) +192 (941,206),(929,156) +193 (960,470),(948,422) +194 (960,422),(948,374) +195 (960,374),(948,326) +196 (960,306),(948,256) +197 (960,256),(948,206) +198 (960,206),(948,156) +199 (988,422),(976,374) +200 (988,374),(976,326) +201 (979,306),(967,256) +202 (979,256),(967,206) +203 (1006,422),(994,374) +204 (1006,374),(994,326) +205 (997,306),(985,256) +207 (1025,422),(1013,374) +208 (1025,374),(1013,326) +209 (1125,225),(1100,200) +210 (680,550),(630,520) +211 (610,550),(560,520) +212 (305,385),(270,350) +213 (900,100),(800,75) +214 (900,100),(800,75) +215 (200,270),(170,240) +216 (250,180),(220,150) +\. + + +-- +-- Data for Name: polls; Type: TABLE DATA; Schema: public; Owner: postgres +-- + +COPY polls ("time", switch, port, bytes_in, bytes_out) FROM stdin; +2006-03-28 22:39:09.893643+02 1 1 0 0 +2006-03-28 22:39:09.913546+02 1 2 0 0 +2006-03-28 22:39:09.933906+02 1 3 0 0 +2006-03-28 22:39:09.953638+02 1 4 0 0 +2006-03-28 22:39:09.973536+02 1 5 0 0 +2006-03-28 22:39:09.993418+02 1 6 0 0 +2006-03-28 22:39:10.013146+02 1 7 0 0 +2006-03-28 22:39:10.032774+02 1 8 0 0 +2006-03-28 22:39:10.052348+02 1 9 0 0 +2006-03-28 22:39:10.072177+02 1 10 0 0 +2006-03-28 22:39:10.092731+02 1 11 0 0 +2006-03-28 22:39:10.11247+02 1 12 0 0 +2006-03-28 22:39:10.132382+02 1 13 7747123 14112208 +2006-03-28 22:39:10.152582+02 1 14 7713082 14042766 +2006-03-28 22:39:10.172369+02 1 15 8056118 17207110 +2006-03-28 22:39:10.192118+02 1 16 0 0 +2006-03-28 22:39:10.212055+02 1 17 0 0 +2006-03-28 22:39:10.231483+02 1 18 0 0 +2006-03-28 22:39:10.251181+02 1 19 138414013 203348896 +2006-03-28 22:39:10.271767+02 1 20 199834250 208491729 +2006-03-28 22:39:10.29177+02 1 21 6357743 13961928 +2006-03-28 22:39:10.311587+02 1 22 0 0 +2006-03-28 22:39:10.331091+02 1 23 0 0 +2006-03-28 22:39:10.350932+02 1 24 0 0 +2006-03-28 22:39:10.370631+02 1 25 0 0 +2006-03-28 22:39:10.390715+02 1 26 0 0 +2006-03-28 22:39:10.410346+02 1 27 0 0 +2006-03-28 22:39:10.430225+02 1 28 0 0 +2006-03-28 22:39:10.450417+02 1 29 0 0 +2006-03-28 22:39:10.471318+02 1 30 0 0 +2006-03-28 22:39:10.490967+02 1 31 0 0 +2006-03-28 22:39:10.511826+02 1 32 0 0 +2006-03-28 22:39:10.53276+02 1 33 0 0 +2006-03-28 22:39:10.553075+02 1 34 0 0 +2006-03-28 22:39:10.573845+02 1 35 0 0 +2006-03-28 22:39:10.595012+02 1 36 0 0 +2006-03-28 22:39:10.615023+02 1 37 0 0 +2006-03-28 22:39:10.634971+02 1 38 0 0 +2006-03-28 22:39:10.654731+02 1 39 0 0 +2006-03-28 22:39:10.686279+02 1 40 0 0 +2006-03-28 22:39:10.705889+02 1 41 0 0 +2006-03-28 22:39:10.72543+02 1 42 0 0 +2006-03-28 22:39:10.745098+02 1 43 0 0 +2006-03-28 22:39:10.764735+02 1 44 0 0 +2006-03-28 22:39:10.784882+02 1 45 0 0 +2006-03-28 22:39:10.804477+02 1 46 816 976127 +2006-03-28 22:39:10.82424+02 1 47 748 503124 +2006-03-28 22:39:10.843866+02 1 48 816 276935 +2006-03-28 22:39:10.863439+02 1 49 2890 2890 +2006-03-28 22:39:10.883028+02 1 50 210 210 +2006-03-28 22:39:10.90281+02 1 51 210 210 +2006-03-28 22:39:10.922442+02 1 52 210 210 +2006-03-28 22:39:10.942226+02 1 53 210 210 +2006-03-28 22:39:10.96199+02 1 54 210 210 +2006-03-28 22:39:10.983951+02 1 55 210 210 +2006-03-28 22:39:11.003594+02 1 56 210 210 +2006-03-28 22:39:11.023272+02 1 57 1058 1058 +2006-03-28 22:39:11.043103+02 1 58 210 210 +2006-03-28 22:39:11.062924+02 1 59 210 210 +2006-03-28 22:39:11.083132+02 1 60 210 210 +2006-03-28 22:39:11.103073+02 1 61 210 210 +2006-03-28 22:39:11.123076+02 1 62 370389 1367489 +2006-03-28 22:39:11.142765+02 1 63 210 535911 +2006-03-28 22:39:11.162409+02 1 64 210 243777 +2006-03-28 22:39:11.18224+02 1 65 228 5275950 +2006-03-28 22:39:11.202296+02 1 66 7020 164802316 +2006-03-28 22:39:11.221934+02 1 67 0 0 +2006-03-28 22:39:11.24138+02 1 68 0 0 +2006-03-28 22:39:11.260987+02 1 69 0 0 +2006-03-28 22:39:11.280526+02 1 70 0 0 +2006-03-28 22:39:11.300239+02 1 71 228 228 +2006-03-28 22:39:11.319742+02 1 72 146 5274588 +2006-03-28 22:39:11.339383+02 1 73 240 240 +2006-03-28 22:39:11.35914+02 1 74 240 240 +2006-03-28 22:39:11.378792+02 1 75 240 240 +2006-03-28 22:39:11.398351+02 1 76 240 240 +2006-03-28 22:39:11.41811+02 1 77 240 240 +2006-03-28 22:39:11.437892+02 1 78 240 240 +2006-03-28 22:39:11.457433+02 1 79 0 0 +2006-03-28 22:39:11.477388+02 1 80 4286507245 3471154200 +2006-03-28 22:39:11.497485+02 1 81 146 146 +2006-03-28 22:39:11.517205+02 1 82 0 0 +2006-03-28 22:39:11.536948+02 1 83 146 146 +2006-03-28 22:39:11.556906+02 1 84 0 0 +2006-03-28 22:39:11.576549+02 1 85 0 0 +2006-03-28 22:39:11.597038+02 1 86 0 0 +2006-03-28 22:39:11.616963+02 1 87 0 0 +2006-03-28 22:39:11.636499+02 1 88 0 0 +2006-03-28 22:39:11.656367+02 1 89 0 0 +2006-03-28 22:39:11.67601+02 1 90 0 0 +2006-03-28 22:39:11.696501+02 1 91 0 0 +2006-03-28 22:39:11.715967+02 1 92 0 0 +2006-03-28 22:39:11.735507+02 1 93 0 0 +2006-03-28 22:39:11.755479+02 1 94 0 0 +2006-03-28 22:39:11.775257+02 1 95 0 0 +2006-03-28 22:39:11.795138+02 1 96 0 0 +2006-03-28 22:39:11.815197+02 1 97 240 1620567769 +2006-03-28 22:39:11.834833+02 1 98 39356 122027824 +2006-03-28 22:39:11.854636+02 1 99 9234 1182439 +2006-03-28 22:39:11.874374+02 1 100 240 28805070 +2006-03-28 22:39:11.894428+02 1 101 240 1096957 +2006-03-28 22:39:11.91458+02 1 102 620 619669 +2006-03-28 22:39:11.934683+02 1 103 0 0 +2006-03-28 22:39:11.954545+02 1 104 2746281650 1380471316 +2006-03-28 22:39:11.974981+02 1 105 0 0 +2006-03-28 22:39:11.994707+02 1 106 0 0 +2006-03-28 22:39:12.016469+02 1 107 0 0 +2006-03-28 22:39:12.036156+02 1 108 154278739 16885365 +2006-03-28 22:39:12.055859+02 1 109 0 953869 +2006-03-28 22:39:12.075687+02 1 110 11485 93069 +2006-03-28 22:39:12.095999+02 1 111 17993418 93133 +2006-03-28 22:39:12.1156+02 1 112 5310060 6561837 +2006-03-28 22:39:12.135708+02 1 113 0 97485 +2006-03-28 22:39:12.155377+02 1 114 0 0 +2006-03-28 22:39:12.174924+02 1 115 0 93133 +2006-03-28 22:39:12.195017+02 1 116 0 93133 +2006-03-28 22:39:12.214711+02 1 117 40502 130091 +2006-03-28 22:39:12.234355+02 1 118 0 0 +2006-03-28 22:39:12.253895+02 1 119 1440 1440 +2006-03-28 22:39:12.273878+02 1 120 49930 1774299728 +2006-03-28 22:39:12.383056+02 1 121 7476090 7476090 +2006-03-28 22:39:12.403941+02 1 122 0 0 +2006-03-28 22:39:12.424965+02 1 123 0 0 +2006-03-28 22:45:50.691773+02 1 1 0 0 +2006-03-28 22:45:50.712108+02 1 2 0 0 +2006-03-28 22:45:50.732551+02 1 3 0 0 +2006-03-28 22:45:50.752709+02 1 4 0 0 +2006-03-28 22:45:50.772544+02 1 5 0 0 +2006-03-28 22:45:50.792215+02 1 6 0 0 +2006-03-28 22:45:50.811996+02 1 7 0 0 +2006-03-28 22:45:50.838285+02 1 8 0 0 +2006-03-28 22:45:50.859209+02 1 9 0 0 +2006-03-28 22:45:50.879008+02 1 10 0 0 +2006-03-28 22:45:50.899314+02 1 11 0 0 +2006-03-28 22:45:50.918892+02 1 12 0 0 +2006-03-28 22:45:50.938681+02 1 13 7781011 14166925 +2006-03-28 22:45:50.958276+02 1 14 7742093 14093748 +2006-03-28 22:45:50.978192+02 1 15 8089140 17260526 +2006-03-28 22:45:50.998131+02 1 16 0 0 +2006-03-28 22:45:51.017874+02 1 17 0 0 +2006-03-28 22:45:51.037875+02 1 18 0 0 +2006-03-28 22:45:51.057617+02 1 19 138442049 203409365 +2006-03-28 22:45:51.07741+02 1 20 199872795 208568010 +2006-03-28 22:45:51.09707+02 1 21 6385320 14021490 +2006-03-28 22:45:51.116944+02 1 22 0 0 +2006-03-28 22:45:51.136723+02 1 23 0 0 +2006-03-28 22:45:51.156402+02 1 24 0 0 +2006-03-28 22:46:04.439098+02 1 1 0 0 +2006-03-28 22:46:04.459636+02 1 2 0 0 +2006-03-28 22:46:04.479286+02 1 3 0 0 +2006-03-28 22:46:04.498935+02 1 4 0 0 +2006-03-28 22:46:04.5186+02 1 5 0 0 +2006-03-28 22:46:04.538232+02 1 6 0 0 +2006-03-28 22:46:04.55788+02 1 7 0 0 +2006-03-28 22:46:04.577626+02 1 8 0 0 +2006-03-28 22:46:04.597683+02 1 9 0 0 +2006-03-28 22:46:04.617111+02 1 10 0 0 +2006-03-28 22:46:04.637422+02 1 11 0 0 +2006-03-28 22:46:04.657219+02 1 12 0 0 +2006-03-28 22:46:04.67687+02 1 13 7781329 14167539 +2006-03-28 22:46:04.696741+02 1 14 7742221 14094648 +2006-03-28 22:46:04.716788+02 1 15 8089268 17261268 +2006-03-28 22:46:04.736581+02 1 16 0 0 +2006-03-28 22:46:04.756341+02 1 17 0 0 +2006-03-28 22:46:04.775933+02 1 18 0 0 +2006-03-28 22:46:04.795543+02 1 19 138442495 203409877 +2006-03-28 22:46:04.815504+02 1 20 199872859 208568458 +2006-03-28 22:46:04.835122+02 1 21 6385384 14022032 +2006-03-28 22:46:04.855403+02 1 22 0 0 +2006-03-28 22:46:04.875114+02 1 23 0 0 +2006-03-28 22:46:04.895722+02 1 24 0 0 +2006-03-28 23:04:10.517298+02 1 1 0 0 +2006-03-28 23:04:10.537186+02 1 2 0 0 +2006-03-28 23:04:10.556902+02 1 3 0 0 +2006-03-28 23:04:10.576559+02 1 4 0 0 +2006-03-28 23:04:10.596516+02 1 5 0 0 +2006-03-28 23:04:10.617152+02 1 6 0 0 +2006-03-28 23:04:10.636818+02 1 7 0 0 +2006-03-28 23:04:10.656596+02 1 8 0 0 +2006-03-28 23:04:10.676103+02 1 9 0 0 +2006-03-28 23:04:10.696325+02 1 10 0 0 +2006-03-28 23:04:10.716109+02 1 11 0 0 +2006-03-28 23:04:10.736552+02 1 12 0 0 +2006-03-28 23:04:10.75648+02 1 13 7856336 14296955 +2006-03-28 23:04:10.776391+02 1 14 7823592 14228507 +2006-03-28 23:04:10.796099+02 1 15 8167545 17392530 +2006-03-28 23:04:10.816284+02 1 16 0 0 +2006-03-28 23:04:10.836317+02 1 17 0 0 +2006-03-28 23:04:10.855804+02 1 18 0 0 +2006-03-28 23:04:10.876015+02 1 19 138516087 203568321 +2006-03-28 23:04:10.896711+02 1 20 199973797 208768486 +2006-03-28 23:04:10.916745+02 1 21 6458453 14179252 +2006-03-28 23:04:10.937118+02 1 22 0 0 +2006-03-28 23:04:10.956641+02 1 23 0 0 +2006-03-28 23:04:10.976821+02 1 24 0 0 +2006-03-28 23:04:38.934053+02 1 1 0 0 +2006-03-28 23:04:38.95404+02 1 2 0 0 +2006-03-28 23:04:38.973763+02 1 3 0 0 +2006-03-28 23:04:38.993548+02 1 4 0 0 +2006-03-28 23:04:39.013146+02 1 5 0 0 +2006-03-28 23:04:39.032762+02 1 6 0 0 +2006-03-28 23:04:39.05292+02 1 7 0 0 +2006-03-28 23:04:39.073058+02 1 8 0 0 +2006-03-28 23:04:39.093076+02 1 9 0 0 +2006-03-28 23:04:39.112943+02 1 10 0 0 +2006-03-28 23:04:39.142183+02 1 11 0 0 +2006-03-28 23:04:39.16179+02 1 12 0 0 +2006-03-28 23:04:39.181511+02 1 13 7857656 14300001 +2006-03-28 23:04:39.201421+02 1 14 7825006 14231647 +2006-03-28 23:04:39.221197+02 1 15 8169119 17395512 +2006-03-28 23:04:39.24095+02 1 16 0 0 +2006-03-28 23:04:39.260593+02 1 17 0 0 +2006-03-28 23:04:39.28024+02 1 18 0 0 +2006-03-28 23:04:39.300251+02 1 19 138516907 203572473 +2006-03-28 23:04:39.320172+02 1 20 199974935 208772794 +2006-03-28 23:04:39.340547+02 1 21 6459209 14183340 +2006-03-28 23:04:39.36032+02 1 22 0 0 +2006-03-28 23:04:39.379996+02 1 23 0 0 +2006-03-28 23:04:39.399682+02 1 24 0 0 +2006-03-28 23:08:25.811543+02 1 1 0 0 +2006-03-28 23:08:25.832178+02 1 2 0 0 +2006-03-28 23:08:25.851821+02 1 3 0 0 +2006-03-28 23:08:25.871447+02 1 4 0 0 +2006-03-28 23:08:25.891095+02 1 5 0 0 +2006-03-28 23:08:25.911042+02 1 6 0 0 +2006-03-28 23:08:25.930796+02 1 7 0 0 +2006-03-28 23:08:25.950443+02 1 8 0 0 +2006-03-28 23:08:25.970441+02 1 9 0 0 +2006-03-28 23:08:25.990093+02 1 10 0 0 +2006-03-28 23:08:26.009844+02 1 11 0 0 +2006-03-28 23:08:26.029585+02 1 12 0 0 +2006-03-28 23:08:26.04914+02 1 13 7876029 14330508 +2006-03-28 23:08:26.068755+02 1 14 7842402 14260671 +2006-03-28 23:08:26.088424+02 1 15 8186302 17425712 +2006-03-28 23:08:26.108129+02 1 16 0 0 +2006-03-28 23:08:26.128018+02 1 17 0 0 +2006-03-28 23:08:26.147692+02 1 18 0 0 +2006-03-28 23:08:26.167393+02 1 19 138532007 203604699 +2006-03-28 23:08:26.187095+02 1 20 199996249 208814508 +2006-03-28 23:08:26.206925+02 1 21 6474499 14215586 +2006-03-28 23:08:26.226462+02 1 22 0 0 +2006-03-28 23:08:26.246118+02 1 23 0 0 +2006-03-28 23:08:26.265827+02 1 24 0 0 +2006-03-28 23:09:33.136981+02 1 1 0 0 +2006-03-28 23:09:33.15741+02 1 2 0 0 +2006-03-28 23:09:33.177081+02 1 3 0 0 +2006-03-28 23:09:33.196591+02 1 4 0 0 +2006-03-28 23:09:33.216282+02 1 5 0 0 +2006-03-28 23:09:33.235922+02 1 6 0 0 +2006-03-28 23:09:33.255785+02 1 7 0 0 +2006-03-28 23:09:33.27593+02 1 8 0 0 +2006-03-28 23:09:33.295795+02 1 9 0 0 +2006-03-28 23:09:33.3154+02 1 10 0 0 +2006-03-28 23:09:33.337366+02 1 11 0 0 +2006-03-28 23:09:33.357016+02 1 12 0 0 +2006-03-28 23:09:33.376724+02 1 13 7880337 14338168 +2006-03-28 23:09:33.396546+02 1 14 7845454 14268425 +2006-03-28 23:09:33.416402+02 1 15 8189578 17433278 +2006-03-28 23:09:33.436008+02 1 16 0 0 +2006-03-28 23:09:33.455964+02 1 17 0 0 +2006-03-28 23:09:33.475705+02 1 18 0 0 +2006-03-28 23:09:33.495599+02 1 19 138538669 203617075 +2006-03-28 23:09:33.515334+02 1 20 200004048 208829958 +2006-03-28 23:09:33.535467+02 1 21 6478630 14226719 +2006-03-28 23:09:33.556044+02 1 22 0 0 +2006-03-28 23:09:33.575656+02 1 23 0 0 +2006-03-28 23:09:33.595203+02 1 24 0 0 +2006-03-28 23:09:35.995013+02 1 1 0 0 +2006-03-28 23:09:36.014831+02 1 2 0 0 +2006-03-28 23:09:36.035206+02 1 3 0 0 +2006-03-28 23:09:36.054957+02 1 4 0 0 +2006-03-28 23:09:36.074448+02 1 5 0 0 +2006-03-28 23:09:36.094459+02 1 6 0 0 +2006-03-28 23:09:36.114187+02 1 7 0 0 +2006-03-28 23:09:36.134162+02 1 8 0 0 +2006-03-28 23:09:36.153924+02 1 9 0 0 +2006-03-28 23:09:36.173467+02 1 10 0 0 +2006-03-28 23:09:36.192962+02 1 11 0 0 +2006-03-28 23:09:36.212584+02 1 12 0 0 +2006-03-28 23:09:36.232421+02 1 13 7880337 14338168 +2006-03-28 23:09:36.252247+02 1 14 7845454 14268425 +2006-03-28 23:09:36.271956+02 1 15 8189578 17433278 +2006-03-28 23:09:36.291855+02 1 16 0 0 +2006-03-28 23:09:36.311497+02 1 17 0 0 +2006-03-28 23:09:36.331351+02 1 18 0 0 +2006-03-28 23:09:36.351106+02 1 19 138538669 203617075 +2006-03-28 23:09:36.371495+02 1 20 200004048 208829958 +2006-03-28 23:09:36.391472+02 1 21 6478630 14226719 +2006-03-28 23:09:36.411218+02 1 22 0 0 +2006-03-28 23:09:36.432314+02 1 23 0 0 +2006-03-28 23:09:36.452165+02 1 24 0 0 +2006-03-28 23:15:40.752379+02 1 1 0 0 +2006-03-28 23:15:40.772684+02 1 2 0 0 +2006-03-28 23:15:40.792228+02 1 3 0 0 +2006-03-28 23:15:40.811814+02 1 4 0 0 +2006-03-28 23:15:40.83156+02 1 5 0 0 +2006-03-28 23:15:40.851352+02 1 6 0 0 +2006-03-28 23:15:40.870986+02 1 7 0 0 +2006-03-28 23:15:40.890991+02 1 8 0 0 +2006-03-28 23:15:40.911205+02 1 9 0 0 +2006-03-28 23:15:40.931349+02 1 10 0 0 +2006-03-28 23:15:40.951733+02 1 11 0 0 +2006-03-28 23:15:40.971545+02 1 12 0 0 +2006-03-28 23:15:40.991322+02 1 13 7911314 14387025 +2006-03-28 23:15:41.010894+02 1 14 7871637 14313012 +2006-03-28 23:15:41.031336+02 1 15 8219073 17479349 +2006-03-28 23:15:41.051693+02 1 16 0 0 +2006-03-28 23:15:41.071363+02 1 17 0 0 +2006-03-28 23:15:41.091194+02 1 18 0 0 +2006-03-28 23:15:41.111185+02 1 19 138562273 203670334 +2006-03-28 23:15:41.131322+02 1 20 200037822 208897207 +2006-03-28 23:15:41.15099+02 1 21 6502475 14279258 +2006-03-28 23:15:41.171033+02 1 22 0 0 +2006-03-28 23:15:41.190836+02 1 23 0 0 +2006-03-28 23:15:41.210909+02 1 24 0 0 +2006-03-28 23:16:18.461384+02 1 1 0 0 +2006-03-28 23:16:18.481697+02 1 2 0 0 +2006-03-28 23:16:18.501411+02 1 3 0 0 +2006-03-28 23:16:18.521355+02 1 4 0 0 +2006-03-28 23:16:18.541475+02 1 5 0 0 +2006-03-28 23:16:18.561151+02 1 6 0 0 +2006-03-28 23:16:18.581281+02 1 7 0 0 +2006-03-28 23:16:18.601048+02 1 8 0 0 +2006-03-28 23:16:18.621418+02 1 9 0 0 +2006-03-28 23:16:18.641084+02 1 10 0 0 +2006-03-28 23:16:18.660893+02 1 11 0 0 +2006-03-28 23:16:18.680749+02 1 12 0 0 +2006-03-28 23:16:18.700982+02 1 13 7914272 14391758 +2006-03-28 23:16:18.720543+02 1 14 7874595 14317587 +2006-03-28 23:16:18.740221+02 1 15 8221649 17484018 +2006-03-28 23:16:18.760369+02 1 16 0 0 +2006-03-28 23:16:18.780054+02 1 17 0 0 +2006-03-28 23:16:18.800943+02 1 18 0 0 +2006-03-28 23:16:18.820712+02 1 19 138564103 203674931 +2006-03-28 23:16:18.84036+02 1 20 200041217 208903898 +2006-03-28 23:16:18.860027+02 1 21 6506271 14285384 +2006-03-28 23:16:18.87964+02 1 22 0 0 +2006-03-28 23:16:18.899632+02 1 23 0 0 +2006-03-28 23:16:18.919771+02 1 24 0 0 +2006-03-29 14:21:06.538631+02 1 1 0 0 +2006-03-29 14:21:06.566347+02 1 2 0 0 +2006-03-29 14:21:06.586281+02 1 3 0 0 +2006-03-29 14:21:06.606101+02 1 4 0 0 +2006-03-29 14:21:06.626253+02 1 5 0 0 +2006-03-29 14:21:06.646471+02 1 6 0 0 +2006-03-29 14:21:06.666186+02 1 7 0 0 +2006-03-29 14:21:06.685778+02 1 8 0 0 +2006-03-29 14:21:06.705397+02 1 9 0 0 +2006-03-29 14:21:06.725104+02 1 10 0 0 +2006-03-29 14:21:06.745612+02 1 11 0 0 +2006-03-29 14:21:06.765703+02 1 12 0 0 +2006-03-29 14:21:06.785214+02 1 13 11913823 21156032 +2006-03-29 14:21:06.805512+02 1 14 11834383 21035751 +2006-03-29 14:21:06.825285+02 1 15 12216402 24218350 +2006-03-29 14:21:06.845644+02 1 16 0 0 +2006-03-29 14:21:06.865666+02 1 17 0 0 +2006-03-29 14:21:06.885942+02 1 18 0 0 +2006-03-29 14:21:06.905781+02 1 19 142415383 211673321 +2006-03-29 14:21:06.926271+02 1 20 205266368 218989817 +2006-03-29 14:21:06.946227+02 1 21 10315756 22231663 +2006-03-29 14:21:06.966297+02 1 22 0 0 +2006-03-29 14:21:06.985762+02 1 23 0 0 +2006-03-29 14:21:07.005733+02 1 24 0 0 +\. + + +-- +-- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres +-- + +COPY portnames (switchtype, port, description) FROM stdin; +blackdiamond 1001 BD6808/G8Xi-Port 1:1 +blackdiamond 1002 BD6808/G8Xi-Port 1:2 +blackdiamond 1003 BD6808/G8Xi-Port 1:3 +blackdiamond 1004 BD6808/G8Xi-Port 1:4 +blackdiamond 1005 BD6808/G8Xi-Port 1:5 +blackdiamond 1006 BD6808/G8Xi-Port 1:6 +blackdiamond 1007 BD6808/G8Xi-Port 1:7 +blackdiamond 4001 BD6808/G16X3-Port 4:1 +blackdiamond 4002 BD6808/G16X3-Port 4:2 +blackdiamond 4003 BD6808/G16X3-Port 4:3 +blackdiamond 4004 BD6808/G16X3-Port 4:4 +blackdiamond 4005 BD6808/G16X3-Port 4:5 +blackdiamond 4006 BD6808/G16X3-Port 4:6 +blackdiamond 4007 BD6808/G16X3-Port 4:7 +blackdiamond 4008 BD6808/G16X3-Port 4:8 +blackdiamond 4009 BD6808/G16X3-Port 4:9 +blackdiamond 4010 BD6808/G16X3-Port 4:10 +blackdiamond 4011 BD6808/G16X3-Port 4:11 +blackdiamond 4012 BD6808/G16X3-Port 4:12 +blackdiamond 4013 BD6808/G16X3-Port 4:13 +blackdiamond 4014 BD6808/G16X3-Port 4:14 +blackdiamond 4015 BD6808/G16X3-Port 4:15 +blackdiamond 4016 BD6808/G16X3-Port 4:16 +blackdiamond 5001 BD6808/G24T3-Port 5:1 +blackdiamond 5002 BD6808/G24T3-Port 5:2 +blackdiamond 5003 BD6808/G24T3-Port 5:3 +blackdiamond 5004 BD6808/G24T3-Port 5:4 +blackdiamond 5005 BD6808/G24T3-Port 5:5 +blackdiamond 5006 BD6808/G24T3-Port 5:6 +blackdiamond 5007 BD6808/G24T3-Port 5:7 +blackdiamond 5008 BD6808/G24T3-Port 5:8 +blackdiamond 5009 BD6808/G24T3-Port 5:9 +blackdiamond 5010 BD6808/G24T3-Port 5:10 +blackdiamond 5011 BD6808/G24T3-Port 5:11 +blackdiamond 5012 BD6808/G24T3-Port 5:12 +blackdiamond 5013 BD6808/G24T3-Port 5:13 +blackdiamond 5014 BD6808/G24T3-Port 5:14 +blackdiamond 5015 BD6808/G24T3-Port 5:15 +blackdiamond 5016 BD6808/G24T3-Port 5:16 +blackdiamond 5017 BD6808/G24T3-Port 5:17 +blackdiamond 5018 BD6808/G24T3-Port 5:18 +blackdiamond 5019 BD6808/G24T3-Port 5:19 +blackdiamond 5020 BD6808/G24T3-Port 5:20 +blackdiamond 5021 BD6808/G24T3-Port 5:21 +blackdiamond 5022 BD6808/G24T3-Port 5:22 +blackdiamond 5023 BD6808/G24T3-Port 5:23 +blackdiamond 5024 BD6808/G24T3-Port 5:24 +blackdiamond 6001 BD6808/F48Ti-Port 6:1 +blackdiamond 6002 BD6808/F48Ti-Port 6:2 +blackdiamond 6003 BD6808/F48Ti-Port 6:3 +blackdiamond 6004 BD6808/F48Ti-Port 6:4 +blackdiamond 6005 BD6808/F48Ti-Port 6:5 +blackdiamond 6006 BD6808/F48Ti-Port 6:6 +blackdiamond 6007 BD6808/F48Ti-Port 6:7 +blackdiamond 6008 BD6808/F48Ti-Port 6:8 +blackdiamond 6009 BD6808/F48Ti-Port 6:9 +blackdiamond 6010 BD6808/F48Ti-Port 6:10 +blackdiamond 6011 BD6808/F48Ti-Port 6:11 +blackdiamond 6012 BD6808/F48Ti-Port 6:12 +blackdiamond 6013 BD6808/F48Ti-Port 6:13 +blackdiamond 6014 BD6808/F48Ti-Port 6:14 +blackdiamond 6015 BD6808/F48Ti-Port 6:15 +blackdiamond 6016 BD6808/F48Ti-Port 6:16 +blackdiamond 6017 BD6808/F48Ti-Port 6:17 +blackdiamond 6018 BD6808/F48Ti-Port 6:18 +blackdiamond 6019 BD6808/F48Ti-Port 6:19 +blackdiamond 6020 BD6808/F48Ti-Port 6:20 +blackdiamond 6021 BD6808/F48Ti-Port 6:21 +blackdiamond 6022 BD6808/F48Ti-Port 6:22 +blackdiamond 6023 BD6808/F48Ti-Port 6:23 +blackdiamond 6024 BD6808/F48Ti-Port 6:24 +blackdiamond 6025 BD6808/F48Ti-Port 6:25 +blackdiamond 6026 BD6808/F48Ti-Port 6:26 +blackdiamond 6027 BD6808/F48Ti-Port 6:27 +blackdiamond 6028 BD6808/F48Ti-Port 6:28 +blackdiamond 6029 BD6808/F48Ti-Port 6:29 +blackdiamond 6030 BD6808/F48Ti-Port 6:30 +blackdiamond 6031 BD6808/F48Ti-Port 6:31 +blackdiamond 6032 BD6808/F48Ti-Port 6:32 +blackdiamond 6033 BD6808/F48Ti-Port 6:33 +blackdiamond 6034 BD6808/F48Ti-Port 6:34 +blackdiamond 6035 BD6808/F48Ti-Port 6:35 +blackdiamond 6036 BD6808/F48Ti-Port 6:36 +blackdiamond 6037 BD6808/F48Ti-Port 6:37 +blackdiamond 6038 BD6808/F48Ti-Port 6:38 +blackdiamond 6039 BD6808/F48Ti-Port 6:39 +blackdiamond 6040 BD6808/F48Ti-Port 6:40 +blackdiamond 6041 BD6808/F48Ti-Port 6:41 +blackdiamond 6042 BD6808/F48Ti-Port 6:42 +blackdiamond 6043 BD6808/F48Ti-Port 6:43 +blackdiamond 6044 BD6808/F48Ti-Port 6:44 +blackdiamond 6045 BD6808/F48Ti-Port 6:45 +blackdiamond 6046 BD6808/F48Ti-Port 6:46 +blackdiamond 6047 BD6808/F48Ti-Port 6:47 +blackdiamond 6048 BD6808/F48Ti-Port 6:48 +cisco6509 1 GigabitEthernet1/1 +cisco6509 2 GigabitEthernet1/2 +cisco6509 3 GigabitEthernet1/3 +cisco6509 4 GigabitEthernet1/4 +cisco6509 5 GigabitEthernet1/5 +cisco6509 6 GigabitEthernet1/6 +cisco6509 7 GigabitEthernet1/7 +cisco6509 8 GigabitEthernet1/8 +cisco6509 9 GigabitEthernet1/9 +cisco6509 10 GigabitEthernet1/10 +cisco6509 11 GigabitEthernet1/11 +cisco6509 12 GigabitEthernet1/12 +cisco6509 13 GigabitEthernet1/13 +cisco6509 14 GigabitEthernet1/14 +cisco6509 15 GigabitEthernet1/15 +cisco6509 16 GigabitEthernet1/16 +cisco6509 17 GigabitEthernet1/17 +cisco6509 18 GigabitEthernet1/18 +cisco6509 19 GigabitEthernet1/19 +cisco6509 20 GigabitEthernet1/20 +cisco6509 21 GigabitEthernet1/21 +cisco6509 22 GigabitEthernet1/22 +cisco6509 23 GigabitEthernet1/23 +cisco6509 24 GigabitEthernet1/24 +cisco6509 25 GigabitEthernet1/25 +cisco6509 26 GigabitEthernet1/26 +cisco6509 27 GigabitEthernet1/27 +cisco6509 28 GigabitEthernet1/28 +cisco6509 29 GigabitEthernet1/29 +cisco6509 30 GigabitEthernet1/30 +cisco6509 31 GigabitEthernet1/31 +cisco6509 32 GigabitEthernet1/32 +cisco6509 33 GigabitEthernet1/33 +cisco6509 34 GigabitEthernet1/34 +cisco6509 35 GigabitEthernet1/35 +cisco6509 36 GigabitEthernet1/36 +cisco6509 37 GigabitEthernet1/37 +cisco6509 38 GigabitEthernet1/38 +cisco6509 39 GigabitEthernet1/39 +cisco6509 40 GigabitEthernet1/40 +cisco6509 41 GigabitEthernet1/41 +cisco6509 42 GigabitEthernet1/42 +cisco6509 43 GigabitEthernet1/43 +cisco6509 44 GigabitEthernet1/44 +cisco6509 45 GigabitEthernet1/45 +cisco6509 46 GigabitEthernet1/46 +cisco6509 47 GigabitEthernet1/47 +cisco6509 48 GigabitEthernet1/48 +cisco6509 49 GigabitEthernet2/1 +cisco6509 50 GigabitEthernet2/2 +cisco6509 51 GigabitEthernet2/3 +cisco6509 52 GigabitEthernet2/4 +cisco6509 53 GigabitEthernet2/5 +cisco6509 54 GigabitEthernet2/6 +cisco6509 55 GigabitEthernet2/7 +cisco6509 56 GigabitEthernet2/8 +cisco6509 57 GigabitEthernet2/9 +cisco6509 58 GigabitEthernet2/10 +cisco6509 59 GigabitEthernet2/11 +cisco6509 60 GigabitEthernet2/12 +cisco6509 61 GigabitEthernet2/13 +cisco6509 62 GigabitEthernet2/14 +cisco6509 63 GigabitEthernet2/15 +cisco6509 64 GigabitEthernet2/16 +cisco6509 65 FastEthernet4/1 +cisco6509 66 FastEthernet4/2 +cisco6509 67 FastEthernet4/3 +cisco6509 68 FastEthernet4/4 +cisco6509 69 FastEthernet4/5 +cisco6509 70 FastEthernet4/6 +cisco6509 71 FastEthernet4/7 +cisco6509 72 FastEthernet4/8 +cisco6509 73 FastEthernet4/9 +cisco6509 74 FastEthernet4/10 +cisco6509 75 FastEthernet4/11 +cisco6509 76 FastEthernet4/12 +cisco6509 77 FastEthernet4/13 +cisco6509 78 FastEthernet4/14 +cisco6509 79 FastEthernet4/15 +cisco6509 80 FastEthernet4/16 +cisco6509 81 FastEthernet4/17 +cisco6509 82 FastEthernet4/18 +cisco6509 83 FastEthernet4/19 +cisco6509 84 FastEthernet4/20 +cisco6509 85 FastEthernet4/21 +cisco6509 86 FastEthernet4/22 +cisco6509 87 FastEthernet4/23 +cisco6509 88 FastEthernet4/24 +cisco6509 89 FastEthernet4/25 +cisco6509 90 FastEthernet4/26 +cisco6509 91 FastEthernet4/27 +cisco6509 92 FastEthernet4/28 +cisco6509 93 FastEthernet4/29 +cisco6509 94 FastEthernet4/30 +cisco6509 95 FastEthernet4/31 +cisco6509 96 FastEthernet4/32 +cisco6509 97 FastEthernet4/33 +cisco6509 98 FastEthernet4/34 +cisco6509 99 FastEthernet4/35 +cisco6509 100 FastEthernet4/36 +cisco6509 101 FastEthernet4/37 +cisco6509 102 FastEthernet4/38 +cisco6509 103 FastEthernet4/39 +cisco6509 104 FastEthernet4/40 +cisco6509 105 FastEthernet4/41 +cisco6509 106 FastEthernet4/42 +cisco6509 107 FastEthernet4/43 +cisco6509 108 FastEthernet4/44 +cisco6509 109 FastEthernet4/45 +cisco6509 110 FastEthernet4/46 +cisco6509 111 FastEthernet4/47 +cisco6509 112 FastEthernet4/48 +cisco6509 113 GigabitEthernet5/1 +cisco6509 114 GigabitEthernet5/2 +cisco6509 115 GigabitEthernet8/1 +cisco6509 116 GigabitEthernet8/2 +cisco6509 117 GigabitEthernet8/3 +cisco6509 118 GigabitEthernet8/4 +cisco6509 119 GigabitEthernet8/5 +cisco6509 120 GigabitEthernet8/6 +cisco6509 121 GigabitEthernet8/7 +cisco6509 122 GigabitEthernet8/8 +cisco6509 123 GigabitEthernet8/9 +\. + + +-- +-- Data for Name: squeue; Type: TABLE DATA; Schema: public; Owner: nms +-- + +COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin; +\. + + +-- +-- Data for Name: switches; Type: TABLE DATA; Schema: public; Owner: postgres +-- + +COPY switches (switch, ip, sysname, switchtype, last_updated, locked, priority, poll_frequency, community) FROM stdin; +210 81.162.239.10 noc cisco6509 2005-03-27 13:21:26.109659+02 f 5 00:00:20 removed +1 62.148.36.20 zorro cisco6509 2006-03-29 14:21:06.525009+02 f 5 00:01:00 tg06 +\. + + +-- +-- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: postgres +-- + +COPY switchtypes (switchtype, ports, wide_counters) FROM stdin; +blackdiamond 1001-1007,4001-4016,5001-5024,6001-6048 f +es3024 1-25 f +summit400 1-50 f +cisco3550 1-50 f +summit7i 1-32 f +summit48 1-50 f +cisco6509 1-24 t +\. + + +-- +-- Data for Name: temppoll; Type: TABLE DATA; Schema: public; Owner: postgres +-- + +COPY temppoll (id, "time", switch, "temp") FROM stdin; +\. + + +-- +-- Name: cpuloadpoll_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: +-- + +ALTER TABLE ONLY cpuloadpoll + ADD CONSTRAINT cpuloadpoll_pkey PRIMARY KEY (id); + + +-- +-- Name: public; Type: ACL; Schema: -; Owner: postgres +-- + +REVOKE ALL ON SCHEMA public FROM PUBLIC; +REVOKE ALL ON SCHEMA public FROM postgres; +GRANT ALL ON SCHEMA public TO postgres; +GRANT ALL ON SCHEMA public TO PUBLIC; + + +-- +-- Name: cpuloadpoll; Type: ACL; Schema: public; Owner: sesse +-- + +REVOKE ALL ON TABLE cpuloadpoll FROM PUBLIC; +REVOKE ALL ON TABLE cpuloadpoll FROM sesse; +GRANT ALL ON TABLE cpuloadpoll TO sesse; +GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll TO nms; + + +-- +-- Name: cpuloadpoll_id_seq; Type: ACL; Schema: public; Owner: sesse +-- + +REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM PUBLIC; +REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM sesse; +GRANT ALL ON TABLE cpuloadpoll_id_seq TO sesse; +GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll_id_seq TO nms; + + +-- +-- Name: polls; Type: ACL; Schema: public; Owner: postgres +-- + +REVOKE ALL ON TABLE polls FROM PUBLIC; +REVOKE ALL ON TABLE polls FROM postgres; +GRANT ALL ON TABLE polls TO postgres; +GRANT INSERT ON TABLE polls TO nms; + + +-- +-- Name: switches; Type: ACL; Schema: public; Owner: postgres +-- + +REVOKE ALL ON TABLE switches FROM PUBLIC; +REVOKE ALL ON TABLE switches FROM postgres; +GRANT ALL ON TABLE switches TO postgres; +GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE switches TO nms; + + +-- +-- Name: switchtypes; Type: ACL; Schema: public; Owner: postgres +-- + +REVOKE ALL ON TABLE switchtypes FROM PUBLIC; +REVOKE ALL ON TABLE switchtypes FROM postgres; +GRANT ALL ON TABLE switchtypes TO postgres; +GRANT SELECT ON TABLE switchtypes TO nms; + + +-- +-- PostgreSQL database dump complete +-- +