Thread: Psql dosent log error messages on windows

Psql dosent log error messages on windows

From
Armand Turpel
Date:
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.

Re: Psql dosent log error messages on windows

From
Willy-Bas Loos
Date:
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.mnhn@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



--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Re: Psql dosent log error messages on windows

From
Willy-Bas Loos
Date:
like so:
http://support.microsoft.com/kb/110930


On Wed, Apr 25, 2012 at 2:27 PM, Willy-Bas Loos <willybas@gmail.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.turpel.mnhn@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



--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth




--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth