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:07:06
Message-ID: 43A96F9A.5030904@iwk.uka.de (view raw or flat)
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: psql_output.txt
Description: text/plain (1.5 KB)

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2005-12-21 15:18:40
Subject: Re: transfer database from Linux to Windows
Previous:From: Tjibbe RijpmaDate: 2005-12-21 14:48:40
Subject: Re: Small function in PLPGSQL

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