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