From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
---|---|
To: | Armand Turpel <armand(dot)turpel(dot)mnhn(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Psql dosent log error messages on windows |
Date: | 2012-04-25 12:30:30 |
Message-ID: | CAHnozTjqkx7CBpVMrjHpA6V65Xt1crN7iv6FGipyOhHcozjr2A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
like so:
http://support.microsoft.com/kb/110930
On Wed, Apr 25, 2012 at 2:27 PM, Willy-Bas Loos <willybas(at)gmail(dot)com> 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 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(dot)turpel(dot)mnhn(at)gmail(dot)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(at)postgresql(dot)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
>
>
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
From | Date | Subject | |
---|---|---|---|
Next Message | Larry J Prikockis | 2012-04-25 13:36:16 | postgresql log parsing to report on user/db access |
Previous Message | Willy-Bas Loos | 2012-04-25 12:27:44 | Re: Psql dosent log error messages on windows |