On Thursday 15 May 2003 4:24 pm, 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.
The log files in .../data/ are probably your transaction logs.
Log files for you to read are probably in /var/log. There are two ways to log
using PostgreSQL:
1. Via syslogd (if you've made the settings in postgresql.conf)
2. To a file (by redirecting output on startup)
See the Administrator's Guide, sections 3.3,3.4,8.4 for more details.
--
Richard Huxton