Re: How do I view the logs? - Mailing list pgsql-general

From Guy Fraser
Subject Re: How do I view the logs?
Date
Msg-id 3EC3EAA2.10908@incentre.net
Whole thread Raw
In response to How do I view the logs?  (Guy Fraser <guy@incentre.net>)
List pgsql-general
Thank you,

That was what I was looking for.

Ends up it was /var/log/pgsql, which makes sense, but I somehow thought
I should be able to see the
data from pg_xlog, but I guess that data is not usefull, since I am not
into S&M. :-)

Guy

Steve Crawford wrote:

>An unfortunate problem - the word "log" is overloaded and can be either
>transaction logs or "system" logs.
>
>If you ended up looking at pg_xlog files, there is generally no need to view
>those - they will be gibberish to anyone other than a developer with
>masochistic tendencies.
>
>If you are looking for the "syslog" type of logs, check in postgresql.conf
>and see how the logging is performed. It can go to stdout, a file, or to the
>syslog facility. Once you have determined where your configuration is set to
>put your log files, look there. They are plain text files - use your favorite
>viewer.
>
>Cheers,
>Steve
>
>
>On Thursday 15 May 2003 8:24 am, Guy Fraser wrote:
>
>
>>Where are the logs?
>>
>>I have seen logfiles in the data directory as well as sytem tables, but
>>haven't figured out how to view them.
>>
>>Any help would be appreciated.
>>
>>Guy
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>subscribe-nomail command to majordomo@postgresql.org so that your
>>message can get through to the mailing list cleanly
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>



pgsql-general by date:

Previous
From: "Hegyvari Krisztian"
Date:
Subject: client tool
Next
From: Adam Sherman
Date:
Subject: Re: Choosing a Transaction Isolation Level