From d96398d1eb97fc3d18fb8f80b1ea09dd0af59489 Mon Sep 17 00:00:00 2001
From: Bruce Momjian 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 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: 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.Frequently Asked Questions (FAQ) for PostgreSQL
- 3.4) What debugging features are
available?
- log_*
server configuration variables
+ that enable printing of query and process statistics which can be
+ very useful for debugging and performance measurements.
- cd /usr/local/pgsql
- ./bin/postmaster >server.log 2>&1 &
-
-
-
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