From 00283f4b0a080945962d31d71b3a9f8b511083d8 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 9 May 2005 17:24:04 +0000 Subject: Backpatch FAQ's to 8.0.X for release. --- doc/src/FAQ/FAQ_DEV.html | 57 +++++++++++++++++++++++++++++++++++++++++++----- 1 file changed, 52 insertions(+), 5 deletions(-) (limited to 'doc/src/FAQ/FAQ_DEV.html') diff --git a/doc/src/FAQ/FAQ_DEV.html b/doc/src/FAQ/FAQ_DEV.html index 111fb12a0c8..ded9c722e7a 100644 --- a/doc/src/FAQ/FAQ_DEV.html +++ b/doc/src/FAQ/FAQ_DEV.html @@ -13,7 +13,7 @@

Developer's Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sun Mar 13 22:07:18 EST 2005

+

Last updated: Fri May 6 13:47:54 EDT 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -44,8 +44,8 @@ 1.10) What books are good for developers?
1.11) What is configure all about?
1.12) How do I add a new port?
- 1.13) Why don't you use threads/raw - devices/async-I/O, <insert your favorite wizz-bang feature + 1.13) Why don't you use threads, raw + devices, async-I/O, <insert your favorite wizz-bang feature here>?
1.14) How are RPM's packaged?
1.15) How are CVS branches handled?
@@ -71,6 +71,8 @@ pfree() to allocate memory?
2.6) What is ereport()?
2.7) What is CommandCounterIncrement()?
+ 2.8) What debugging features are available?
+

@@ -230,6 +232,12 @@

There have been a number of discussions about other testing frameworks and some developers are exploring these ideas.

+

Keep in mind the Makefiles do not have the proper + dependencies for include files. You have to do a make clean + and then another make. If you are using GCC + you can use the --enable-depend option of configure + to have the compiler compute the dependencies automatically.

+

1.9) What tools are available for developers?

@@ -422,8 +430,8 @@ handling. There is a backend/port directory if you need special files for your OS.

-

1.13) Why don't you use threads/raw - devices/async-I/O, <insert your favorite wizz-bang feature +

1.13) Why don't you use threads, raw + devices, async-I/O, <insert your favorite wizz-bang feature here>?

There is always a temptation to use the newest operating system @@ -941,6 +949,45 @@ modified by previous pieces. CommandCounterIncrement() increments the Command Counter, creating a new part of the transaction.

+ +

2.8) What debugging features are + available?

+ +

First, try running configure with the --enable-cassert + option, many assert()s monitor the progress of the backend + and halt the program when something unexpected occurs.

+ +

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 the postmaster is not running, you can actually run the + postgres backend from the command line, and type your + SQL statement directly. This is recommended + only for debugging purposes. If you have compiled with debugging + symbols, you can use a debugger to see what is happening. Because + the backend was not started from postmaster, it is not + running in an identical environment and locking/backend interaction + problems may not be duplicated.

+ +

If the postmaster is running, start psql in one + window, then find the PID of the postgres + process used by psql using SELECT pg_backend_pid(). + Use a debugger to attach to the postgres PID. + You can set breakpoints in the debugger and issue queries from + + psql. If you are debugging postgres startup, you can + set PGOPTIONS="-W n", then start psql. This will cause startup + to delay for n seconds so you can attach to the process with + the debugger, set any breakpoints, and continue through the startup + sequence.

+ +

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 + file will be put in the client's current directory. Linux requires + a compile with -DLINUX_PROFILE for proper profiling.

-- cgit v1.2.3