pg_ctl stop does not work.
От | Rajesh Kumar Mallah. |
---|---|
Тема | pg_ctl stop does not work. |
Дата | |
Msg-id | 200205101725.17147.mallah@trade-india.com обсуждение исходный текст |
Ответ на | postmaster dead now !! ("Rajesh Kumar Mallah." <mallah@trade-india.com>) |
Список | pgsql-sql |
Hi Folks, Please tell me how to bring down postgresql system , the postmaster is dead but some backends still seems to be running... Please Help , i do not want to loose data again !! [root@linux10320 root2]# su - postgres bash-2.03$ pg_ctl stop /usr/local/pgsql/bin/pg_ctl: kill: (5597) - No such pid waiting for postmaster to shut down................................................................ failed pg_ctl: postmaster does not shut down bash-2.03$ On Friday 10 May 2002 05:13 pm, Rajesh Kumar Mallah. wrote: > Hi > my postmaster died just now, > > only a bunch of backends running > > [rmallah@server rmallah]$ psql -h 130.94.22.209 -U tradein > tradein_clients psql: could not connect to server: Connection refused > Is the server running on host 130.94.22.209 and accepting > TCP/IP connections on port 5432? > [rmallah@server rmallah]$ > > output of ps > ============ > > [root@linux10320 root2]# ps auxwww| grep post > postgres 5598 0.0 0.0 140412 4 ? D May07 2:31 postgres: > stats buffer process > postgres 5599 1.1 0.0 142396 20 ? R May07 48:48 postgres: > stats collector process > postgres 12262 0.0 0.0 238712 4 ? D May09 0:19 postgres: > tradein tradein_clients 130.94.20.27 SELECT > postgres 13039 0.0 0.0 139812 4 ? D May09 0:00 postgres: > checkpoint subprocess > postgres 29440 0.0 0.8 140664 9256 ? S 14:35 0:01 postgres: > tradein tradein_clients 203.196.129.235 idle > postgres 6805 0.0 0.0 140196 4 ? S 16:08 0:00 postgres: > tradein tradein_clients 203.196.129.235 idle > postgres 10154 0.0 0.0 140196 4 ? S 16:38 0:00 postgres: > tradein tradein_clients 203.196.129.235 idle > postgres 10446 0.0 0.0 140164 4 ? S 16:43 0:00 postgres: > postgres tradein_clients 203.196.129.235 idle > [root@linux10320 root2]# > > ============= > output of top > ============= > 5:29pm up 3 days, 24 min, 4 users, load average: 5.68, 5.61, 5.70 > 54 processes: 52 sleeping, 2 running, 0 zombie, 0 stopped > CPU states: 5.8% user, 44.3% system, 0.0% nice, 49.8% idle > Mem: 1028484K av, 900084K used, 128400K free, 0K shrd, 2968K > buff Swap: 971004K av, 99288K used, 871716K free > 857220K cached > > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND > 5599 postgres 17 0 2064 20 20 R 0 99.9 0.0 53:25 > postmaster 5598 postgres 9 0 1440 4 4 D 0 0.0 0.0 > 2:31 postmaster 12262 postgres 9 0 88564 4 4 D 0 0.0 0.0 > 0:19 postmaster 13039 postgres 9 0 656 4 4 D 0 0.0 > 0.0 0:00 postmaster 29440 postgres 9 0 10512 9256 9256 S 0 > 0.0 0.8 0:01 postmaster 6805 postgres 9 0 972 4 4 S 0 > 0.0 0.0 0:00 postmaster 10154 postgres 9 0 968 4 4 S > 0 0.0 0.0 0:00 postmaster 10446 postgres 9 0 964 4 4 S > 0 0.0 0.0 0:00 postmaster > ==========================================================================
В списке pgsql-sql по дате отправления: