Re: Database Server in Recovery mode!

On Thu, 25 Apr 2002, Rajesh Kumar Mallah wrote:

> oops forgot to post the ps auxwww | grep "post"
>
> bash-2.03$ ps auxwww| grep post
> postgres  3901  3.4  1.3 141068 13868 ?      D    12:05   1:29 postgres:
> tradein tradein_clients 130.94.20.27 COPY
> root      6476  0.0  0.0  2156  888 pts/3    S    12:39   0:00 su -
> postgres
> postgres  6478  0.0  0.1  2004 1168 pts/3    S    12:39   0:00 -bash
> postgres  7058  0.0  0.3 139200 3780 pts/3   S    12:44   0:00
> /usr/bin/postmaster -D /var/lib/pgsql/data
> postgres  7059  0.3  1.9 140808 19688 pts/3  D    12:44   0:00
> /usr/bin/postmaster -D /var/lib/pgsql/data
> postgres  7396  0.0  0.0  2324  696 pts/3    R    12:47   0:00 ps auxwww
>
> postgres  7397  0.0  0.0  1360  512 pts/3    S    12:47   0:00 grep post
>
> bash-2.03$
>
> hmmm.  two postmasters ??
>
> and perhaps the   "postgres: tradein tradein_clients 130.94.20.27 COPY"
> is the guilty one
>
> how do i get rid of that ...

I believe you want
kill -INT 3901
to get rid of the backend.