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

Re: transfer database from Linux to Windows

From: Oleg <evdakov(at)iwk(dot)uka(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: transfer database from Linux to Windows
Date: 2005-12-22 12:06:12
Message-ID: 43AA96B4.6080500@iwk.uka.de (view raw or flat)
Thread:
Lists: pgsql-novice
Jaime
Thank you very much for your help
Best regards
Oleg

Jaime Casanova schrieb:

>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

pgsql-novice by date

Next:From: Volkan YAZICIDate: 2005-12-22 14:54:53
Subject: Re: problem with nasty latin2 sorting
Previous:From: Tom LaneDate: 2005-12-21 23:40:44
Subject: Re: [HACKERS] problem with nasty latin2 sorting

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