Re: How do I view the logs?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Guy Fraser <guy(at)incentre(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: How do I view the logs?
Date: 2003-05-15 15:45:46
Message-ID: 20030515154546.4EEBB103C2@polaris.pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Flores Prior 2003-05-15 15:50:41 Re: - what protocol for an Internet postgres
Previous Message Daniel Gehrke 2003-05-15 15:41:57 MS SQL "isDate" equivalent in plpgsql?