Thread: How do I view the logs?
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
On Thu, 15 May 2003, 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 You can use whatever editor or file content viewing program you normally use. Or at your shell prompt use something like: tail -f logfilename -- Nigel J. Andrews
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
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
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 > > > >