pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database Server in Recovery mode!
4+ messages / 2 participants
[nested] [flat]

* Database Server in Recovery mode!
@ 2002-04-25 06:52  Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Rajesh Kumar Mallah @ 2002-04-25 06:52 UTC (permalink / raw)
  To: pgsql-sql

Hi Friends

please help.

my database server has gone in recovery mode for some
reasons i donot know.

what is the possible steps one shud take to bring the database
up to an usable state in minimum time.


Below is the message when i try to connect.

the the out put of ps in the database server.


regds
mallah.



[rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein
tradein_clients
psql: The Data Base System is in recovery mode
[rmallah@system11 rmallah]$




[root@linux10320 data]# ps auxwww | grep post
postgres  1839  0.0  0.0 138992 856 ?        S    Apr12   2:43
/usr/bin/postmaster -D /var/lib/pgsql/data
postgres  3901  6.0  1.4 141068 15248 ?      D    12:05   1:29 postgres:
tradein tradein_clients 130.94.20.27 COPY
root      5862  0.0  0.0  1360  512 pts/3    S    12:29   0:00 grep post

[root@linux10320 data]#

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database Server in Recovery mode!
@ 2002-04-25 07:10  Rajesh Kumar Mallah <mallah@trade-india.com>
  parent: Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Rajesh Kumar Mallah @ 2002-04-25 07:10 UTC (permalink / raw)
  To: pgsql-sql


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 ...

anyway heading for a reboot becoz this is a live server !
(am i risking  data loss?? here )

regds
mallah.



Rajesh Kumar Mallah wrote:

> Hi Friends
>
> please help.
>
> my database server has gone in recovery mode for some
> reasons i donot know.
>
> what is the possible steps one shud take to bring the database
> up to an usable state in minimum time.
>
>
> Below is the message when i try to connect.
>
> the the out put of ps in the database server.
>
>
> regds
> mallah.
>
>
>
> [rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein
> tradein_clients
> psql: The Data Base System is in recovery mode
> [rmallah@system11 rmallah]$
>
>
>
>
> [root@linux10320 data]# ps auxwww | grep post
> postgres  1839  0.0  0.0 138992 856 ?        S    Apr12   2:43
> /usr/bin/postmaster -D /var/lib/pgsql/data
> postgres  3901  6.0  1.4 141068 15248 ?      D    12:05   1:29
> postgres: tradein tradein_clients 130.94.20.27 COPY
> root      5862  0.0  0.0  1360  512 pts/3    S    12:29   0:00 grep
> post
> [root@linux10320 data]#
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database Server in Recovery mode!
@ 2002-04-25 14:37  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Stephan Szabo @ 2002-04-25 14:37 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: 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.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database Server in Recovery mode!
@ 2002-04-26 05:43  Rajesh Kumar Mallah <mallah@trade-india.com>
  parent: Stephan Szabo <sszabo@megazone23.bigpanda.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Rajesh Kumar Mallah @ 2002-04-26 05:43 UTC (permalink / raw)
  To: Stephan Szabo <sszabo@megazone23.bigpanda.com>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2002-04-26 05:43 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-25 06:52 Database Server in Recovery mode! Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-25 07:10 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-25 14:37   ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-04-26 05:43     ` Rajesh Kumar Mallah <mallah@trade-india.com>

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