Skip site navigation (1) Skip section navigation (2)

Re: Psql dosent log error messages on windows

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:27:44
Message-ID: CAHnozTgvTuzkNm-4hbSZD_8ObdiGehmO0e1g9WTHip_EAtYGOA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: Willy-Bas LoosDate: 2012-04-25 12:30:30
Subject: Re: Psql dosent log error messages on windows
Previous:From: Armand TurpelDate: 2012-04-25 12:11:35
Subject: Psql dosent log error messages on windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group