Skip site navigation (1) Skip section navigation (2)

How can the error log be searched?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How can the error log be searched?
Date: 2008-12-29 19:28:13
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03DBF240C@server.rad-con.local (view raw or flat)
Thread:
Lists: pgsql-general
Greetings!

A customer reported an error generated by our database.  However, many
of our functions have errors in RAISE EXCEPTION statements, in which the
% character was omitted.  The error message the customer saw was
complaining that there were too many arguments to a RAISE statement.  We
were able to find the function that was throwing the error by using
PGAdmin, opening the Server Status window, going to the Log File tab,
and finding approximately when the error occurred.  

But it would have been easier to find the problem if we could have
searched the logs.  There's no search function in the log file window.
Also, there's no apparent way to export the file.  Also, I can't even
use copy and paste.  So, how can I export the error messages into a
searchable text file?

Thanks very much!

RobR

In response to

Responses

pgsql-general by date

Next:From: Adrian KlaverDate: 2008-12-29 21:27:03
Subject: Re: How can the error log be searched?
Previous:From: Bayless KirtleyDate: 2008-12-29 17:20:47
Subject: Re: open transaction?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group