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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
psql_output.txt | text/plain | 28.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Johannes Brgmann | 2005-12-21 15:54:43 | plpgsql function returning SETOF |
Previous Message | Jaime Casanova | 2005-12-21 15:18:40 | Re: transfer database from Linux to Windows |