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 ;)