Hi All,
Here are some stupid questions. Please don't get
annoyed answering them.
(1) I ran postgres in interactive mode. it showed me
"backend>" prompt. now how to get out of it? I tried
q,quit,stop, shutdown etc but it did not worked.
(2) now the problem is the process is running in the
backend and now if I start postmaster again it gives
me the following error
//
pg_ctl: Cannot restart postmaster. postgres is
running (pid: 5559)
Please terminate postgres and try again.
//
I tried
kill 'cat
/usr/dcs/projects/cs411/cs411g4/pgsql/data/postmaster.pid'
but following error came
kill: Arguments should be jobs or process id's.
then I tried
kill -9 5559
but it gives me following message
5559: No such process
The postmaster.pid file exist in the data directory
and the cat command shows me this
-5559
/usr/dcs/projects/cs411/cs411g4/pgsql/data
so How to stop this process?
(3) Please can you give me the sequence of commands
for running postgres in debugging mode . I have to
trace query execution right from ProcessQuery()
function in postgres.c. FAQ's item 3.7 gives
description only which is not for me who is not a unix
guru.
I tried gdb postgres
then run -B 32 -d 5 mp2
I lost my gdb prompt and I was under backend>
and could not get out of it
(4) I suggest if you can post some where a sample
session describing the debugging process etc. it will
help a lot for people like me who has just stepped
into the postgreSQL.
Thanks in advance for your help and time
Regards
Amit khare
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com