From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
Cc: | PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Database Server in Recovery mode! |
Date: | 2002-04-25 14:37:51 |
Message-ID: | 20020425073615.M63157-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-04-25 14:43:28 | Re: Connection authentication |
Previous Message | Jan Wieck | 2002-04-25 13:53:19 | Re: SELECT in a function != SELECT ? |