Hmm..
was it this simple! thanks
what does -INT signal do btw ??
I will try it next time when ( god forbids my database server crashes again
)
mallah.
Stephan Szabo wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster