pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: PostgResql SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Database Server in Recovery mode!
Date: Fri, 26 Apr 2002 11:13:49 +0530
Message-ID: <3CC8E914.713ADA51@trade-india.com> (raw)
References: <20020425073615.M63157-100000@megazone23.bigpanda.com>

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




view thread (4+ messages)

Message-ID: <3CC8E914.713ADA51@trade-india.com>
Permalink:  ../3CC8E914.713ADA51@trade-india.com/
Also on:    postgresql.org/message-id/3CC8E914.713ADA51@trade-india.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mallah@trade-india.com, sszabo@megazone23.bigpanda.com
  Subject: Re: Database Server in Recovery mode!
  In-Reply-To: <3CC8E914.713ADA51@trade-india.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox