pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase 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>
2002-04-25 07:10 ` Re: Database Server in Recovery mode! 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 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 ` Re: Database Server in Recovery mode! Stephan Szabo <sszabo@megazone23.bigpanda.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 06:52 Database Server in Recovery mode! Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-25 07:10 ` Re: Database Server in Recovery mode! Rajesh Kumar Mallah <mallah@trade-india.com>
@ 2002-04-25 14:37 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-04-26 05:43 ` Re: Database Server in Recovery mode! 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-25 06:52 Database Server in Recovery mode! Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-25 07:10 ` Re: Database Server in Recovery mode! Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-25 14:37 ` Re: Database Server in Recovery mode! Stephan Szabo <sszabo@megazone23.bigpanda.com>
@ 2002-04-26 05:43 ` Rajesh Kumar Mallah <mallah@trade-india.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