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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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" for table "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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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
>
>
>


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org