From d96398d1eb97fc3d18fb8f80b1ea09dd0af59489 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 31 Jan 2005 22:57:17 +0000 Subject: Restructure debug FAQ entry. --- doc/src/FAQ/FAQ.html | 38 ++++++++++++++------------------------ 1 file changed, 14 insertions(+), 24 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 8ea5f32443b..9c723943b12 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">
Last updated: Mon Jan 31 15:40:24 EST 2005
+Last updated: Mon Jan 31 17:57:02 EST 2005
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -519,29 +519,23 @@
PostgreSQL has several features that report status information - that can be valuable for debugging purposes.
+There are many log_*
server configuration variables
+ that enable printing of query and process statistics which can be
+ very useful for debugging and performance measurements.
First, by running configure with the --enable-cassert +
The following detailed debug instructions are to be used to + provide more detailed information for server developers debugging a + problem
+ +It is also possible to debug the server if it isn't operating + properly. First, by running configure with the --enable-cassert option, many assert()s monitor the progress of the backend and halt the program when something unexpected occurs.
-Both postmaster and postgres have several debug - options available. First, whenever you start postmaster, - make sure you send the standard output and error to a log file, - like:
-- cd /usr/local/pgsql - ./bin/postmaster >server.log 2>&1 & -- -
This will put a server.log file in the top-level PostgreSQL - directory. This file contains useful information about problems or - errors encountered by the server. Postmaster has a -d - option that allows even more detailed information to be reported. - The -d option takes a number that specifies the debug level. - Be warned that high debug level values generate large log - files.
+ The postmaster has a -d option that allows even more + detailed information to be reported. The -d option takes a + number that specifies the debug level. Be warned that high debug + level values generate large log files.If postmaster is not running, you can actually run the postgres backend from the command line, and type your @@ -565,10 +559,6 @@ the debugger, set any breakpoints, and continue through the startup sequence.
-There are several log_*
server configuration variables
- that enable printing of process statistics which can be very useful
- for debugging and performance measurements.
You can also compile with profiling to see what functions are taking execution time. The backend profile files will be deposited in the pgsql/data/base/dbname directory. The client profile -- cgit v1.2.3