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:07:06 |
Message-ID: | 43A96F9A.5030904@iwk.uka.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
Jaime Casanova schrieb:
>On 12/20/05, Jaime Casanova <systemguards(at)gmail(dot)com> wrote:
>
>
>>On 12/20/05, Oleg <evdakov(at)iwk(dot)uka(dot)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 ;)
>
>
>
Attachment | Content-Type | Size |
---|---|---|
psql_output.txt | text/plain | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-12-21 15:18:40 | Re: transfer database from Linux to Windows |
Previous Message | Tjibbe Rijpma | 2005-12-21 14:48:40 | Re: Small function in PLPGSQL |