Hello!

I'm trying to add some features to PostgreSQL, but I just can't figure out how to make gdb work with it.


I attach gdb to /usr/.../bin/postgres, then I put a breakpoint. Whenever postgres stop on that breakpoint, it just kills/restarts the server instead of asking me what to do.

It's surely a noob's question but how can I use a debugger with PostegreSQL?

Regards,
Jonathan Scher

(gdb) file  /usr/local/pgsql/bin/postgres
Reading symbols from /usr/local/pgsql/bin/postgres...(no debugging symbols found)...done.
(gdb) set args -D /home/heziva/pgsql/pgsql_data/
(gdb) b transformFromClause
Breakpoint 1 at 0x80e371e
(gdb) r
Starting program: /usr/local/pgsql/bin/postgres -D /home/heziva/pgsql/pgsql_data/ (no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...LOG: database system was interrupted; last known up at 2007-03-12 18:04:04 UTC
LOG:  checkpoint record is at 0/481504
LOG:  redo record is at 0/481504; shutdown TRUE
LOG:  next transaction ID: 0/710; next OID: 16392
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 0/481544
LOG:  redo is not required
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

=====> on another shell.... psql....\d

(gdb) file  /usr/local/pgsql/bin/postgres
Reading symbols from /usr/local/pgsql/bin/postgres...(no debugging symbols found)...done.
(gdb) set args -D /home/heziva/pgsql/pgsql_data/
(gdb) b transformFromClause
Breakpoint 1 at 0x80e371e
(gdb) r
Starting program: /usr/local/pgsql/bin/postgres -D /home/heziva/pgsql/pgsql_data/ (no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...LOG: database system was interrupted; last known up at 2007-03-12 18:04:04 UTC
LOG:  checkpoint record is at 0/481504
LOG:  redo record is at 0/481504; shutdown TRUE
LOG:  next transaction ID: 0/710; next OID: 16392
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 0/481544
LOG:  redo is not required
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started





---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to