Re: transfer database from Linux to Windows - Mailing list pgsql-novice

always cc: list

On 12/21/05, Oleg <evdakov@iwk.uka.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 ;)