Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: logging

Posted on 2008-10-04 00:16:11 by Marc Fromm

--_000_B0D7C0A3F35FE144A70312D086CBCA9BF75C2048ExchMailbox2u ni_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We would like to log sql activity from our web pages that use postgresql da=
tabases.
I read the documentation for 8.1 at postgresql.org. The postgresql.conf fil=
e under the -Where to log- section has
#log_destination =3D 'stderr'
Is stderr the default or do I need to remove the comment symbol to actually=
start logging to stderr?
Are there recommended settings for all the different items in where to log,=
when to log, and what to log?

Our goal is to capture errors like when someone claims to have submitted da=
ta, yet it is not in the database, and the record count skips an increment-=
5360 then 5362, missing 5361.

Thanks


Marc


--_000_B0D7C0A3F35FE144A70312D086CBCA9BF75C2048ExchMailbox2u ni_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>We would like to log sql activity from our web pages tha=
t
use postgresql databases.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>I read the documentation for 8.1 at postgresql.org. The
postgresql.conf file under the -Where to log- section has<o:p></o:p></span>=
</font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>#log_destination =3D 'stderr' <o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>Is stderr the default or do I need to remove the comment
symbol to actually start logging to stderr?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>Are there recommended settings for all the different ite=
ms
in where to log, when to log, and what to log?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>Our goal is to capture errors like when someone claims t=
o
have submitted data, yet it is not in the database, and the record count sk=
ips
an increment&#8212;5360 then 5362, missing 5361.<o:p></o:p></span></font></=
p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>Thanks<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span style=3D'fon=
t-size:10.0pt;
font-family:"Courier New"'>Marc</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D=
'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

--_000_B0D7C0A3F35FE144A70312D086CBCA9BF75C2048ExchMailbox2u ni_--

Report this message

#2: Re: logging

Posted on 2008-10-06 10:17:26 by system

This is a multi-part message in MIME format.
--------------030903000704000907000400
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

yes, remove the comment character.

And further more, find my email post with subject "log_statement at
postgres.conf"

Regards,
Joko [IT/EDP]
PT. Indra Jaya Swastika
Phone: +62 31 7481388 Ext 201
http://www.ijs.co.id



Marc Fromm wrote:
>
> We would like to log sql activity from our web pages that use
> postgresql databases.
>
> I read the documentation for 8.1 at postgresql.org. The
> postgresql.conf file under the -Where to log- section has
>
> #log_destination = 'stderr'
>
> Is stderr the default or do I need to remove the comment symbol to
> actually start logging to stderr?
>
> Are there recommended settings for all the different items in where to
> log, when to log, and what to log?
>
>
>
> Our goal is to capture errors like when someone claims to have
> submitted data, yet it is not in the database, and the record count
> skips an increment---5360 then 5362, missing 5361.
>
>
>
> Thanks
>
>
>
>
>
> Marc
>
>
>


--
If you have any problem with our services ,
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388

--------------030903000704000907000400
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
yes, remove the comment character.<br>
<br>
And further more, find my email post with subject "log_statement at
postgres.conf"<br>
<br>
<pre class="moz-signature" cols="72">Regards,
Joko [IT/EDP]
PT. Indra Jaya Swastika
Phone: +62 31 7481388 Ext 201
<a class="moz-txt-link-freetext" href="http://www.ijs.co.id">http://www.ijs.co.id</a></pre>
<br>
<br>
Marc Fromm wrote:
<blockquote
cite="mid:B0D7C0A3F35FE144A70312D086CBCA9BF75C2048@ExchMailb ox2.univ.dir.wwu.edu"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">We would like to log sql
activity from our web pages that
use postgresql databases.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">I read the documentation
for 8.1 at postgresql.org. The
postgresql.conf file under the -Where to log- section has<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">#log_destination =
'stderr' <o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Is stderr the default or
do I need to remove the comment
symbol to actually start logging to stderr?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Are there recommended
settings for all the different items
in where to log, when to log, and what to log?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Our goal is to capture
errors like when someone claims to
have submitted data, yet it is not in the database, and the record
count skips
an increment&#8212;5360 then 5362, missing 5361.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Thanks<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p>&nbsp;</o:p></span></font></p>
<p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: &quot;Courier New&quot;;">Marc</span></font><o:p></o:p></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;"><o:p>&nbsp;</o:p></span></font></p>
</div>
</blockquote>
</body>
</html>


<html>
<br>
--<br>
If you have any problem with our services ,<br>
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id<br>
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388</html>

--------------030903000704000907000400--

Report this message