Re: [GENERAL] Psql dosent log error messages on windows

2012-04-25 Thread Willy-Bas Loos
like so: http://support.microsoft.com/kb/110930 On Wed, Apr 25, 2012 at 2:27 PM, Willy-Bas Loos wrote: > the windows user that owns the process ("postgres" by default) needs to > have the right to write in the folder to write a server log. > by default, this user has very few privileges (for go

Re: [GENERAL] Psql dosent log error messages on windows

2012-04-25 Thread Willy-Bas Loos
the windows user that owns the process ("postgres" by default) needs to have the right to write in the folder to write a server log. by default, this user has very few privileges (for good reasons - security). about psql not writing that log: >> means to redirect "standard out" to a file. But "st

[GENERAL] Psql dosent log error messages on windows

2012-04-25 Thread Armand Turpel
When i execute a sql script trough psql, it shows me errors in the console window but it dosent write this errors in a log file. psql.exe -h localhost -d test -U postgres -w -f C:/test_files/test.sql >> C:/test_files/pg.log psql.exe -h localhost -d test -U postgres -w -f C:/test_files/test.sq