From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Database Server in Recovery mode! |
Date: | 2002-04-25 07:10:12 |
Message-ID: | 3CC7ABD4.A104986F@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)system11 rmallah]$ psql -h 130.94.22.209 -Utradein
> tradein_clients
> psql: The Data Base System is in recovery mode
> [rmallah(at)system11 rmallah]$
>
>
>
>
> [root(at)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(at)linux10320 data]#
>
From | Date | Subject | |
---|---|---|---|
Next Message | Morten Sickel | 2002-04-25 09:32:40 | HAVING - clause |
Previous Message | Rajesh Kumar Mallah | 2002-04-25 07:06:28 | followups : Database Server in Recovery mode! |