Skip site navigation (1) Skip section navigation (2)

Re: transfer database from Linux to Windows

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Oleg <evdakov(at)iwk(dot)uka(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: transfer database from Linux to Windows
Date: 2005-12-21 17:19:32
Message-ID: c2d9e70e0512210919s12ee30des7232d24e6ee66ff7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 12/21/05, Oleg <evdakov(at)iwk(dot)uka(dot)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 ;)

In response to

Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-12-21 17:40:10
Subject: Re: Postgresql v 8.0.1-3 problems
Previous:From: A. KretschmerDate: 2005-12-21 17:14:22
Subject: Re: plpgsql function returning SETOF

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group