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: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

Browse pgsql-novice by date

  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