Re: killing process question

--i knew this was going to happen.

--tried to kill a proc and the database went
--into recovery mode.

--i tried to put the rotatelogs portion in the
--startup script and got a message about
--putting the rotatelogs into the httpd.conf file.

--i can see that today is going to be a long day.

--thanks for all the help and good info.

-X

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> --generally speaking, how long should this run?

> (gdb) attach 3488
> Attaching to program: /usr/bin/postgres, process 3488

Not very long --- it takes a couple seconds, for me, on a machine that's
not fast by today's standards.

> --i know i should be patient, but i'm trying to figure
> --out if this should take more than 20 minutes or if
> --i've done something wrong. (OR, should that be postmaster
> --and not postgres in the above line?)

postgres is correct. But are you sure that you are pointing to the same
postgres executable that the process is running? Perhaps gdb could get
confused if you point to the wrong version.

regards, tom lane