Skip site navigation (1) Skip section navigation (2)

Re: transfer database from Linux to Windows

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Oleg <evdakov(at)iwk(dot)uka(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: transfer database from Linux to Windows
Date: 2005-12-21 15:18:40
Message-ID: c2d9e70e0512210718i6e9d4034jc193c567459c7e65@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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 ;)

In response to

Responses

pgsql-novice by date

Next:From: OlegDate: 2005-12-21 15:49:38
Subject: Re: transfer database from Linux to Windows
Previous:From: OlegDate: 2005-12-21 15:07:06
Subject: Re: transfer database from Linux to Windows

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