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 "standard error" is not affected by that. add 2>&1 to write errors to that log too. hth, WBL On Wed, Apr 25, 2012 at 2:11 PM, Armand Turpel <armand.turpel.m...@gmail.com > wrote: > 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.sql -o > C:/test_files/pg.log > > Configuration settings : > log_destination = 'stderr,eventlog,csvlog' > logging_collector = on > client_min_messages = notice > log_min_messages = warning > > The server is started as : > > pg_ctl.exe -l "C:/test_files/log/pg.log" -D "C:/pgsql_9_1_1/data" start > > Also no error messages this log file. > But the errors are in the eventlog of windows. > > Thanks for help. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> > -- "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
