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-21 15:49:38
Message-ID: 43A97992.5010802@iwk.uka.de (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)iwk(dot)uka(dot)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 ;)
>
>  
>

Attachment: psql_output.txt
Description: text/plain (28.6 KB)

In response to

Responses

pgsql-novice by date

Next:From: Johannes BrgmannDate: 2005-12-21 15:54:43
Subject: plpgsql function returning SETOF
Previous:From: Jaime CasanovaDate: 2005-12-21 15:18:40
Subject: Re: transfer database from Linux to Windows

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