Thread: transfer database from Linux to Windows
Dear all, How to copy all tables and views from Linux PostgreSQL to Windows? The database under Linux is PostGIS enabled. By default pg_dump saves all PostGIS's CREATE FUNCTION commands that are pointed to the Linux's *.so files. In order to properly create database under Windows I would like to do following: 1. Create database under windows 2 create all functions pointing to *.dll using provided sql file 3 Backup all tables and views with their rools 4 Restore backup under Windows Are those steps correct? How do I perform steps 3 and 4? Thanks a lot in advance Oleg
On 12/20/05, Oleg <evdakov@iwk.uka.de> wrote: > Dear all, > How to copy all tables and views from Linux PostgreSQL to Windows? The > database under Linux is PostGIS enabled. By default pg_dump saves all > PostGIS's CREATE FUNCTION commands that are pointed to the Linux's *.so > files. when you install postgres with the pgInstaller you can choose to enable postgis by default... just running the sql generated by pg_dump should work... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
Tom, Jaime Thank you very much for your help. It works like this: 1. Under Linux: pg_dump fgm_gis_2 > fgm_gis_2_dump 2. Under Windows: a) Create database b) check whether plpgsql is enabled. if not then: createlang plpgsql fgm_gis_02 c) psql -f (lw)postgis.sql -d fgm_gis_02 d) psql -f fgm_gis_2_dump -d fgm_gis_02 -U postgres I am getting lots of Errors like Duplicating primary key is no allowed etc. Can I ignore them? Best regards Oleg
On 12/20/05, Oleg <evdakov@iwk.uka.de> wrote: > Tom, Jaime > Thank you very much for your help. > It works like this: > 1. Under Linux: pg_dump fgm_gis_2 > fgm_gis_2_dump > 2. Under Windows: > a) Create database > b) check whether plpgsql is enabled. if not then: createlang plpgsql fgm_gis_02 > c) psql -f (lw)postgis.sql -d fgm_gis_02 > d) psql -f fgm_gis_2_dump -d fgm_gis_02 -U postgres > > I am getting lots of Errors like > Duplicating primary key is no allowed > etc. > Can I ignore them? > Best regards > Oleg > Can you us the exact errors, please? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
On 12/20/05, Jaime Casanova <systemguards@gmail.com> wrote: > On 12/20/05, Oleg <evdakov@iwk.uka.de> wrote: > > Tom, Jaime > > Thank you very much for your help. > > It works like this: > > 1. Under Linux: pg_dump fgm_gis_2 > fgm_gis_2_dump > > 2. Under Windows: > > a) Create database > > b) check whether plpgsql is enabled. if not then: createlang plpgsql fgm_gis_02 > > c) psql -f (lw)postgis.sql -d fgm_gis_02 > > d) psql -f fgm_gis_2_dump -d fgm_gis_02 -U postgres > > > > I am getting lots of Errors like > > Duplicating primary key is no allowed > > etc. > > Can I ignore them? > > Best regards > > Oleg > > > > Can you us the exact errors, please? > Can you show us the exact errors, please? PS: i couldn't stop the buggy message :( > -- > regards, > Jaime Casanova > (DBA: DataBase Aniquilator ;) > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)
Jaime I was trying to redirect errors from the screen to log file I tried: psql -d mydb -U postgres -f dumpfile.sql > output.txt This gives only successful commands see attached psql_output.txt psql -d mydb -U postgres -f dumpfile.sql > output.txt 2>&1 Does not allow me to enter password What should I do? Thanks a lot in advance Oleg Jaime Casanova schrieb: >On 12/20/05, Jaime Casanova <systemguards@gmail.com> wrote: > > >>On 12/20/05, Oleg <evdakov@iwk.uka.de> wrote: >> >> >>>Tom, Jaime >>>Thank you very much for your help. >>>It works like this: >>>1. Under Linux: pg_dump fgm_gis_2 > fgm_gis_2_dump >>>2. Under Windows: >>> a) Create database >>> b) check whether plpgsql is enabled. if not then: createlang plpgsql fgm_gis_02 >>> c) psql -f (lw)postgis.sql -d fgm_gis_02 >>> d) psql -f fgm_gis_2_dump -d fgm_gis_02 -U postgres >>> >>>I am getting lots of Errors like >>>Duplicating primary key is no allowed >>>etc. >>>Can I ignore them? >>>Best regards >>>Oleg >>> >>> >>> >>Can you us the exact errors, please? >> >> >> > >Can you show us the exact errors, please? > >PS: i couldn't stop the buggy message :( > > > >>-- >>regards, >>Jaime Casanova >>(DBA: DataBase Aniquilator ;) >> >> >> > > >-- >Atentamente, >Jaime Casanova >(DBA: DataBase Aniquilator ;) > > > SET SET SET SET SET REVOKE REVOKE GRANT CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE SET SET SET CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE VIEW SET CREATE VIEW CREATE TABLE CREATE TABLE CREATE VIEW CREATE VIEW CREATE VIEW CREATE TABLE CREATE TABLE CREATE TABLE CREATE VIEW CREATE VIEW CREATE VIEW CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE VIEW CREATE VIEW CREATE VIEW ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE SET COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT
always cc: list On 12/21/05, Oleg <evdakov@iwk.uka.de> wrote: > Jaime > I was trying to redirect errors from the screen to log file > I tried: > psql -d mydb -U postgres -f dumpfile.sql > output.txt > This gives only successful commands see attached psql_output.txt > > psql -d mydb -U postgres -f dumpfile.sql > output.txt 2>&1 > Does not allow me to enter password > > What should I do? > Thanks a lot in advance > Oleg > > psql -d mydb -U postgres -f dumpfile.sql 2> output.txt or activate log in postgresql.conf -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
Thanks a lot. Here is the copy of the log file. There are some lines that could be important: column "attrelid" of relation "geometry_columns" does not exist multiple primary keys for table "spatial_ref_sys" are not allowed multiple primary keys for table "geometry_columns" are not allowed Best regards Oleg Jaime Casanova schrieb: >always cc: list > >On 12/21/05, Oleg <evdakov@iwk.uka.de> wrote: > > >>Jaime >>I was trying to redirect errors from the screen to log file >>I tried: >>psql -d mydb -U postgres -f dumpfile.sql > output.txt >>This gives only successful commands see attached psql_output.txt >> >>psql -d mydb -U postgres -f dumpfile.sql > output.txt 2>&1 >>Does not allow me to enter password >> >>What should I do? >>Thanks a lot in advance >>Oleg >> >> >> >> > >psql -d mydb -U postgres -f dumpfile.sql 2> output.txt > >or activate log in postgresql.conf > >-- >regards, >Jaime Casanova >(DBA: DataBase Aniquilator ;) > > > 2005-12-21 16:46:32 ERROR: user "gg33" does not exist 2005-12-21 16:46:32 ERROR: function "plpgsql_call_handler" already exists with same argument types 2005-12-21 16:46:32 ERROR: language "plpgsql" already exists 2005-12-21 16:46:33 ERROR: user "gg26" does not exist 2005-12-21 16:46:33 ERROR: user "gg33" does not exist 2005-12-21 16:46:33 ERROR: function "histogram2d_in" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "histogram2d_out" already exists with same argument types 2005-12-21 16:46:33 ERROR: type "histogram2d" already exists 2005-12-21 16:46:33 ERROR: function "box3d_in" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "box3d_out" already exists with same argument types 2005-12-21 16:46:33 ERROR: type "box3d" already exists 2005-12-21 16:46:33 ERROR: function "spheroid_in" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "spheroid_out" already exists with same argument types 2005-12-21 16:46:33 ERROR: type "spheroid" already exists 2005-12-21 16:46:33 ERROR: function "wkb_in" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "wkb_out" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "wkb_recv" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "wkb_send" already exists with same argument types 2005-12-21 16:46:33 ERROR: type "wkb" already exists 2005-12-21 16:46:33 ERROR: function "chip_in" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "chip_out" already exists with same argument types 2005-12-21 16:46:33 ERROR: type "chip" already exists 2005-12-21 16:46:33 ERROR: function "geometry_in" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometry_out" already exists with same argument types 2005-12-21 16:46:33 ERROR: type "geometry" already exists 2005-12-21 16:46:33 ERROR: function "postgis_gist_sel" already exists with same argument types 2005-12-21 16:46:33 ERROR: relation "spatial_ref_sys" already exists 2005-12-21 16:46:33 ERROR: relation "geometry_columns" already exists 2005-12-21 16:46:33 ERROR: function "postgis_version" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_lib_version" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_geos_version" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_proj_version" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_scripts_installed" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_scripts_released" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_uses_stats" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "postgis_full_version" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "find_srid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "get_proj4_from_srid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "rename_geometry_table_constraints" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "fix_geometry_columns" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "probe_geometry_columns" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "find_extent" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "find_extent" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "transform_geometry" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "transform" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "srid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "height" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "factor" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "width" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "datatype" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "compression" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "setsrid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "setfactor" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometry" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "box3d" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "box" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometry" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometry" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "expand" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "expand" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "asbinary" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "asbinary" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "bytea" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometry" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "pointfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "pointfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linefromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linefromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linestringfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linestringfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polyfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polyfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polygonfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polygonfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpointfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpointfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipointfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipointfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multilinefromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multilinefromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mlinefromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mlinefromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpolyfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpolyfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipolyfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipolyfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomcollfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomcollfromwkb" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "npoints" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "nrings" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mem_size" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "summary" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "translate" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "dimension" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometrytype" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "envelope" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "x" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "y" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "z" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "numpoints" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "pointn" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "exteriorring" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "numinteriorrings" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "interiorringn" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "numgeometries" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometryn" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "max_distance" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "optimistic_overlap" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "segmentize" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "distance" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "astext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "srid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometryfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geometryfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polyfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polygonfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polygonfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpolyfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linefromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mlinefromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multilinestringfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multilinestringfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "pointfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpointfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipointfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipointfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomcollfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "setsrid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "polyfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpolyfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipolygonfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multipolygonfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linefromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linestringfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "linestringfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mlinefromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "pointfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "mpointfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "geomcollfromtext" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "isempty" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "issimple" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "equals" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "length_spheroid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "length3d_spheroid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "distance_spheroid" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "multi" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "length3d" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "length" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "area2d" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "area" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "perimeter3d" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "perimeter" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "point_inside_circle" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "startpoint" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "endpoint" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "isclosed" already exists with same argument types 2005-12-21 16:46:33 ERROR: function "centroid" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "isring" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "pointonsurface" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "xmin" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "ymin" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "zmin" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "xmax" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "ymax" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "zmax" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "box3dtobox" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geom_accum" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "combine_bbox" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "extent" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "collector" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "memcollect" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "collect_garray" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "collect" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_overleft" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_overright" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_left" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_right" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_contain" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_contained" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_overlap" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_same" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_lt" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_le" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_gt" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_ge" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_eq" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_cmp" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "force_2d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "force_3d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "force_collection" already exists with same argument types 2005-12-21 16:46:34 ERROR: operator >> already exists 2005-12-21 16:46:34 ERROR: operator << already exists 2005-12-21 16:46:34 ERROR: operator &> already exists 2005-12-21 16:46:34 ERROR: operator &< already exists 2005-12-21 16:46:34 ERROR: operator && already exists 2005-12-21 16:46:34 ERROR: operator ~= already exists 2005-12-21 16:46:34 ERROR: operator ~ already exists 2005-12-21 16:46:34 ERROR: operator @ already exists 2005-12-21 16:46:34 ERROR: operator > already exists 2005-12-21 16:46:34 ERROR: operator >= already exists 2005-12-21 16:46:34 ERROR: operator < already exists 2005-12-21 16:46:34 ERROR: operator <= already exists 2005-12-21 16:46:34 ERROR: operator = already exists 2005-12-21 16:46:34 ERROR: function "intersection" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "buffer" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "convexhull" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "difference" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "boundary" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "symdifference" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "symmetricdifference" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geomunion" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "memgeomunion" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "unite_garray" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geomunion" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "relate" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "relate" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "disjoint" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "touches" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "intersects" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "crosses" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "within" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "contains" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "overlaps" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "isvalid" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geosnoop" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "simplify" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "line_interpolate_point" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "ggeometry_consistent" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "ggeometry_compress" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "rtree_decompress" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "gbox_penalty" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "gbox_picksplit" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "gbox_union" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "gbox_same" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_union" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_inter" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "geometry_size" already exists with same argument types 2005-12-21 16:46:34 ERROR: operator class "gist_geometry_ops" for access method "gist" already exists 2005-12-21 16:46:34 ERROR: operator class "btree_geometry_ops" for access method "btree" already exists 2005-12-21 16:46:34 ERROR: cast from type public.geometry to type public.box3d already exists 2005-12-21 16:46:34 ERROR: cast from type public.geometry to type box already exists 2005-12-21 16:46:34 ERROR: cast from type public.box3d to type public.geometry already exists 2005-12-21 16:46:34 ERROR: cast from type text to type public.geometry already exists 2005-12-21 16:46:34 ERROR: cast from type public.wkb to type bytea already exists 2005-12-21 16:46:34 ERROR: cast from type public.box3d to type box already exists 2005-12-21 16:46:34 ERROR: cast from type public.geometry to type text already exists 2005-12-21 16:46:34 ERROR: user "gg33" does not exist 2005-12-21 16:46:34 ERROR: function "addgeometrycolumn" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "addgeometrycolumn" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "addgeometrycolumn" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "dropgeometrycolumn" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "dropgeometrycolumn" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "dropgeometrycolumn" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "dropgeometrytable" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "dropgeometrytable" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "dropgeometrytable" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "update_geometry_stats" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "update_geometry_stats" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "create_histogram2d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "build_histogram2d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "build_histogram2d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "explode_histogram2d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "estimate_histogram2d" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "assvg" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "assvg" already exists with same argument types 2005-12-21 16:46:34 ERROR: function "assvg" already exists with same argument types 2005-12-21 16:46:34 ERROR: user "gg11" does not exist 2005-12-21 16:46:35 ERROR: user "gg11" does not exist 2005-12-21 16:46:35 ERROR: user "gg33" does not exist 2005-12-21 16:46:35 ERROR: user "gg11" does not exist 2005-12-21 16:46:35 ERROR: user "gg33" does not exist 2005-12-21 16:46:36 ERROR: user "gg26" does not exist 2005-12-21 16:46:36 ERROR: user "gg33" does not exist 2005-12-21 16:46:36 ERROR: column "attrelid" of relation "geometry_columns" does not exist 2005-12-21 16:46:36 ERROR: user "gg11" does not exist 2005-12-21 16:46:36 ERROR: user "gg33" does not exist 2005-12-21 16:46:37 ERROR: user "gg26" does not exist 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_graphs_pkey" for table "pga_graphs" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_layout_pkey" for table "pga_layout" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_images_pkey" for table "pga_images" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_queries_pkey" for table "pga_queries" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_reports_pkey" for table "pga_reports" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_forms_pkey" for table "pga_forms" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_diagrams_pkey" for table "pga_diagrams" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_scripts_pkey" for table "pga_scripts" 2005-12-21 16:46:37 ERROR: user "gg33" does not exist 2005-12-21 16:46:37 ERROR: multiple primary keys for table "spatial_ref_sys" are not allowed 2005-12-21 16:46:37 ERROR: multiple primary keys for table "geometry_columns" are not allowed 2005-12-21 16:46:37 ERROR: user "gg11" does not exist 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_becken_typ_pkey" for table "def_becken_typ" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_ereignis_gruppe_pkey" for table"def_ereignis_gruppe" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_flaechen_gruppe_pkey" for table"def_flaechen_gruppe" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_flaechen_gruppe_variante_pkey"for table "def_flaechen_gruppe_variante" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_flaechen_szenario_pkey" for table"def_flaechen_szenario" 2005-12-21 16:46:37 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_knoten_typ_pkey" for table "def_knoten_typ" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_kostra_niederschlag_pkey" fortable "def_kostra_niederschlag" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_n_dauer_pkey" for table "def_n_dauer" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_n_jaehrlichkeit_pkey" for table"def_n_jaehrlichkeit" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_routing_szenario_pkey" for table"def_routing_szenario" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_routing_verfahren_pkey" for table"def_routing_verfahren" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ereignis_fläche_pkey" for table "knoten_ereignis" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_flaeche_pkey" for table "knoten_flaeche" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_pkey" for table "knoten" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_routing_pkey" for table "knoten_routing" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_verbindung_pkey" for table"knoten_verbindung" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "kostra_niederschlag_pkey" for table"kostra_niederschlag" 2005-12-21 16:46:38 ERROR: user "gg33" does not exist 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_becken_variante_pkey" for table"def_becken_variante" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_becken_pkey" for table "knoten_becken" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_becken_layout_pkey" for table"def_becken_layout" 2005-12-21 16:46:38 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "becken_varianten_pkey" for table "becken_varianten" 2005-12-21 16:46:39 ERROR: user "gg11" does not exist 2005-12-21 16:46:39 ERROR: user "gg33" does not exist 2005-12-21 16:46:39 ERROR: user "gg11" does not exist 2005-12-21 16:46:39 ERROR: user "gg33" does not exist 2005-12-21 16:46:39 ERROR: user "gg11" does not exist 2005-12-21 16:46:40 ERROR: user "gg33" does not exist 2005-12-21 16:46:40 ERROR: user "gg11" does not exist 2005-12-21 16:46:40 ERROR: user "gg33" does not exist
On 12/21/05, Oleg <evdakov@iwk.uka.de> wrote: > Thanks a lot. Here is the copy of the log file. > There are some lines that could be important: > column "attrelid" of relation "geometry_columns" does not exist > multiple primary keys for table "spatial_ref_sys" are not allowed > multiple primary keys for table "geometry_columns" are not allowed > > Best regards > Oleg > >> > > > >psql -d mydb -U postgres -f dumpfile.sql 2> output.txt > > -- output.txt -- > > 2005-12-21 16:46:32 ERROR: user "gg33" does not exist a pg_dumped file doesn't contain any users you have to create them yourself this is, i think, the only problem you have to take actions for... create the users at hand > 2005-12-21 16:46:32 ERROR: function "plpgsql_call_handler" already exists with same argument types > 2005-12-21 16:46:32 ERROR: language "plpgsql" already exists doesn't matter, just telling you that the language plpgsql is already installed > 2005-12-21 16:46:33 ERROR: user "gg26" does not exist > 2005-12-21 16:46:33 ERROR: user "gg33" does not exist > 2005-12-21 16:46:33 ERROR: function "histogram2d_in" already exists with same argument types > 2005-12-21 16:46:33 ERROR: function "histogram2d_out" already exists with same argument types > 2005-12-21 16:46:33 ERROR: type "histogram2d" already exists > 2005-12-21 16:46:33 ERROR: function "box3d_in" already exists with same argument types doesn't matter, just telling you that postgis' functions and types are already installed (i can be wrong on this one, but i don't think so) [... a lot of the same errors...] > -- output.txt -- -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)
Jaime Thank you very much for your help Best regards Oleg Jaime Casanova schrieb: >On 12/21/05, Oleg <evdakov@iwk.uka.de> wrote: > > >>Thanks a lot. Here is the copy of the log file. >>There are some lines that could be important: >>column "attrelid" of relation "geometry_columns" does not exist >>multiple primary keys for table "spatial_ref_sys" are not allowed >>multiple primary keys for table "geometry_columns" are not allowed >> >>Best regards >>Oleg >> >> >>>psql -d mydb -U postgres -f dumpfile.sql 2> output.txt >>> >>> >>> >-- output.txt -- > > >>2005-12-21 16:46:32 ERROR: user "gg33" does not exist >> >> > >a pg_dumped file doesn't contain any users you have to create them yourself > >this is, i think, the only problem you have to take actions for... >create the users at hand > > > >>2005-12-21 16:46:32 ERROR: function "plpgsql_call_handler" already exists with same argument types >>2005-12-21 16:46:32 ERROR: language "plpgsql" already exists >> >> > >doesn't matter, just telling you that the language plpgsql is already installed > > > >>2005-12-21 16:46:33 ERROR: user "gg26" does not exist >>2005-12-21 16:46:33 ERROR: user "gg33" does not exist >>2005-12-21 16:46:33 ERROR: function "histogram2d_in" already exists with same argument types >>2005-12-21 16:46:33 ERROR: function "histogram2d_out" already exists with same argument types >>2005-12-21 16:46:33 ERROR: type "histogram2d" already exists >>2005-12-21 16:46:33 ERROR: function "box3d_in" already exists with same argument types >> >> > >doesn't matter, just telling you that postgis' functions and types are >already installed (i can be wrong on this one, but i don't think so) > >[... a lot of the same errors...] > > > >-- output.txt -- > > >-- >Atentamente, >Jaime Casanova >(DBA: DataBase Aniquilator ;) > > >