C:/Program Files/PostgreSQL/9.1/bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "postgres" --no-password --verbose "D:\base\modis1.backup" pg_restore: pg_restore: TABLE data pg_restore: [ ()] : pg_restore: [ ()] 178; 1259 25091 TABLE data postgres pg_restore: [ ()] could not execute query: ОШИБКА: тип "geometry" не существует 12: the_geom geometry, ^ Command was: CREATE TABLE data ( id integer NOT NULL, longitude double precision, latitude double precision, depth intege... pg_restore: [ ()] could not execute query: ОШИБКА: отношение "public.data" не существует Command was: ALTER TABLE public.data OWNER TO postgres; pg_restore: SEQUENCE data_id_seq pg_restore: SEQUENCE OWNED BY data_id_seq pg_restore: [ ()] 2799; 0 0 SEQUENCE OWNED BY data_id_seq postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER SEQUENCE data_id_seq OWNED BY data.id; pg_restore: SEQUENCE SET data_id_seq pg_restore: DEFAULT id pg_restore: [ ()] 2786; 2604 25094 DEFAULT id postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER TABLE data ALTER COLUMN id SET DEFAULT nextval('data_id_seq'::regclass); pg_restore: "data" pg_restore: [ ()] 2796; 0 25091 TABLE DATA data postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: COPY data (id, longitude, latitude, depth, chl_carder_raw, chl_carder, par_raw, par, sst_raw, sst, the_geom, m_date, flh, kd... pg_restore: CONSTRAINT data_pkey pg_restore: [ ()] 2794; 2606 25099 CONSTRAINT data_pkey postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER TABLE ONLY data ADD CONSTRAINT data_pkey PRIMARY KEY (id); pg_restore: INDEX data_chl_carder_idx pg_restore: [ ()] 2790; 1259 119362 INDEX data_chl_carder_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_chl_carder_idx ON data USING btree (chl_carder); pg_restore: INDEX data_longitude_latitude_idx pg_restore: [ ()] 2791; 1259 27147 INDEX data_longitude_latitude_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_longitude_latitude_idx ON data USING btree (longitude, latitude); pg_restore: INDEX data_m_date_idx pg_restore: [ ()] 2792; 1259 27148 INDEX data_m_date_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_m_date_idx ON data USING btree (m_date); pg_restore: TRIGGER convert_coord pg_restore: [ ()] 2795; 2620 25114 TRIGGER convert_coord postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE TRIGGER convert_coord BEFORE INSERT OR UPDATE OF latitude, longitude ON data FOR EACH ROW EXECUTE PROCEDURE convert_c... pg_restore: : TABLE data pg_restore: : SEQUENCE data_id_seq pg_restore: : SEQUENCE OWNED BY data_id_seq pg_restore: : SEQUENCE SET data_id_seq pg_restore: : DEFAULT id pg_restore: : TABLE DATA data pg_restore: : CONSTRAINT data_pkey pg_restore: : INDEX data_chl_carder_idx pg_restore: : INDEX data_longitude_latitude_idx pg_restore: : INDEX data_m_date_idx pg_restore: : TRIGGER convert_coord : : 10 1. C:/Program Files/PostgreSQL/9.1/bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "postgres" --no-password --verbose "D:\base\modis1.backup" pg_restore: pg_restore: TABLE data pg_restore: [ ()] : pg_restore: [ ()] 178; 1259 25091 TABLE data postgres pg_restore: [ ()] could not execute query: ОШИБКА: тип "geometry" не существует 12: the_geom geometry, ^ Command was: CREATE TABLE data ( id integer NOT NULL, longitude double precision, latitude double precision, depth intege... pg_restore: [ ()] could not execute query: ОШИБКА: отношение "public.data" не существует Command was: ALTER TABLE public.data OWNER TO postgres; pg_restore: SEQUENCE data_id_seq pg_restore: [ ()] 177; 1259 25089 SEQUENCE data_id_seq postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data_id_seq" уже существует Command was: CREATE SEQUENCE data_id_seq START WITH 1 INCREMENT BY 1 MINVALUE 0 NO MAXVALUE CACHE 1; pg_restore: SEQUENCE OWNED BY data_id_seq pg_restore: [ ()] 2799; 0 0 SEQUENCE OWNED BY data_id_seq postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER SEQUENCE data_id_seq OWNED BY data.id; pg_restore: SEQUENCE SET data_id_seq pg_restore: DEFAULT id pg_restore: [ ()] 2786; 2604 25094 DEFAULT id postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER TABLE data ALTER COLUMN id SET DEFAULT nextval('data_id_seq'::regclass); pg_restore: "data" pg_restore: [ ()] 2796; 0 25091 TABLE DATA data postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: COPY data (id, longitude, latitude, depth, chl_carder_raw, chl_carder, par_raw, par, sst_raw, sst, the_geom, m_date, flh, kd... pg_restore: CONSTRAINT data_pkey pg_restore: [ ()] 2794; 2606 25099 CONSTRAINT data_pkey postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER TABLE ONLY data ADD CONSTRAINT data_pkey PRIMARY KEY (id); pg_restore: INDEX data_chl_carder_idx pg_restore: [ ()] 2790; 1259 119362 INDEX data_chl_carder_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_chl_carder_idx ON data USING btree (chl_carder); pg_restore: INDEX data_longitude_latitude_idx pg_restore: [ ()] 2791; 1259 27147 INDEX data_longitude_latitude_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_longitude_latitude_idx ON data USING btree (longitude, latitude); pg_restore: INDEX data_m_date_idx pg_restore: [ ()] 2792; 1259 27148 INDEX data_m_date_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_m_date_idx ON data USING btree (m_date); pg_restore: TRIGGER convert_coord pg_restore: [ ()] 2795; 2620 25114 TRIGGER convert_coord postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE TRIGGER convert_coord BEFORE INSERT OR UPDATE OF latitude, longitude ON data FOR EACH ROW EXECUTE PROCEDURE convert_c... pg_restore: : TABLE data pg_restore: : SEQUENCE data_id_seq pg_restore: : SEQUENCE OWNED BY data_id_seq pg_restore: : SEQUENCE SET data_id_seq pg_restore: : DEFAULT id pg_restore: : TABLE DATA data pg_restore: : CONSTRAINT data_pkey pg_restore: : INDEX data_chl_carder_idx pg_restore: : INDEX data_longitude_latitude_idx pg_restore: : INDEX data_m_date_idx pg_restore: : TRIGGER convert_coord : : 11 1. C:/Program Files/PostgreSQL/9.1/bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "postgres" --no-password --verbose "D:\base\modis1.backup" pg_restore: pg_restore: TABLE data pg_restore: [ ()] : pg_restore: [ ()] 178; 1259 25091 TABLE data postgres pg_restore: [ ()] could not execute query: ОШИБКА: тип "geometry" не существует 12: the_geom geometry, ^ Command was: CREATE TABLE data ( id integer NOT NULL, longitude double precision, latitude double precision, depth intege... pg_restore: [ ()] could not execute query: ОШИБКА: отношение "public.data" не существует Command was: ALTER TABLE public.data OWNER TO postgres; pg_restore: SEQUENCE data_id_seq pg_restore: [ ()] 177; 1259 25089 SEQUENCE data_id_seq postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data_id_seq" уже существует Command was: CREATE SEQUENCE data_id_seq START WITH 1 INCREMENT BY 1 MINVALUE 0 NO MAXVALUE CACHE 1; pg_restore: SEQUENCE OWNED BY data_id_seq pg_restore: [ ()] 2799; 0 0 SEQUENCE OWNED BY data_id_seq postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER SEQUENCE data_id_seq OWNED BY data.id; pg_restore: SEQUENCE SET data_id_seq pg_restore: DEFAULT id pg_restore: [ ()] 2786; 2604 25094 DEFAULT id postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER TABLE data ALTER COLUMN id SET DEFAULT nextval('data_id_seq'::regclass); pg_restore: "data" pg_restore: [ ()] 2796; 0 25091 TABLE DATA data postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: COPY data (id, longitude, latitude, depth, chl_carder_raw, chl_carder, par_raw, par, sst_raw, sst, the_geom, m_date, flh, kd... pg_restore: CONSTRAINT data_pkey pg_restore: [ ()] 2794; 2606 25099 CONSTRAINT data_pkey postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: ALTER TABLE ONLY data ADD CONSTRAINT data_pkey PRIMARY KEY (id); pg_restore: INDEX data_chl_carder_idx pg_restore: [ ()] 2790; 1259 119362 INDEX data_chl_carder_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_chl_carder_idx ON data USING btree (chl_carder); pg_restore: INDEX data_longitude_latitude_idx pg_restore: [ ()] 2791; 1259 27147 INDEX data_longitude_latitude_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_longitude_latitude_idx ON data USING btree (longitude, latitude); pg_restore: INDEX data_m_date_idx pg_restore: [ ()] 2792; 1259 27148 INDEX data_m_date_idx postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE INDEX data_m_date_idx ON data USING btree (m_date); pg_restore: TRIGGER convert_coord pg_restore: [ ()] 2795; 2620 25114 TRIGGER convert_coord postgres pg_restore: [ ()] could not execute query: ОШИБКА: отношение "data" не существует Command was: CREATE TRIGGER convert_coord BEFORE INSERT OR UPDATE OF latitude, longitude ON data FOR EACH ROW EXECUTE PROCEDURE convert_c... pg_restore: : TABLE data pg_restore: : SEQUENCE data_id_seq pg_restore: : SEQUENCE OWNED BY data_id_seq pg_restore: : SEQUENCE SET data_id_seq pg_restore: : DEFAULT id pg_restore: : TABLE DATA data pg_restore: : CONSTRAINT data_pkey pg_restore: : INDEX data_chl_carder_idx pg_restore: : INDEX data_longitude_latitude_idx pg_restore: : INDEX data_m_date_idx pg_restore: : TRIGGER convert_coord : : 11 1.